FluorinFx+AspNet+SQL 通信

好友QQ:150935477

 

 

 

GetUserList.mxml

/*====================================================*/

 

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="horizontal">
    <mx:Style >Application{  fontSize:12; paddingTop:60; backgroundGradientColors: #2F1D1D,#3F3F3F;  }</mx:Style>

     
    <mx:RemoteObject
        id="FlexDoNet_ServiceLibrary_Sample"
        source="FlexDoNet.ServiceLibrary.Sample"
        destination="fluorine"
        showBusyCursor="true">
        <mx:method name="GetTime" result="onGetTime(event)" />
        <mx:method name="GetUsers" result="onResult(event)" fault="onFault(event)" />
    </mx:RemoteObject>
   
    <mx:Script>
        <![CDATA[
           
            import mx.rpc.events.ResultEvent;
            import mx.rpc.events.FaultEvent;
            import mx.controls.Alert;
            import mx.collections.ArrayCollection;
           
            [Bindable]
            private var Userslist:ArrayCollection;
           
            internal function onGetTime(evt:ResultEvent):void
            {
                txtResult.text = evt.result.toString();
            }
           
            internal function onResult(evt:ResultEvent):void
            {
                Userslist = evt.result as ArrayCollection;
            }
           
            internal function onFault(evt:FaultEvent):void
            {
                Alert.show("Data Not Fount, maybe cause at : "+evt.message);
            }
           
        ]]>
    </mx:Script>
   
 <mx:Panel x="53" y="52" width="947" height="391" title="测试FluorineFx" fontSize="12" paddingTop="10" paddingLeft="10">
     <mx:Button x="35" y="63" label="获取时间" fontWeight="normal" click="FlexDoNet_ServiceLibrary_Sample.GetTime()" />
     <mx:Label x="35" y="95" text="结 果："/>
     <mx:TextInput x="35" y="123" width="260" id="txtResult"/>
     <mx:Button x="35" y="63" label="获取用户信息" fontWeight="normal" click="FlexDoNet_ServiceLibrary_Sample.GetUsers()" />
     <mx:Label x="35" y="95" text="结 果："/>
     <mx:DataGrid id="grid" dataProvider="{Userslist}">
         <mx:columns>
             <mx:DataGridColumn headerText="编号" dataField="UserId" />
             <mx:DataGridColumn headerText="用户" dataField="UserName" />
             <mx:DataGridColumn headerText="密码" dataField="Userpass" />
             <mx:DataGridColumn headerText="登录次数" dataField="UserLogins" />
             <mx:DataGridColumn headerText="最后登录IP" dataField="UserLastLoginIp" />
             <mx:DataGridColumn headerText="最后登录时间" dataField="UserLastLoginTime" />
             <mx:DataGridColumn headerText="添加时间" dataField="UserAddTime" />
             <mx:DataGridColumn headerText="角色" dataField="UserStatus" />
             <mx:DataGridColumn headerText="启用状态" dataField="UserFlag" />            
         </mx:columns>
     </mx:DataGrid>
 </mx:Panel>
   
</mx:Application>

 

 

User.sql

 

/****** 对象:  Table [dbo].[Lihua_User]    脚本日期: 01/07/2011 18:28:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Lihua_User](
    [UserId] [int] NOT NULL,
    [UserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [UserPass] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [UserLogins] [int] NULL,
    [UserLastLoginIp] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [UserLastLoginTime] [datetime] NULL,
    [UserAddTime] [datetime] NULL,
    [UserStatus] [int] NULL,
    [UserFlag] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

 

 

/****** 对象:  SqlHelper类   脚本日期: 01/07/2011 18:28:15 ******/

 

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace Flexzoo
{

    public static class SqlHelper
    {

        private static SqlConnection connection;
        public static SqlConnection Connection
        {
            get
            {
                string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                if (connection == null)
                {
                    connection = new SqlConnection(connectionString);
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Closed)
                {
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Broken)
                {
                    connection.Close();
                    connection.Open();
                }
                return connection;
            }
        }

        public static bool Exists(string safeSql)
        {
            return (GetDataTable(safeSql).Rows.Count > 0) ? true : false;
        }

        public static bool Exists(string safeSql, params SqlParameter[] values)
        {
            return (GetDataTable(safeSql,values).Rows.Count > 0) ? true : false;
        }

        public static int ExecuteCommand(string safeSql)
        {
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            int result = cmd.ExecuteNonQuery();
            return result;
        }

        public static int ExecuteCommand(string sql, params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            return cmd.ExecuteNonQuery();
        }

        public static object GetScalar(string safeSql)
        {
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            //int result = Convert.ToInt32(cmd.ExecuteScalar());
            return cmd.ExecuteScalar();
        }

        public static object GetScalar(string sql, params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            return cmd.ExecuteScalar();
        }

        public static SqlDataReader GetReader(string safeSql)
        {
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            SqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }

        public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            SqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }

        public static DataTable GetDataTable(string safeSql)
        {
            DataSet ds = new DataSet();
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            return ds.Tables[0];
        }

        public static DataTable GetDataTable(string sql, params SqlParameter[] values)
        {
            DataSet ds = new DataSet();
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            return ds.Tables[0];
        }

        public static DataSet GetDataSet(string safeSql)
        {
            DataSet ds = new DataSet();
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            return ds;
        }

        public static DataSet GetDataSet(string sql, params SqlParameter[] values)
        {
            DataSet ds = new DataSet();
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            return ds;
        }

    }
}

 

/**************　DTO　******************/

 

using System;
using System.Collections.Generic;
using System.Text;

namespace FlexDoNet.ServiceLibrary.DTO
{
    /// <summary>
    /// 实体类Lihua_User 。(属性说明自动提取数据库字段的描述信息)
    /// </summary>
    [Serializable]
    public class Lihua_User
    {
        #region Model
        private int _userid;
        private string _username;
        private string _userpass;
        private int _userlogins;
        private string _userlastloginip;
        private DateTime _userlastlogintime;
        private DateTime _useraddtime;
        private int _userstatus;
        private string _userflag;
        /// <summary>
        ///
        /// </summary>
        public int UserId
        {
            set { _userid = value; }
            get { return _userid; }
        }
        /// <summary>
        ///
        /// </summary>
        public string UserName
        {
            set { _username = value; }
            get { return _username; }
        }
        /// <summary>
        ///
        /// </summary>
        public string UserPass
        {
            set { _userpass = value; }
            get { return _userpass; }
        }
        /// <summary>
        ///
        /// </summary>
        public int UserLogins
        {
            set { _userlogins = value; }
            get { return _userlogins; }
        }
        /// <summary>
        ///
        /// </summary>
        public string UserLastLoginIp
        {
            set { _userlastloginip = value; }
            get { return _userlastloginip; }
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime UserLastLoginTime
        {
            set { _userlastlogintime = value; }
            get { return _userlastlogintime; }
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime UserAddTime
        {
            set { _useraddtime = value; }
            get { return _useraddtime; }
        }
        /// <summary>
        ///
        /// </summary>
        public int UserStatus
        {
            set { _userstatus = value; }
            get { return _userstatus; }
        }
        /// <summary>
        ///
        /// </summary>
        public string UserFlag
        {
            set { _userflag = value; }
            get { return _userflag; }
        }
        #endregion Model
    }
}

 

/**************************UserDataService****************************************/

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using FlexDoNet.ServiceLibrary.DTO;
using FluorineFx;
using FluorineFx.AMF3;

namespace FlexDoNet.ServiceLibrary
{
    public static class UserDataService
    {

        /// <summary>
        /// 对象实体绑定数据
        /// </summary>
        public static Lihua_User ReaderBind(DataRow dataReader)
        {
            Lihua_User model = new Lihua_User();
            object ojb;
            ojb = dataReader["UserId"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.UserId = (int)ojb;
            }
            model.UserName = dataReader["UserName"].ToString();
            model.UserPass = dataReader["UserPass"].ToString();
            ojb = dataReader["UserLogins"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.UserLogins = (int)ojb;
            }
            model.UserLastLoginIp = dataReader["UserLastLoginIp"].ToString();
            ojb = dataReader["UserLastLoginTime"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.UserLastLoginTime = (DateTime)ojb;
            }
            ojb = dataReader["UserAddTime"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.UserAddTime = (DateTime)ojb;
            }
            ojb = dataReader["UserStatus"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.UserStatus = (int)ojb;
            }
            model.UserFlag = dataReader["UserFlag"].ToString();
            return model;
        }

        public static ArrayCollection GetUserList()
        {
            //IList<FlexDoNet.ServiceLibrary.DTO.Lihua_User> userList = new List<FlexDoNet.ServiceLibrary.DTO.Lihua_User>();
            DataTable table = Flexzoo.SqlHelper.GetDataTable("select * from Lihua_User");
            ArrayCollection array = new ArrayCollection();

            foreach (DataRow r in table.Rows)
            {
                Lihua_User user = new Lihua_User();
                user = ReaderBind(r);
                array.Add(user);
            }

            return array;
        }

        public static IList<Lihua_User> GetUserIList()
        {
            IList<Lihua_User> list = new List<Lihua_User>();
            DataTable table = Flexzoo.SqlHelper.GetDataTable("select * from Lihua_User");

            foreach (DataRow r in table.Rows)
            {
                Lihua_User user = new Lihua_User();
                user = ReaderBind(r);
                list.Add(user);
            }

            return list;
        }

    }
}

 

 

/*****************************ServiceLibrary****************************************/

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using FluorineFx;
using FluorineFx.AMF3;
using FlexDoNet.ServiceLibrary.DTO;

namespace FlexDoNet.ServiceLibrary
{
    /// <summary>
    /// Fluorine sample service.
    /// </summary>
    [RemotingService("Fluorine sample service")]
    public class Sample
    {
        public Sample()
        {
        }

        public string Echo(string text)
        {
            return "Gateway echo: " + text;
        }

        public string GetTime()
        {
            return DateTime.Now.ToString();
        }

        public IList<Lihua_User> GetUsers()
        {
            return UserDataService.GetUserIList();
        }

        [DataSetType("FlexDoNet.ServiceLibrary.DTO.Lihua_User")]
        public DataSet GetDataSet()
        {
            return Flexzoo.SqlHelper.GetDataSet("select * from Lihua_User");
        }
    }
}