DevExpress后置代码中初始化SQL数据源的方法

//初始化SQL数据源的提供者和连接字符串 函数 OK

        public virtual void InitSqlDataSource_ConStr(SqlDataSource sql_ds)

        {

            ConnectionStringSettings cs_set = ConfigurationManager.ConnectionStrings["connString"];

            sql_ds.ProviderName = cs_set.ProviderName;

            sql_ds.ConnectionString = cs_set.ConnectionString;

        }

        //初始化SQL数据源的查询插入修改语句 针对一个主关键字段名称

        public virtual void InitSqlDataSource_SelectInsertUpdate(SqlDataSource p_ds, string gridview_ControlID, string tableName, string where_str, string KeyFieldName)

        {

            string x = "";

            //

            ControlParameter ctrl_param = new ControlParameter();

            ctrl_param.ControlID = gridview_ControlID;

            ctrl_param.PropertyName = "KeyFieldName";

            ctrl_param.Name = KeyFieldName;

            //

            string t_fd_name = "";

            x = "select * from " + tableName + " where 1<>1";

            DataTable dt_null = this.GetDataTable(x);

            //

            string fds_str = "";

            string fds_val = "";

            string update_fds_str = "";

            //获取字段分析后字符串

            this.get_SqlDataSource_sql_str(tableName, ref fds_str, ref fds_val, ref update_fds_str);

            //

            string insert_sql = "";

            insert_sql = "insert " + tableName + "(" + fds_str + ") values(" + fds_val + ")";

            string update_sql = "";

            update_sql = "update " + tableName + " set " + update_fds_str + " where " + KeyFieldName + "=@" + KeyFieldName + " ";

            //查询语句

            p_ds.SelectCommandType = SqlDataSourceCommandType.Text;

            p_ds.SelectCommand = "select * from " + tableName + " " + where_str;

            //

            ////删除语句

            p_ds.DeleteCommandType = SqlDataSourceCommandType.Text;

            p_ds.DeleteCommand = "delete from " + tableName + " where " + KeyFieldName + "=@" + KeyFieldName + "";

            p_ds.DeleteParameters.Clear();

            p_ds.DeleteParameters.Add(ctrl_param);

            //

            //插入语句

            p_ds.InsertCommandType = SqlDataSourceCommandType.Text;

            p_ds.InsertCommand = insert_sql;

            p_ds.InsertParameters.Clear();

            p_ds.InsertParameters.Add(ctrl_param);

            //--

            for (int i = 0; i < dt_null.Columns.Count; i++)

            {

                t_fd_name = dt_null.Columns[i].ColumnName;

                if (t_fd_name.ToUpper() != KeyFieldName)

                {

                    p_ds.InsertParameters.Add(new Parameter(t_fd_name));

                }

            }

            //

            //修改语句

            p_ds.UpdateCommandType = SqlDataSourceCommandType.Text;

            p_ds.UpdateCommand = update_sql;

            //--

            p_ds.UpdateParameters.Clear();

            p_ds.UpdateParameters.Add(ctrl_param);

            for (int i = 0; i < dt_null.Columns.Count; i++)

            {

                t_fd_name = dt_null.Columns[i].ColumnName;

                if (t_fd_name.ToUpper() != KeyFieldName)

                {

                    p_ds.UpdateParameters.Add(new Parameter(t_fd_name));

                }

            }

            //==

        }

        public virtual void InitSqlDataSource_Select(SqlDataSource p_ds,string tableName, string where_str)

        {

            //查询语句

            p_ds.SelectCommandType = SqlDataSourceCommandType.Text;

            p_ds.SelectCommand = "select * from " + tableName + " " + where_str;

            //

            //==

        }

//获取SQL数据源的update和insert语句的需要的组合字符串 函数 OK

        public void get_SqlDataSource_sql_str(string tablename, ref string fds_str, ref string fds_val, ref string update_fds_str)

        {

            string x = "select * from "+tablename+" where 1<>1";

            DataTable dt_null = this.GetDataTable(x);

            string t_fd_name = "";

            fds_str = "";

            fds_val = "";

            //

            update_fds_str = "";

            //

            for (int i = 0; i < dt_null.Columns.Count; i++)

            {

                t_fd_name = dt_null.Columns[i].ColumnName;

                //#region//插入语句字符串处理

                if (fds_str == "")

                {

                    fds_str = t_fd_name;

                    fds_val = "@" + t_fd_name;

                }

                else

                {

                    fds_str += "," + t_fd_name;

                    fds_val += ",@" + t_fd_name;

                }

                //#endregion

                //#region //修改语句字符串处理

                if (update_fds_str == "")

                {

                    update_fds_str = t_fd_name + "=@" + t_fd_name;

                }

                else

                {

                    update_fds_str += "," + t_fd_name + "=@" + t_fd_name;

                }

                //#endregion

            }

        }

        //

调用的方法：

//初始化 需求信息登记的数据源

            this.InitSqlDataSource_ConStr(this.sql_ds_xq);

            string xq_ctrlID = this.dx_gv_xq.ID;   //或xq_ctrlID =this.pagecontrol.ID+"$"+ this.dx_gv_xq.ID;

            this.InitSqlDataSource_SelectInsertUpdate(this.sql_ds_xq, xq_ctrlID, "TableName", whereStr, "MainFieldName");

DevExpress后置代码中初始化SQL数据源的方法的相关教程结束。