public static Sys_Config_ListPage GetListConfig(string moduleName, out Sys_Config_ListPage M_Model, out List<Sys_Config_Fieled> D_List) { ADOSys_Config_ListPage ListInstance = new ADOSys_Config_ListPage(); ADOSys_Config_Fieled FieledInstance = new ADOSys_Config_Fieled(); M_Model = null; D_List = null; try { if (!string.IsNullOrEmpty(moduleName)) { //第一步:根据传入模块获取Grid配置 List<Sys_Config_ListPage> _ListPage = ListInstance.GetListByWhere(" AND M_ModuleCode='" + moduleName + "'"); if (_ListPage.Count > 0) { M_Model = _ListPage[0]; } //第二步:根据模块获取所有字段 D_List = FieledInstance.GetListByWhere(" AND D_ModuleCode='" + moduleName + "'"); } else { M_Model = null; D_List = null; } } catch (System.Exception ex) { M_Model = null; D_List = null; } return M_Model; }
/// <summary> /// 动态解析查询条件 /// </summary> /// <param name="txt"></param> /// <param name="module"></param> /// <returns></returns> public static string BuildSearch(this string txt, string module) { var QueryLeftTree = string.Empty; StringBuilder strQuery = new StringBuilder(); //Dictionary<string, string> dict = ReturnBuild(); Dictionary<string, string> dict = new Dictionary<string, string>(); MetaOper mod = JsonConvert.DeserializeObject<MetaOper>(txt); List<MetaRules> oper = JsonConvert.DeserializeObject<List<MetaRules>>(mod.rules.ToString()); ADOBse_Dict DictInstance = new ADOBse_Dict(); Sys_Config_ListPage M_Model = new Sys_Config_ListPage(); List<Sys_Config_Fieled> D_List = new List<Sys_Config_Fieled>(); GetListConfig(module, out M_Model, out D_List); var D_List_Dict = D_List.Where(o => !string.IsNullOrEmpty(o.D_DictKey) && (string.IsNullOrEmpty(o.D_Hidden) || o.D_Hidden == "false")); var Str_DictList = D_List.Select(o => o.D_Index); var Str_Oper = oper.Select(o => o.field); if (D_List_Dict.Count() > 0 && Str_DictList.Intersect(Str_Oper).Count() > 0) { for (int i = 0; i < oper.Count; i++) { string _oper = string.Empty; StringBuilder ConvertData = new StringBuilder(); if (i != oper.Count - 1) { _oper = " " + mod.groupOp + " "; } var D_ListQuery = D_List_Dict.Where(o => o.D_Index == oper[i].field); if (D_ListQuery.Count() > 0) { dict = ReturnBuildDict(); //构建查询条件Field QueryLeftTree = !string.IsNullOrEmpty(D_ListQuery.First().D_DBField) ? D_ListQuery.First().D_DBField : oper[i].field; //获取字典Code if (!string.IsNullOrEmpty(oper[i].data)) { var DictResult = DictInstance.GetListByWhere(" AND Dict_Key!=Dict_Code AND Dict_Name like '%" + oper[i].data + "%'"); if (DictResult.Count > 0) { foreach (var item in DictResult) { ConvertData.Append("'" + item.Dict_Code + "',"); } } strQuery.Append(dict[oper[i].op].Replace("{field}", QueryLeftTree).Replace("{data}", ConvertData.ToString().TrimEnd(',')) + _oper); } } else { dict = ReturnBuild(); if (i != oper.Count - 1) { _oper = " " + mod.groupOp + " "; } strQuery.Append(dict[oper[i].op].Replace("{field}", oper[i].field).Replace("{data}", oper[i].data) + _oper); } } } else { if (oper.Count > 0) { dict = ReturnBuild(); for (int i = 0; i < oper.Count; i++) { string _oper = string.Empty; if (i != oper.Count - 1) { _oper = " " + mod.groupOp + " "; } strQuery.Append(dict[oper[i].op].Replace("{field}", oper[i].field).Replace("{data}", oper[i].data) + _oper); } } } return strQuery.ToString(); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(Sys_Config_ListPage model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> /// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Sys_Config_ListPage GetModel(string strCondition) { List<Sys_Config_ListPage> list = instance.GetListByWhere(strCondition); Sys_Config_ListPage model = new Sys_Config_ListPage(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return model; }
public static string GenToolbarHelper(this HtmlHelper helper, string moduleName, string prefix, bool HiddeOther, string ToolBarConfig) { ADOComm comInstance = new ADOComm(); Sys_Config_ListPage M_Model = new Sys_Config_ListPage(); //第一步:根据传入模块获取Grid配置 List<Sys_Config_ListPage> _ListPage = new DAL.ADOSys_Config_ListPage().GetListByWhere(" AND M_ModuleCode='" + moduleName + "'"); //工具条配置 List<Sys_Config_Toolbar> _Config = new List<Sys_Config_Toolbar>(); DAL.ADOSys_Config_Toolbar tInstance = new ADOSys_Config_Toolbar(); _Config = tInstance.GetListByWhere(string.Format("AND CT_Module='{0}' and isnull(CT_Show,'true')='true'", moduleName)); if (_ListPage.Count > 0) { M_Model = _ListPage[0]; } //工具条各控件前缀 string strPrefix = ""; strPrefix = prefix; ToolBar bar = new ToolBar(); if (!string.IsNullOrEmpty(ToolBarConfig)) { bar = JsonConvert.DeserializeObject<ToolBar>("{" + ToolBarConfig + "}"); } var HasAdd = 1; var HasEdit = 1; var HasView = 1; var HasDel = 1; var HasImport = 1; var HasExport = 1; var IS_OPEN_PERMISSION = ConfigHelper.GetApp("IS_OPEN_PERMISSION"); ///ToDo:暂时屏蔽 //if (!string.IsNullOrEmpty(IS_OPEN_PERMISSION) && IS_OPEN_PERMISSION == "true") //{ // var Permission = comInstance.UserPermissionList(QX.Config.SessionConfig.UserId()); // HasAdd = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_add").Count(); // HasEdit = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_edit").Count(); // HasView = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_view").Count(); // HasDel = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_delete").Count(); // HasImport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_import").Count(); // HasExport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_export").Count(); //} #region 按钮Html(定义增删改搜索等模板) //{add} -->补充属性 prefix-->id前缀 {toolbar_add}--->样式 string controlTpl = @"<li {attr} id='{toolbar_id}' class='{toolbar_class}'><a class='hide' onclick='{toolbar_event}' href='#'>{addN}</a></li>"; string Li_edit = @"<li {edit} id='{prefix}_toolbar_edit' class='{toolbar_edit}'><a class='hide' id='{prefix}_edit' onclick='{prefix}ToolBar.Edit()' href='#'>{editN}</a></li>"; string Li_del = @"<li {del} id='{prefix}_toolbar_delete' class='{toolbar_delete}'><a class='hide' id='{prefix}_delete' onclick='{prefix}ToolBar.Delete()' href='#'>{delN}</a></li> "; string Li_view = @"<li {view} id='{prefix}_toolbar_view' class='{toolbar_view}'><a class='hide' id='{prefix}_view' onclick='{prefix}ToolBar.View()' href='#'>{viewN}</a></li> "; //string Li_import = @"<li {import} id='{prefix}_toolbar_import' class='{toolbar_import}'><a class='hide' id='{prefix}_import' onclick='{prefix}ToolBar.Import()' href='#'>{importN}</a></li>"; //string Li_export = @"<li {export} id='{prefix}_toolbar_export' class='{toolbar_export}'><a class='hide' id='{prefix}_export' onclick='{prefix}ToolBar.Export()' href='#'>{exportN}</a></li>"; string Li_search = @"<li {search} id='{prefix}_toolbar_search' class='{toolbar_search}'><input style='display:none' id='search_txt' type='text' value='' /> <a id='{prefix}_search' onclick='{prefix}ToolBar.Search()' href='#'>{searchN}</a> </li> "; string Li_Custom = @"<li {add} id='{prefix}_toolbar_add' class='{toolbar_add}'><a id='{prefix}_add' onclick='{prefix}ToolBar.Add()' href='#'>{addN}</a></li>"; #endregion bool toolbar = !string.IsNullOrEmpty(bar.toolbar) ? true : false; string validatemethod = @" if ($.isFunction(window.{prefix}ToolBar{OpType})) { {prefix}ToolBar{OpType}(); } else { {nameSpace}_{moduleName}ToolBar{OpType}(); }"; string str = @" <div id='{prefix}toolbar' class='toolbar'> <ul> {Toolbar_Config} </ul> </div> <script type='text/javascript'> var {prefix}ToolBar = { {Toolbar_Function} HideElement:function(id){ $('#id').hide(); }, ChangeElement:function(id,name){ $('#id').find('a').val(name); } } //插入菜单项:文本,回调,位置(ID),样式 </script> "; StringBuilder configSb = new StringBuilder(); StringBuilder functionSb = new StringBuilder(); foreach (var m in _Config) { switch (m.CT_Type) { case "add": case "edit": case "del": case "view": { //控件id string id = prefix + "_toolbar_" + m.CT_Type; string eventjs = string.Format(prefix + "ToolBar.{0}()", m.CT_Type); string classjs = string.Format("toolbar_{0}", m.CT_Type); configSb.Append(controlTpl.Replace("{prefix}", prefix) .Replace("{toolbar_id}", id) .Replace("{addN}", m.CT_Name) .Replace("{toolbar_class}", string.IsNullOrEmpty(m.CT_Class) ? classjs : m.CT_Class) .Replace("{toolbar_event}", eventjs) .Replace("{attr}", m.CT_Attr) ); if (string.IsNullOrEmpty(m.CT_Event)) { m.CT_Event = validatemethod.Replace("{OpType}", m.CT_Type).Replace("{prefix}", strPrefix).Replace("{nameSpace}", prefix).Replace("{moduleName}", moduleName); } //事件定义 //string.IsNullOrEmpty(m.CT_Event)?eventjs:m.CT_Event functionSb.AppendLine(); functionSb.AppendLine(" " + m.CT_Type + ":function(){"); functionSb.AppendLine(" " + m.CT_Event); functionSb.AppendLine(" },"); break; } //case "edit": // { // break; // } //case "del": // { // break; // } //case "view": // { // break; // } case "search": { break; } case "text": { break; } case "btn": { string id = prefix + "_toolbar_" + m.CT_Field; string eventjs = string.Format(prefix + "ToolBar.{0}()", m.CT_Field); string classjs = string.Format("toolbar_{0}", m.CT_Field); configSb.Append(controlTpl.Replace("{prefix}", prefix) .Replace("{toolbar_id}", id) .Replace("{addN}", m.CT_Name) .Replace("{toolbar_class}", string.IsNullOrEmpty(m.CT_Class) ? classjs : m.CT_Class) .Replace("{toolbar_event}", eventjs) .Replace("{attr}", m.CT_Attr) ); //事件定义 //string.IsNullOrEmpty(m.CT_Event)?eventjs:m.CT_Event functionSb.AppendLine(); functionSb.AppendLine(" " + m.CT_Type + ":function(){"); functionSb.AppendLine(" " + m.CT_Event); functionSb.AppendLine(" },"); break; } } }//end foreach str = str.Replace("{prefix}", prefix).Replace("{Toolbar_Config}", configSb.ToString()).Replace("{Toolbar_Function}", functionSb.ToString()); //#region 按钮解析(配置生成) //string add = !string.IsNullOrEmpty(bar.add) ? "style='display:none'" : "style='display:block'"; //string addN = !string.IsNullOrEmpty(bar.addN) ? bar.addN : "添加"; //string addClass = !string.IsNullOrEmpty(bar.addClass) ? bar.addClass : "toolbar_add"; //string edit = !string.IsNullOrEmpty(bar.edit) ? "style='display:none'" : "style='display:block'"; //string editN = !string.IsNullOrEmpty(bar.editN) ? bar.editN : "修改"; //string editClass = !string.IsNullOrEmpty(bar.editClass) ? bar.editClass : "toolbar_edit"; //string del = !string.IsNullOrEmpty(bar.del) ? "style='display:none'" : "style='display:block'"; //string delN = !string.IsNullOrEmpty(bar.delN) ? bar.delN : "删除"; //string delClass = !string.IsNullOrEmpty(bar.delClass) ? bar.delClass : "toolbar_delete"; //string view = !string.IsNullOrEmpty(bar.view) ? "style='display:none'" : "style='display:block'"; //string viewN = !string.IsNullOrEmpty(bar.viewN) ? bar.viewN : "查看"; //string viewClass = !string.IsNullOrEmpty(bar.viewClass) ? bar.viewClass : "toolbar_view"; ////string import = !string.IsNullOrEmpty(bar.import) ? "style='display:none'" : "style='display:block'"; ////string importN = !string.IsNullOrEmpty(bar.importN) ? bar.importN : "导入"; ////string importClass = !string.IsNullOrEmpty(bar.importClass) ? bar.importClass : "toolbar_import"; ////string export = !string.IsNullOrEmpty(bar.export) ? "style='display:none'" : "style='display:block'"; ////string exportN = !string.IsNullOrEmpty(bar.exportN) ? bar.exportN : "导出"; ////string exportClass = !string.IsNullOrEmpty(bar.exportClass) ? bar.exportClass : "toolbar_export"; //string search = !string.IsNullOrEmpty(bar.search) ? "style='display:none'" : "style='display:block'"; //string searchN = !string.IsNullOrEmpty(bar.searchN) ? bar.searchN : "搜索"; //string searchClass = !string.IsNullOrEmpty(bar.searchClass) ? bar.searchClass : "toolbar_search"; //#endregion //#region 事件定义 //string addJS = !string.IsNullOrEmpty(bar.addFunJs) ? "{prefix}" + bar.addFunJs : validatemethod.Replace("{OpType}", "Add"); //string editJs = !string.IsNullOrEmpty(bar.editFunJs) ? "{prefix}" + bar.editFunJs : validatemethod.Replace("{OpType}", "Edit"); //string delJs = !string.IsNullOrEmpty(bar.delFunJs) ? "{prefix}" + bar.delFunJs : validatemethod.Replace("{OpType}", "Del"); //string viewJs = !string.IsNullOrEmpty(bar.viewFunJs) ? "{prefix}" + bar.viewFunJs : validatemethod.Replace("{OpType}", "View"); ////string importJs = !string.IsNullOrEmpty(bar.importFunJs) ? "{prefix}" + bar.importFunJs : "{prefix}ToolBarImport()"; ////string exportJs = !string.IsNullOrEmpty(bar.exportFunJs) ? "{prefix}" + bar.exportFunJs : "{prefix}ToolBarExport()"; //string searchJs = !string.IsNullOrEmpty(bar.searchFunJs) ? "{prefix}" + bar.searchFunJs : "{prefix}ToolBarSearch()"; //#endregion // #region HTML生成 // string str = @" // <div id='{prefix}toolbar' class='toolbar'> // <ul> // {Li_add} // {Li_edit} // {Li_del} // {Li_view} // {Li_search} // </ul> // </div> // <script type='text/javascript'> // var {prefix}ToolBar = { // Add: function() { // {addJs}; // }, // Edit: function() { // {editJs}; // }, // Delete: function() { // {delJs}; // }, // View: function() { // {viewJs}; // }, // Search: function() { // {searchJs}; // }, // Import: function() { // {importJs}; // }, // Export: function() { // {exportJs}; // }, // HideElement:function(id){ // $('#id').hide(); // }, // ChangeElement:function(id,name){ // $('#id').find('a').val(name); // } // } // //插入菜单项:文本,回调,位置(ID),样式 // // // </script> // "; // #endregion // Li_add = HasAdd > 0 ? Li_add : ""; // Li_edit = HasEdit > 0 ? Li_edit : ""; // Li_del = HasDel > 0 ? Li_del : ""; // //Li_import = HasImport > 0 ? Li_import : ""; // //Li_export = HasExport > 0 ? Li_export : ""; // Li_view = HasView > 0 ? Li_view : ""; // bool HasConfig = !string.IsNullOrEmpty(ToolBarConfig) ? true : false; // if (HasConfig) // { // str = str.Replace("{Li_add}", ((!string.IsNullOrEmpty(bar.addN) || !string.IsNullOrEmpty(bar.addFunJs))) ? Li_add : ""); // str = str.Replace("{Li_edit}", ((!string.IsNullOrEmpty(bar.editN) || !string.IsNullOrEmpty(bar.editFunJs))) ? Li_edit : ""); // str = str.Replace("{Li_del}", ((!string.IsNullOrEmpty(bar.delN) || !string.IsNullOrEmpty(bar.delFunJs))) ? Li_del : ""); // str = str.Replace("{Li_view}", ((!string.IsNullOrEmpty(bar.viewN) || !string.IsNullOrEmpty(bar.viewFunJs))) ? Li_view : ""); // //str = str.Replace("{Li_import}", ((!string.IsNullOrEmpty(bar.importN) || !string.IsNullOrEmpty(bar.importFunJs))) ? Li_import : ""); // //str = str.Replace("{Li_export}", ((!string.IsNullOrEmpty(bar.exportN) || !string.IsNullOrEmpty(bar.exportFunJs))) ? Li_export : ""); // //str = str.Replace("{Li_search}", ((!string.IsNullOrEmpty(bar.searchN) || !string.IsNullOrEmpty(bar.searchFunJs))) ? Li_search : ""); // } // else//默认生成的话根据配置进行生成 // { // if (M_Model.M_IsAdd == 1) // { // str = str.Replace("{Li_add}", Li_add); // } // else // { // str = str.Replace("{Li_add}", ""); // } // if (M_Model.M_IsEdit == 1) // { // str = str.Replace("{Li_edit}", Li_edit); // } // else // { // str = str.Replace("{Li_edit}", ""); // } // if (M_Model.M_IsDelete == 1) // { // str = str.Replace("{Li_del}", Li_del); // } // else // { // str = str.Replace("{Li_del}", ""); // } // if (M_Model.M_IsView == "true") // { // str = str.Replace("{Li_view}", Li_view); // } // else // { // str = str.Replace("{Li_view}", ""); // } // //str = str.Replace("{Li_import}", Li_import); // //str = str.Replace("{Li_export}", Li_export); // } // //搜索 默认输出 // str = str.Replace("{Li_search}", Li_search); // if (M_Model.M_IsAdd == 1) // { // str = str.Replace("{toolbar_add}", addClass); // } // else // { // str = str.Replace("{toolbar_add}", ""); // } // if (M_Model.M_IsEdit == 1) // { // str = str.Replace("{toolbar_edit}", editClass); // } // else // { // str = str.Replace("{toolbar_edit}", ""); // } // str = str.Replace("{toolbar_delete}", delClass); // if (M_Model.M_IsView == "true") // { // str = str.Replace("{toolbar_view}", viewClass); // } // else // { // str = str.Replace("{toolbar_view}", ""); // } // //str = str.Replace("{toolbar_import}", importClass); // //str = str.Replace("{toolbar_export}", exportClass); // str = str.Replace("{toolbar_search}", searchClass); // if (M_Model.M_IsAdd == 1) // { // str = str.Replace("{addJs}", addJS); // } // else // { // str = str.Replace("{addJs}", ""); // } // if (M_Model.M_IsEdit == 1) // { // str = str.Replace("{editJs}", editJs); // } // else // { // str = str.Replace("{editJs}", ""); // } // if (M_Model.M_IsDelete == 1) // { // str = str.Replace("{delJs}", delJs); // } // else // { // str = str.Replace("{delJs}", ""); // } // if (M_Model.M_IsView == "true") // { // str = str.Replace("{viewJs}", viewJs); // } // else // { // str = str.Replace("{viewJs}", ""); // } // //str = str.Replace("{viewJs}", viewJs); // str = str.Replace("{searchJs}", searchJs); // //str = str.Replace("{importJs}", importJs); // //str = str.Replace("{exportJs}", exportJs); // str = str.Replace("{searchJs}", searchJs); // str = str.Replace("{prefix}", strPrefix); // str = str.Replace("{newprefix}", prefix); // str = str.Replace("{add}", add); // str = str.Replace("{addN}", addN); // str = str.Replace("{edit}", edit); // str = str.Replace("{editN}", editN); // str = str.Replace("{del}", del); // str = str.Replace("{delN}", delN); // str = str.Replace("{view}", view); // str = str.Replace("{viewN}", viewN); // //str = str.Replace("{import}", import); // //str = str.Replace("{importN}", importN); // //str = str.Replace("{export}", export); // //str = str.Replace("{exportN}", exportN); // str = str.Replace("{search}", search); // str = str.Replace("{searchN}", searchN); // str = str.Replace("{moduleName}", M_Model.M_ModuleCode); // str = str.Replace("{nameSpace}", M_Model.M_NameSpace); // if (toolbar) // { // str = ""; // } return str; }
public static string GenNToolbarHelper(this HtmlHelper helper, string moduleName, string prefix, bool nopermission, Dictionary<string, string> permisons) { ADOComm comInstance = new ADOComm(); Sys_Config_ListPage M_Model = new Sys_Config_ListPage(); //第一步:根据传入模块获取Grid配置 List<Sys_Config_ListPage> _ListPage = new DAL.ADOSys_Config_ListPage().GetListByWhere(" AND M_ModuleCode='" + moduleName + "'"); //工具条配置 List<Sys_Config_Toolbar> _Config = new List<Sys_Config_Toolbar>(); DAL.ADOSys_Config_Toolbar tInstance = new ADOSys_Config_Toolbar(); _Config = tInstance.GetListByWhere(string.Format("AND CT_Module='{0}' and isnull(CT_Show,'true')='true'", moduleName)); if (_ListPage.Count > 0) { M_Model = _ListPage[0]; } //工具条各控件前缀 string strPrefix = ""; strPrefix = prefix; var IS_OPEN_PERMISSION = ConfigHelper.GetApp("IS_OPEN_PERMISSION"); #region 按钮Html(定义增删改搜索等模板) //{add} -->补充属性 prefix-->id前缀 {toolbar_add}--->样式 string controlTpl = @"<li {attr} id='{toolbar_id}' class='{toolbar_class}'><a class='hide' onclick='{toolbar_event}' href='#'>{addN}</a></li>"; #endregion string validatemethod = @" if ($.isFunction(window.{prefix}ToolBar{OpType})) { {prefix}ToolBar{OpType}(); } else { {nameSpace}_{moduleName}ToolBar{OpType}(); }"; string str = @" <div id='{prefix}toolbar' class='toolbar'> <ul> {Toolbar_Config} </ul> </div> <script type='text/javascript'> var {prefix}ToolBar = { {Toolbar_Function} HideElement:function(id){ $('#id').hide(); }, ChangeElement:function(id,name){ $('#id').find('a').val(name); } } //插入菜单项:文本,回调,位置(ID),样式 </script> "; StringBuilder configSb = new StringBuilder(); StringBuilder functionSb = new StringBuilder(); foreach (var m in _Config) { //控件id string cid = prefix + "_toolbar_" + m.CT_Type; //默认事件 string eventjs = string.Format(prefix + "ToolBar.{0}()", m.CT_Type); //默认样式 string classjs = string.Format("toolbar_{0}", m.CT_Type); ///如果存在该权限则进行后面的生成操作 if (nopermission&&(permisons == null || permisons.Values.FirstOrDefault(o => !string.IsNullOrEmpty(o) && cid.ToLower().Equals(o.ToLower())) == null)) { continue; } switch (m.CT_Type) { case "add": case "edit": case "del": case "view": { configSb.Append(controlTpl.Replace("{prefix}", prefix) .Replace("{toolbar_id}", cid) .Replace("{addN}", m.CT_Name) .Replace("{toolbar_class}", string.IsNullOrEmpty(m.CT_Class) ? classjs : m.CT_Class) .Replace("{toolbar_event}", eventjs) .Replace("{attr}", m.CT_Attr) ); if (string.IsNullOrEmpty(m.CT_Event)) { m.CT_Event = validatemethod.Replace("{OpType}", m.CT_Type).Replace("{prefix}", strPrefix).Replace("{nameSpace}", prefix).Replace("{moduleName}", moduleName); } //事件定义 functionSb.AppendLine(); functionSb.AppendLine(" " + m.CT_Type + ":function(){"); functionSb.AppendLine(" " + m.CT_Event); functionSb.AppendLine(" },"); break; } case "search": { break; } case "text": { break; } case "btn": { string bid = prefix + "_toolbar_" + m.CT_Field; string beventjs = string.Format(prefix + "ToolBar.{0}()", m.CT_Field); string bclassjs = string.Format("toolbar_{0}", m.CT_Field); configSb.Append(controlTpl.Replace("{prefix}", prefix) .Replace("{toolbar_id}", bid) .Replace("{addN}", m.CT_Name) .Replace("{toolbar_class}", string.IsNullOrEmpty(m.CT_Class) ? bclassjs : m.CT_Class) .Replace("{toolbar_event}", beventjs) .Replace("{attr}", m.CT_Attr) ); //事件定义 functionSb.AppendLine(); functionSb.AppendLine(" " + m.CT_Type + ":function(){"); functionSb.AppendLine(" " + m.CT_Event); functionSb.AppendLine(" },"); break; } } }//end foreach str = str.Replace("{prefix}", prefix).Replace("{Toolbar_Config}", configSb.ToString()).Replace("{Toolbar_Function}", functionSb.ToString()); return str; }
public static string GenToolbarNoPermissionHelper(this HtmlHelper helper, string moduleName, string prefix, string ToolBarConfig) { ADOComm comInstance = new ADOComm(); Sys_Config_ListPage M_Model = new Sys_Config_ListPage(); //第一步:根据传入模块获取Grid配置 List<Sys_Config_ListPage> _ListPage = new DAL.ADOSys_Config_ListPage().GetListByWhere(" AND M_ModuleCode='" + moduleName + "'"); if (_ListPage.Count > 0) { M_Model = _ListPage[0]; } string strPrefix = ""; strPrefix = prefix; ToolBar bar = new ToolBar(); if (!string.IsNullOrEmpty(ToolBarConfig)) { bar = JsonConvert.DeserializeObject<ToolBar>("{" + ToolBarConfig + "}"); } var HasAdd = 1; var HasEdit = 1; var HasView = 1; var HasDel = 1; var HasImport = 1; var HasExport = 1; //var IS_OPEN_PERMISSION = ConfigHelper.GetApp("IS_OPEN_PERMISSION"); //if (!string.IsNullOrEmpty(IS_OPEN_PERMISSION) && IS_OPEN_PERMISSION == "true") //{ // var Permission = comInstance.UserPermissionList(QX.Config.SessionConfig.UserId()); // HasAdd = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_add").Count(); // HasEdit = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_edit").Count(); // HasView = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_view").Count(); // HasDel = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_delete").Count(); // HasImport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_import").Count(); // HasExport = Permission.Where(o => o.Fun_UDef1 == strPrefix + "_export").Count(); //} #region 按钮Html string Li_add = @"<li {add} id='{prefix}_toolbar_add' class='{toolbar_add}'><a class='hide' id='{prefix}_add' onclick='{prefix}ToolBar.Add()' href='#'>{addN}</a></li>"; string Li_edit = @"<li {edit} id='{prefix}_toolbar_edit' class='{toolbar_edit}'><a class='hide' id='{prefix}_edit' onclick='{prefix}ToolBar.Edit()' href='#'>{editN}</a></li>"; string Li_del = @"<li {del} id='{prefix}_toolbar_delete' class='{toolbar_delete}'><a class='hide' id='{prefix}_delete' onclick='{prefix}ToolBar.Delete()' href='#'>{delN}</a></li> "; string Li_view = @"<li {view} id='{prefix}_toolbar_view' class='{toolbar_view}'><a class='hide' id='{prefix}_view' onclick='{prefix}ToolBar.View()' href='#'>{viewN}</a></li> "; //string Li_import = @"<li {import} id='{prefix}_toolbar_import' class='{toolbar_import}'><a class='hide' id='{prefix}_import' onclick='{prefix}ToolBar.Import()' href='#'>{importN}</a></li>"; //string Li_export = @"<li {export} id='{prefix}_toolbar_export' class='{toolbar_export}'><a class='hide' id='{prefix}_export' onclick='{prefix}ToolBar.Export()' href='#'>{exportN}</a></li>"; string Li_search = @"<li {search} id='{prefix}_toolbar_search' class='{toolbar_search}'><input style='display:none' id='search_txt' type='text' value='' /> <a id='{prefix}_search' onclick='{prefix}ToolBar.Search()' href='#'>{searchN}</a> </li> "; string Li_Custom = @"<li {add} id='{prefix}_toolbar_add' class='{toolbar_add}'><a id='{prefix}_add' onclick='{prefix}ToolBar.Add()' href='#'>{addN}</a></li>"; #endregion #region 按钮解析 bool toolbar = !string.IsNullOrEmpty(bar.toolbar) ? true : false; string add = !string.IsNullOrEmpty(bar.add) ? "style='display:none'" : "style='display:block'"; string addN = !string.IsNullOrEmpty(bar.addN) ? bar.addN : "添加"; string addClass = !string.IsNullOrEmpty(bar.addClass) ? bar.addClass : "toolbar_add"; string edit = !string.IsNullOrEmpty(bar.edit) ? "style='display:none'" : "style='display:block'"; string editN = !string.IsNullOrEmpty(bar.editN) ? bar.editN : "修改"; string editClass = !string.IsNullOrEmpty(bar.editClass) ? bar.editClass : "toolbar_edit"; string del = !string.IsNullOrEmpty(bar.del) ? "style='display:none'" : "style='display:block'"; string delN = !string.IsNullOrEmpty(bar.delN) ? bar.delN : "删除"; string delClass = !string.IsNullOrEmpty(bar.delClass) ? bar.delClass : "toolbar_delete"; string view = !string.IsNullOrEmpty(bar.view) ? "style='display:none'" : "style='display:block'"; string viewN = !string.IsNullOrEmpty(bar.viewN) ? bar.viewN : "查看"; string viewClass = !string.IsNullOrEmpty(bar.viewClass) ? bar.viewClass : "toolbar_view"; //string import = !string.IsNullOrEmpty(bar.import) ? "style='display:none'" : "style='display:block'"; //string importN = !string.IsNullOrEmpty(bar.importN) ? bar.importN : "导入"; //string importClass = !string.IsNullOrEmpty(bar.importClass) ? bar.importClass : "toolbar_import"; //string export = !string.IsNullOrEmpty(bar.export) ? "style='display:none'" : "style='display:block'"; //string exportN = !string.IsNullOrEmpty(bar.exportN) ? bar.exportN : "导出"; //string exportClass = !string.IsNullOrEmpty(bar.exportClass) ? bar.exportClass : "toolbar_export"; string search = !string.IsNullOrEmpty(bar.search) ? "style='display:none'" : "style='display:block'"; string searchN = !string.IsNullOrEmpty(bar.searchN) ? bar.searchN : "搜索"; string searchClass = !string.IsNullOrEmpty(bar.searchClass) ? bar.searchClass : "toolbar_search"; #endregion #region 事件定义 string validatemethod = @" if ($.isFunction(window.{prefix}ToolBar{OpType})) { {prefix}ToolBar{OpType}(); } else { {nameSpace}_{moduleName}ToolBar{OpType}(); }"; string addJS = !string.IsNullOrEmpty(bar.addFunJs) ? "{prefix}" + bar.addFunJs : validatemethod.Replace("{OpType}", "Add"); string editJs = !string.IsNullOrEmpty(bar.editFunJs) ? "{prefix}" + bar.editFunJs : validatemethod.Replace("{OpType}", "Edit"); string delJs = !string.IsNullOrEmpty(bar.delFunJs) ? "{prefix}" + bar.delFunJs : validatemethod.Replace("{OpType}", "Del"); string viewJs = !string.IsNullOrEmpty(bar.viewFunJs) ? "{prefix}" + bar.viewFunJs : validatemethod.Replace("{OpType}", "View"); //string importJs = !string.IsNullOrEmpty(bar.importFunJs) ? "{prefix}" + bar.importFunJs : "{prefix}ToolBarImport()"; //string exportJs = !string.IsNullOrEmpty(bar.exportFunJs) ? "{prefix}" + bar.exportFunJs : "{prefix}ToolBarExport()"; string searchJs = !string.IsNullOrEmpty(bar.searchFunJs) ? "{prefix}" + bar.searchFunJs : "{prefix}ToolBarSearch()"; #endregion #region HTML生成 string str = @" <div id='{prefix}toolbar' class='toolbar'> <ul> {Li_add} {Li_edit} {Li_del} {Li_view} {Li_search} </ul> </div> <script type='text/javascript'> var {prefix}ToolBar = { Add: function() { {addJs}; }, Edit: function() { {editJs}; }, Delete: function() { {delJs}; }, View: function() { {viewJs}; }, Search: function() { {searchJs}; }, Import: function() { {importJs}; }, Export: function() { {exportJs}; }, HideElement:function(id){ $('#id').hide(); }, ChangeElement:function(id,name){ $('#id').find('a').val(name); } } //插入菜单项:文本,回调,位置(ID),样式 </script> "; #endregion Li_add = HasAdd > 0 ? Li_add : ""; Li_edit = HasEdit > 0 ? Li_edit : ""; Li_del = HasDel > 0 ? Li_del : ""; //Li_import = HasImport > 0 ? Li_import : ""; //Li_export = HasExport > 0 ? Li_export : ""; Li_view = HasView > 0 ? Li_view : ""; bool HasConfig = !string.IsNullOrEmpty(ToolBarConfig) ? true : false; if (HasConfig) { str = str.Replace("{Li_add}", ((!string.IsNullOrEmpty(bar.addN) || !string.IsNullOrEmpty(bar.addFunJs))) ? Li_add : ""); str = str.Replace("{Li_edit}", ((!string.IsNullOrEmpty(bar.editN) || !string.IsNullOrEmpty(bar.editFunJs))) ? Li_edit : ""); str = str.Replace("{Li_del}", ((!string.IsNullOrEmpty(bar.delN) || !string.IsNullOrEmpty(bar.delFunJs))) ? Li_del : ""); str = str.Replace("{Li_view}", ((!string.IsNullOrEmpty(bar.viewN) || !string.IsNullOrEmpty(bar.viewFunJs))) ? Li_view : ""); //str = str.Replace("{Li_import}", ((!string.IsNullOrEmpty(bar.importN) || !string.IsNullOrEmpty(bar.importFunJs))) ? Li_import : ""); //str = str.Replace("{Li_export}", ((!string.IsNullOrEmpty(bar.exportN) || !string.IsNullOrEmpty(bar.exportFunJs))) ? Li_export : ""); //str = str.Replace("{Li_search}", ((!string.IsNullOrEmpty(bar.searchN) || !string.IsNullOrEmpty(bar.searchFunJs))) ? Li_search : ""); } else//默认生成的话根据配置进行生成 { if (M_Model.M_IsAdd == 1) { str = str.Replace("{Li_add}", Li_add); } else { str = str.Replace("{Li_add}", ""); } if (M_Model.M_IsEdit == 1) { str = str.Replace("{Li_edit}", Li_edit); } else { str = str.Replace("{Li_edit}", ""); } if (M_Model.M_IsDelete == 1) { str = str.Replace("{Li_del}", Li_del); } else { str = str.Replace("{Li_del}", ""); } if (M_Model.M_IsView == "true") { str = str.Replace("{Li_view}", Li_view); } else { str = str.Replace("{Li_view}", ""); } //str = str.Replace("{Li_import}", Li_import); //str = str.Replace("{Li_export}", Li_export); } //搜索 默认输出 str = str.Replace("{Li_search}", Li_search); if (M_Model.M_IsAdd == 1) { str = str.Replace("{toolbar_add}", addClass); } else { str = str.Replace("{toolbar_add}", ""); } if (M_Model.M_IsEdit == 1) { str = str.Replace("{toolbar_edit}", editClass); } else { str = str.Replace("{toolbar_edit}", ""); } str = str.Replace("{toolbar_delete}", delClass); if (M_Model.M_IsView == "true") { str = str.Replace("{toolbar_view}", viewClass); } else { str = str.Replace("{toolbar_view}", ""); } //str = str.Replace("{toolbar_import}", importClass); //str = str.Replace("{toolbar_export}", exportClass); str = str.Replace("{toolbar_search}", searchClass); if (M_Model.M_IsAdd == 1) { str = str.Replace("{addJs}", addJS); } else { str = str.Replace("{addJs}", ""); } if (M_Model.M_IsEdit == 1) { str = str.Replace("{editJs}", editJs); } else { str = str.Replace("{editJs}", ""); } if (M_Model.M_IsDelete == 1) { str = str.Replace("{delJs}", delJs); } else { str = str.Replace("{delJs}", ""); } if (M_Model.M_IsView == "true") { str = str.Replace("{viewJs}", viewJs); } else { str = str.Replace("{viewJs}", ""); } //str = str.Replace("{viewJs}", viewJs); str = str.Replace("{searchJs}", searchJs); //str = str.Replace("{importJs}", importJs); //str = str.Replace("{exportJs}", exportJs); str = str.Replace("{searchJs}", searchJs); str = str.Replace("{prefix}", strPrefix); str = str.Replace("{newprefix}", prefix); str = str.Replace("{add}", add); str = str.Replace("{addN}", addN); str = str.Replace("{edit}", edit); str = str.Replace("{editN}", editN); str = str.Replace("{del}", del); str = str.Replace("{delN}", delN); str = str.Replace("{view}", view); str = str.Replace("{viewN}", viewN); //str = str.Replace("{import}", import); //str = str.Replace("{importN}", importN); //str = str.Replace("{export}", export); //str = str.Replace("{exportN}", exportN); str = str.Replace("{search}", search); str = str.Replace("{searchN}", searchN); str = str.Replace("{moduleName}", M_Model.M_ModuleCode); str = str.Replace("{nameSpace}", M_Model.M_NameSpace); if (toolbar) { str = ""; } return str; }
public ActionResult GridEdit(string oper, string id) { string ModuleCode = Request["ModuleCode"] == null ? "" : Request["ModuleCode"].ToString(); string NameSpace = Request["NameSpace"] == null ? "" : Request["NameSpace"].ToString(); string Form = Request["form"] == null ? "" : Request["form"]; string FormId = Request["btn"]; oper = !string.IsNullOrEmpty(oper) ? oper : (Request["oper"] != null ? Request["oper"] : ""); id = !string.IsNullOrEmpty(id) ? id : (Request["id"] != null ? Request["id"] : ""); string TableName = ""; string InertSQL = ""; string UpdateSQL = ""; string DeleteSQL = ""; string TableKey = ""; string filterKey = ""; bool result = false; string strResult = "fail"; Dictionary<string, string> FormValue = new Dictionary<string, string>(); Sys_Config_ListPage model=new Sys_Config_ListPage(); List<Sys_Config_Fieled> listfiled = new List<Sys_Config_Fieled>(); StringBuilder ErrorList = new StringBuilder(); if (!string.IsNullOrEmpty(ModuleCode) && !string.IsNullOrEmpty(NameSpace)) { // var _model = instance.GetListByCode(" AND M_ModuleCode='" + ModuleCode + "' AND M_NameSpace='" + NameSpace + "' "); var _model = instance.GetListByCode(" AND M_ModuleCode='" + ModuleCode + "' "); model = _model.Count > 0 ? _model[0] : null; //var listfiled = filedInstance.GetListByCode(" AND D_ModuleCode='" + ModuleCode + "' AND D_NameSpace='" + NameSpace + "' "); listfiled = filedInstance.GetListByCode(" AND D_ModuleCode='" + ModuleCode + "'"); TableName = model.M_TableName; TableKey = listfiled.Where(o => o.D_IsKey == 1).FirstOrDefault().D_Index; filterKey = string.Format("{0}='{1}'", TableKey, id); if (!string.IsNullOrEmpty(Form)) { FormValue = FormParse(Form); string _key = ""; string _value = ""; string _upkey = ""; filterKey = string.Format("{0}='{1}'", TableKey, FormValue[TableKey]); var newListFiled = listfiled.Where(o => string.IsNullOrEmpty(o.D_EditHidden) || o.D_EditHidden == "false" || !string.IsNullOrEmpty(o.D_DefaultValue) || o.D_EditType == "loadall"); if (!string.IsNullOrEmpty(FormId)) { #region 扩展 if (FormId.Contains("btn1")) { newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF1) && JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF1).Show.ToLower() == "true") .OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF1).Order).ToList(); } else if (FormId.Contains("btn2")) { newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF2) && JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF2).Show.ToLower() == "true") .OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF2).Order).ToList(); } else if (FormId.Contains("btn3")) { newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF3) && JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF3).Show.ToLower() == "true") .OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF3).Order).ToList(); } else if (FormId.Contains("btn4")) { newListFiled = listfiled.Where(o => !string.IsNullOrEmpty(o.D_UDEF4) && JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF4).Show.ToLower() == "true") .OrderBy(o => JsonConvert.DeserializeObject<FormEdit>(o.D_UDEF4).Order).ToList(); } #endregion } foreach (var item in newListFiled) { try { if (!string.IsNullOrEmpty(FormValue[item.D_Index])) { if (!string.IsNullOrEmpty(item.D_Type) && item.D_Type.Contains("int")) { _value += "" + FormValue[item.D_Index] + "" + ","; _upkey += item.D_Index + "=" + FormValue[item.D_Index] + "" + ","; } else { if (item.D_Type.Contains("datetime")) { FormValue[item.D_Index] = FormValue[item.D_Index].Replace("+"," "); } _value += "'" + FormValue[item.D_Index] + "'" + ","; _upkey += item.D_Index + "='" + FormValue[item.D_Index] + "'" + ","; } _key += item.D_Index + ","; } else { if (!string.IsNullOrEmpty(item.D_Type) && (item.D_Type.Contains("int") || item.D_Type.Contains("decimal"))) { _value += "0,"; _upkey += item.D_Index + "=0" + ","; } else { if (item.D_Type.Contains("datetime")) { FormValue[item.D_Index] = "1900-01-01"; } _value += "'" + FormValue[item.D_Index] + "'" + ","; _upkey += item.D_Index + "='" + FormValue[item.D_Index] + "'" + ","; } _key += item.D_Index + ","; } } catch (System.Exception ex) { ErrorList.AppendLine(ex.ToString()); continue; } } //拼接Add sql _key = _key + " CreateTime,"; _value = _value + "'" + DateTime.Now + "',"; InertSQL = "INSERT INTO " + TableName + " (" + _key.TrimEnd(',') + ") VALUES (" + _value.TrimEnd(',') + ") "; //拼接update sql _upkey = _upkey + " UpdateTime='" + DateTime.Now + "',"; UpdateSQL = "UPDATE " + TableName + " SET " + _upkey.TrimEnd(',') + " WHERE " + filterKey; } //拼接 Delete Sql DeleteSQL = "UPDATE " + TableName + " SET Stat=1,DeleteTime='" + DateTime.Now + "' WHERE " + filterKey; } switch (oper) { case "add": result = instance.SaveData(InertSQL); strResult = result ? "success" : "fail"; //功能日志 this.OpLog(model.M_ModuleCode, "添加:" + model.M_Title + ",编码:" + FormValue[TableKey], strResult + "," + InertSQL + "," + ErrorList.ToString()); return Content(strResult); case "edit": result = instance.SaveData(UpdateSQL); strResult = result ? "success" : "fail"; //功能日志 this.OpLog(model.M_ModuleCode, "修改:" + model.M_Title + ",编码:" + FormValue[TableKey], strResult + "," + InertSQL + "," + ErrorList.ToString()); return Content(strResult); case "del": result = instance.SaveData(DeleteSQL); strResult = result ? "success" : "fail"; //功能日志 this.OpLog(model.M_ModuleCode, "删除:" + model.M_Title + ",编码:" + id, strResult + "," + InertSQL + "," + ErrorList.ToString()); return Content(strResult); case "view": DataTable dt = instance.ListDataByCode(TableName, filterKey); DataTable newDt = dt.Clone(); //string json = JsonConvert.SerializeObject(dt, new DataTableConverter(), new JsonDateConverter("yyyy-MM-dd")); for (var x = 0; x < newDt.Columns.Count;x++ ) { var D_Index = dt.Columns[x].ColumnName; var tmpModel = listfiled.Where(o => o.D_Index == D_Index); if (tmpModel.Count() > 0) { if (tmpModel.FirstOrDefault().D_EditType == "datetime") { newDt.Columns[x].DataType = typeof(string); } else if (tmpModel.FirstOrDefault().D_EditType == "date") { newDt.Columns[x].DataType = typeof(string); } } } newDt.Rows.Clear(); for (var i = 0; i < dt.Rows.Count;i++ ) { DataRow newRow = newDt.NewRow(); for (var j = 0; j < dt.Columns.Count;j++ ) { var D_Index = dt.Columns[j].ColumnName; var tmpModel = listfiled.Where(o => o.D_Index == D_Index); if (tmpModel.Count()>0) { if (tmpModel.FirstOrDefault().D_EditType == "datetime") { newRow[D_Index] = dt.Rows[i][j] != null && !string.IsNullOrEmpty(dt.Rows[i][j].ToString()) ? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][j].ToString()), new JsonDateConverter("yyyy-MM-dd HH:mm:ss")).Replace("\"","") : ""; } else if (tmpModel.FirstOrDefault().D_EditType == "date") { //newDt.Columns[j].DataType = typeof(string); newRow[D_Index] = dt.Rows[i][j] != null && !string.IsNullOrEmpty(dt.Rows[i][j].ToString()) ? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][j].ToString()), new JsonDateConverter("yyyy-MM-dd")).Replace("\"", "") : ""; } else { newRow[D_Index] = dt.Rows[i][j]; } } } newDt.Rows.Add(newRow); } string json = JsonConvert.SerializeObject(newDt, new DataTableConverter()); return JavaScript(json); } return Content(""); }
/// <summary> /// 获取指定的List报表类型配置表 Sys_Config_ListPage对象集合 /// </summary> public List<Sys_Config_ListPage> GetListByWhere(string strCondition) { List<Sys_Config_ListPage> ret = new List<Sys_Config_ListPage>(); string sql = "SELECT M_ID,M_ModuleCode,M_TableName,M_NameSpace,M_SQL,M_Type,M_Title,M_AutoWidth,M_Width,M_Height,M_URL,M_MType,M_GetDataType,M_SQLParameter,M_RowNum,M_RowList,M_FooterRow,M_ViewURL,M_ViewType,M_Edit,M_EditUrl,M_EditSubmitUrl,M_OnSelectRow,M_GridComplete,M_InlineEditing,M_ImportURL,M_ImportTable,M_ImportExport,M_AltRows,M_Altclass,M_emptyrecords,M_Gridstate,M_EditCloumNum,M_ToolBar,M_ToolBarExtend,Stat,M_ExtendsJs,M_ExtendsControl,M_EditTitle,M_MSelect,M_Parameters,M_GroupingView,M_FormEditing,M_FormMethod,M_IsAdd,M_IsEdit,M_IsDelete,M_IsView FROM Sys_Config_ListPage WHERE 1=1 AND ((Stat is null) or (Stat=0) ) "; if(!string.IsNullOrEmpty(strCondition)) { strCondition.Replace('\'','"'); //防sql注入 sql += strCondition ; } sql += " ORDER BY M_ID DESC "; SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { Sys_Config_ListPage sys_Config_ListPage = new Sys_Config_ListPage(); if (dr["M_ID"] != DBNull.Value) sys_Config_ListPage.M_ID = Convert.ToInt32(dr["M_ID"]); if (dr["M_ModuleCode"] != DBNull.Value) sys_Config_ListPage.M_ModuleCode = Convert.ToString(dr["M_ModuleCode"]); if (dr["M_TableName"] != DBNull.Value) sys_Config_ListPage.M_TableName = Convert.ToString(dr["M_TableName"]); if (dr["M_NameSpace"] != DBNull.Value) sys_Config_ListPage.M_NameSpace = Convert.ToString(dr["M_NameSpace"]); if (dr["M_SQL"] != DBNull.Value) sys_Config_ListPage.M_SQL = Convert.ToString(dr["M_SQL"]); if (dr["M_Type"] != DBNull.Value) sys_Config_ListPage.M_Type = Convert.ToString(dr["M_Type"]); if (dr["M_Title"] != DBNull.Value) sys_Config_ListPage.M_Title = Convert.ToString(dr["M_Title"]); if (dr["M_AutoWidth"] != DBNull.Value) sys_Config_ListPage.M_AutoWidth = Convert.ToString(dr["M_AutoWidth"]); if (dr["M_Width"] != DBNull.Value) sys_Config_ListPage.M_Width = Convert.ToString(dr["M_Width"]); if (dr["M_Height"] != DBNull.Value) sys_Config_ListPage.M_Height = Convert.ToString(dr["M_Height"]); if (dr["M_URL"] != DBNull.Value) sys_Config_ListPage.M_URL = Convert.ToString(dr["M_URL"]); if (dr["M_MType"] != DBNull.Value) sys_Config_ListPage.M_MType = Convert.ToString(dr["M_MType"]); if (dr["M_GetDataType"] != DBNull.Value) sys_Config_ListPage.M_GetDataType = Convert.ToString(dr["M_GetDataType"]); if (dr["M_SQLParameter"] != DBNull.Value) sys_Config_ListPage.M_SQLParameter = Convert.ToString(dr["M_SQLParameter"]); if (dr["M_RowNum"] != DBNull.Value) sys_Config_ListPage.M_RowNum = Convert.ToString(dr["M_RowNum"]); if (dr["M_RowList"] != DBNull.Value) sys_Config_ListPage.M_RowList = Convert.ToString(dr["M_RowList"]); if (dr["M_FooterRow"] != DBNull.Value) sys_Config_ListPage.M_FooterRow = Convert.ToString(dr["M_FooterRow"]); if (dr["M_ViewURL"] != DBNull.Value) sys_Config_ListPage.M_ViewURL = Convert.ToString(dr["M_ViewURL"]); if (dr["M_ViewType"] != DBNull.Value) sys_Config_ListPage.M_ViewType = Convert.ToString(dr["M_ViewType"]); if (dr["M_Edit"] != DBNull.Value) sys_Config_ListPage.M_Edit = Convert.ToString(dr["M_Edit"]); if (dr["M_EditUrl"] != DBNull.Value) sys_Config_ListPage.M_EditUrl = Convert.ToString(dr["M_EditUrl"]); if (dr["M_EditSubmitUrl"] != DBNull.Value) sys_Config_ListPage.M_EditSubmitUrl = Convert.ToString(dr["M_EditSubmitUrl"]); if (dr["M_OnSelectRow"] != DBNull.Value) sys_Config_ListPage.M_OnSelectRow = Convert.ToString(dr["M_OnSelectRow"]); if (dr["M_GridComplete"] != DBNull.Value) sys_Config_ListPage.M_GridComplete = Convert.ToString(dr["M_GridComplete"]); if (dr["M_InlineEditing"] != DBNull.Value) sys_Config_ListPage.M_InlineEditing = Convert.ToString(dr["M_InlineEditing"]); if (dr["M_ImportURL"] != DBNull.Value) sys_Config_ListPage.M_ImportURL = Convert.ToString(dr["M_ImportURL"]); if (dr["M_ImportTable"] != DBNull.Value) sys_Config_ListPage.M_ImportTable = Convert.ToString(dr["M_ImportTable"]); if (dr["M_ImportExport"] != DBNull.Value) sys_Config_ListPage.M_ImportExport = Convert.ToString(dr["M_ImportExport"]); if (dr["M_AltRows"] != DBNull.Value) sys_Config_ListPage.M_AltRows = Convert.ToString(dr["M_AltRows"]); if (dr["M_Altclass"] != DBNull.Value) sys_Config_ListPage.M_Altclass = Convert.ToString(dr["M_Altclass"]); if (dr["M_emptyrecords"] != DBNull.Value) sys_Config_ListPage.M_emptyrecords = Convert.ToString(dr["M_emptyrecords"]); if (dr["M_Gridstate"] != DBNull.Value) sys_Config_ListPage.M_Gridstate = Convert.ToString(dr["M_Gridstate"]); if (dr["M_EditCloumNum"] != DBNull.Value) sys_Config_ListPage.M_EditCloumNum = Convert.ToInt32(dr["M_EditCloumNum"]); if (dr["M_ToolBar"] != DBNull.Value) sys_Config_ListPage.M_ToolBar = Convert.ToString(dr["M_ToolBar"]); if (dr["M_ToolBarExtend"] != DBNull.Value) sys_Config_ListPage.M_ToolBarExtend = Convert.ToString(dr["M_ToolBarExtend"]); if (dr["Stat"] != DBNull.Value) sys_Config_ListPage.Stat = Convert.ToInt32(dr["Stat"]); if (dr["M_ExtendsJs"] != DBNull.Value) sys_Config_ListPage.M_ExtendsJs = Convert.ToString(dr["M_ExtendsJs"]); if (dr["M_ExtendsControl"] != DBNull.Value) sys_Config_ListPage.M_ExtendsControl = Convert.ToString(dr["M_ExtendsControl"]); if (dr["M_EditTitle"] != DBNull.Value) sys_Config_ListPage.M_EditTitle = Convert.ToString(dr["M_EditTitle"]); if (dr["M_MSelect"] != DBNull.Value) sys_Config_ListPage.M_MSelect = Convert.ToString(dr["M_MSelect"]); if (dr["M_Parameters"] != DBNull.Value) sys_Config_ListPage.M_Parameters = Convert.ToString(dr["M_Parameters"]); if (dr["M_GroupingView"] != DBNull.Value) sys_Config_ListPage.M_GroupingView = Convert.ToString(dr["M_GroupingView"]); if (dr["M_FormEditing"] != DBNull.Value) sys_Config_ListPage.M_FormEditing = Convert.ToString(dr["M_FormEditing"]); if (dr["M_FormMethod"] != DBNull.Value) sys_Config_ListPage.M_FormMethod = Convert.ToString(dr["M_FormMethod"]); if (dr["M_IsAdd"] != DBNull.Value) sys_Config_ListPage.M_IsAdd = Convert.ToInt32(dr["M_IsAdd"]); if (dr["M_IsEdit"] != DBNull.Value) sys_Config_ListPage.M_IsEdit = Convert.ToInt32(dr["M_IsEdit"]); if (dr["M_IsDelete"] != DBNull.Value) sys_Config_ListPage.M_IsDelete = Convert.ToInt32(dr["M_IsDelete"]); if (dr["M_IsView"] != DBNull.Value) sys_Config_ListPage.M_IsView = Convert.ToString(dr["M_IsView"]); ret.Add(sys_Config_ListPage); } }catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return ret; }
/// <summary> /// 添加List报表类型配置表 Sys_Config_ListPage对象(即:一条记录) /// </summary> public object AddWithReturn(Sys_Config_ListPage sys_Config_ListPage) { string sql = "INSERT INTO Sys_Config_ListPage (M_ModuleCode,M_TableName,M_NameSpace,M_SQL,M_Type,M_Title,M_AutoWidth,M_Width,M_Height,M_URL,M_MType,M_GetDataType,M_SQLParameter,M_RowNum,M_RowList,M_FooterRow,M_ViewURL,M_ViewType,M_Edit,M_EditUrl,M_EditSubmitUrl,M_OnSelectRow,M_GridComplete,M_InlineEditing,M_ImportURL,M_ImportTable,M_ImportExport,M_AltRows,M_Altclass,M_emptyrecords,M_Gridstate,M_EditCloumNum,M_ToolBar,M_ToolBarExtend,Stat,M_ExtendsJs,M_ExtendsControl,M_EditTitle,M_MSelect,M_Parameters,M_GroupingView,M_FormEditing,M_FormMethod,M_IsAdd,M_IsEdit,M_IsDelete,M_IsView) VALUES (@M_ModuleCode,@M_TableName,@M_NameSpace,@M_SQL,@M_Type,@M_Title,@M_AutoWidth,@M_Width,@M_Height,@M_URL,@M_MType,@M_GetDataType,@M_SQLParameter,@M_RowNum,@M_RowList,@M_FooterRow,@M_ViewURL,@M_ViewType,@M_Edit,@M_EditUrl,@M_EditSubmitUrl,@M_OnSelectRow,@M_GridComplete,@M_InlineEditing,@M_ImportURL,@M_ImportTable,@M_ImportExport,@M_AltRows,@M_Altclass,@M_emptyrecords,@M_Gridstate,@M_EditCloumNum,@M_ToolBar,@M_ToolBarExtend,@Stat,@M_ExtendsJs,@M_ExtendsControl,@M_EditTitle,@M_MSelect,@M_Parameters,@M_GroupingView,@M_FormEditing,@M_FormMethod,@M_IsAdd,@M_IsEdit,@M_IsDelete,@M_IsView);SELECT @@IDENTITY AS ReturnID;"; if (string.IsNullOrEmpty(sys_Config_ListPage.M_ModuleCode)) { idb.AddParameter("@M_ModuleCode", DBNull.Value); } else { idb.AddParameter("@M_ModuleCode", sys_Config_ListPage.M_ModuleCode); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_TableName)) { idb.AddParameter("@M_TableName", DBNull.Value); } else { idb.AddParameter("@M_TableName", sys_Config_ListPage.M_TableName); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_NameSpace)) { idb.AddParameter("@M_NameSpace", DBNull.Value); } else { idb.AddParameter("@M_NameSpace", sys_Config_ListPage.M_NameSpace); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQL)) { idb.AddParameter("@M_SQL", DBNull.Value); } else { idb.AddParameter("@M_SQL", sys_Config_ListPage.M_SQL); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Type)) { idb.AddParameter("@M_Type", DBNull.Value); } else { idb.AddParameter("@M_Type", sys_Config_ListPage.M_Type); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Title)) { idb.AddParameter("@M_Title", DBNull.Value); } else { idb.AddParameter("@M_Title", sys_Config_ListPage.M_Title); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_AutoWidth)) { idb.AddParameter("@M_AutoWidth", DBNull.Value); } else { idb.AddParameter("@M_AutoWidth", sys_Config_ListPage.M_AutoWidth); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Width)) { idb.AddParameter("@M_Width", DBNull.Value); } else { idb.AddParameter("@M_Width", sys_Config_ListPage.M_Width); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Height)) { idb.AddParameter("@M_Height", DBNull.Value); } else { idb.AddParameter("@M_Height", sys_Config_ListPage.M_Height); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_URL)) { idb.AddParameter("@M_URL", DBNull.Value); } else { idb.AddParameter("@M_URL", sys_Config_ListPage.M_URL); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_MType)) { idb.AddParameter("@M_MType", DBNull.Value); } else { idb.AddParameter("@M_MType", sys_Config_ListPage.M_MType); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_GetDataType)) { idb.AddParameter("@M_GetDataType", DBNull.Value); } else { idb.AddParameter("@M_GetDataType", sys_Config_ListPage.M_GetDataType); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQLParameter)) { idb.AddParameter("@M_SQLParameter", DBNull.Value); } else { idb.AddParameter("@M_SQLParameter", sys_Config_ListPage.M_SQLParameter); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowNum)) { idb.AddParameter("@M_RowNum", DBNull.Value); } else { idb.AddParameter("@M_RowNum", sys_Config_ListPage.M_RowNum); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowList)) { idb.AddParameter("@M_RowList", DBNull.Value); } else { idb.AddParameter("@M_RowList", sys_Config_ListPage.M_RowList); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_FooterRow)) { idb.AddParameter("@M_FooterRow", DBNull.Value); } else { idb.AddParameter("@M_FooterRow", sys_Config_ListPage.M_FooterRow); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewURL)) { idb.AddParameter("@M_ViewURL", DBNull.Value); } else { idb.AddParameter("@M_ViewURL", sys_Config_ListPage.M_ViewURL); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewType)) { idb.AddParameter("@M_ViewType", DBNull.Value); } else { idb.AddParameter("@M_ViewType", sys_Config_ListPage.M_ViewType); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Edit)) { idb.AddParameter("@M_Edit", DBNull.Value); } else { idb.AddParameter("@M_Edit", sys_Config_ListPage.M_Edit); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditUrl)) { idb.AddParameter("@M_EditUrl", DBNull.Value); } else { idb.AddParameter("@M_EditUrl", sys_Config_ListPage.M_EditUrl); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditSubmitUrl)) { idb.AddParameter("@M_EditSubmitUrl", DBNull.Value); } else { idb.AddParameter("@M_EditSubmitUrl", sys_Config_ListPage.M_EditSubmitUrl); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_OnSelectRow)) { idb.AddParameter("@M_OnSelectRow", DBNull.Value); } else { idb.AddParameter("@M_OnSelectRow", sys_Config_ListPage.M_OnSelectRow); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_GridComplete)) { idb.AddParameter("@M_GridComplete", DBNull.Value); } else { idb.AddParameter("@M_GridComplete", sys_Config_ListPage.M_GridComplete); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_InlineEditing)) { idb.AddParameter("@M_InlineEditing", DBNull.Value); } else { idb.AddParameter("@M_InlineEditing", sys_Config_ListPage.M_InlineEditing); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportURL)) { idb.AddParameter("@M_ImportURL", DBNull.Value); } else { idb.AddParameter("@M_ImportURL", sys_Config_ListPage.M_ImportURL); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportTable)) { idb.AddParameter("@M_ImportTable", DBNull.Value); } else { idb.AddParameter("@M_ImportTable", sys_Config_ListPage.M_ImportTable); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportExport)) { idb.AddParameter("@M_ImportExport", DBNull.Value); } else { idb.AddParameter("@M_ImportExport", sys_Config_ListPage.M_ImportExport); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_AltRows)) { idb.AddParameter("@M_AltRows", DBNull.Value); } else { idb.AddParameter("@M_AltRows", sys_Config_ListPage.M_AltRows); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Altclass)) { idb.AddParameter("@M_Altclass", DBNull.Value); } else { idb.AddParameter("@M_Altclass", sys_Config_ListPage.M_Altclass); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_emptyrecords)) { idb.AddParameter("@M_emptyrecords", DBNull.Value); } else { idb.AddParameter("@M_emptyrecords", sys_Config_ListPage.M_emptyrecords); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Gridstate)) { idb.AddParameter("@M_Gridstate", DBNull.Value); } else { idb.AddParameter("@M_Gridstate", sys_Config_ListPage.M_Gridstate); } if (sys_Config_ListPage.M_EditCloumNum == 0) { idb.AddParameter("@M_EditCloumNum", 0); } else { idb.AddParameter("@M_EditCloumNum", sys_Config_ListPage.M_EditCloumNum); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBar)) { idb.AddParameter("@M_ToolBar", DBNull.Value); } else { idb.AddParameter("@M_ToolBar", sys_Config_ListPage.M_ToolBar); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBarExtend)) { idb.AddParameter("@M_ToolBarExtend", DBNull.Value); } else { idb.AddParameter("@M_ToolBarExtend", sys_Config_ListPage.M_ToolBarExtend); } if (sys_Config_ListPage.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", sys_Config_ListPage.Stat); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsJs)) { idb.AddParameter("@M_ExtendsJs", DBNull.Value); } else { idb.AddParameter("@M_ExtendsJs", sys_Config_ListPage.M_ExtendsJs); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsControl)) { idb.AddParameter("@M_ExtendsControl", DBNull.Value); } else { idb.AddParameter("@M_ExtendsControl", sys_Config_ListPage.M_ExtendsControl); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditTitle)) { idb.AddParameter("@M_EditTitle", DBNull.Value); } else { idb.AddParameter("@M_EditTitle", sys_Config_ListPage.M_EditTitle); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_MSelect)) { idb.AddParameter("@M_MSelect", DBNull.Value); } else { idb.AddParameter("@M_MSelect", sys_Config_ListPage.M_MSelect); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_Parameters)) { idb.AddParameter("@M_Parameters", DBNull.Value); } else { idb.AddParameter("@M_Parameters", sys_Config_ListPage.M_Parameters); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_GroupingView)) { idb.AddParameter("@M_GroupingView", DBNull.Value); } else { idb.AddParameter("@M_GroupingView", sys_Config_ListPage.M_GroupingView); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormEditing)) { idb.AddParameter("@M_FormEditing", DBNull.Value); } else { idb.AddParameter("@M_FormEditing", sys_Config_ListPage.M_FormEditing); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormMethod)) { idb.AddParameter("@M_FormMethod", DBNull.Value); } else { idb.AddParameter("@M_FormMethod", sys_Config_ListPage.M_FormMethod); } if (sys_Config_ListPage.M_IsAdd == 0) { idb.AddParameter("@M_IsAdd", 0); } else { idb.AddParameter("@M_IsAdd", sys_Config_ListPage.M_IsAdd); } if (sys_Config_ListPage.M_IsEdit == 0) { idb.AddParameter("@M_IsEdit", 0); } else { idb.AddParameter("@M_IsEdit", sys_Config_ListPage.M_IsEdit); } if (sys_Config_ListPage.M_IsDelete == 0) { idb.AddParameter("@M_IsDelete", 0); } else { idb.AddParameter("@M_IsDelete", sys_Config_ListPage.M_IsDelete); } if (string.IsNullOrEmpty(sys_Config_ListPage.M_IsView)) { idb.AddParameter("@M_IsView", DBNull.Value); } else { idb.AddParameter("@M_IsView", sys_Config_ListPage.M_IsView); } return idb.ReturnValue(sql); }
/// <summary> /// 更新List报表类型配置表 Sys_Config_ListPage对象(即:一条记录 /// </summary> public int Update(Sys_Config_ListPage sys_Config_ListPage) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE Sys_Config_ListPage SET "); if(sys_Config_ListPage.M_ModuleCode_IsChanged){sbParameter.Append("M_ModuleCode=@M_ModuleCode, ");} if(sys_Config_ListPage.M_TableName_IsChanged){sbParameter.Append("M_TableName=@M_TableName, ");} if(sys_Config_ListPage.M_NameSpace_IsChanged){sbParameter.Append("M_NameSpace=@M_NameSpace, ");} if(sys_Config_ListPage.M_SQL_IsChanged){sbParameter.Append("M_SQL=@M_SQL, ");} if(sys_Config_ListPage.M_Type_IsChanged){sbParameter.Append("M_Type=@M_Type, ");} if(sys_Config_ListPage.M_Title_IsChanged){sbParameter.Append("M_Title=@M_Title, ");} if(sys_Config_ListPage.M_AutoWidth_IsChanged){sbParameter.Append("M_AutoWidth=@M_AutoWidth, ");} if(sys_Config_ListPage.M_Width_IsChanged){sbParameter.Append("M_Width=@M_Width, ");} if(sys_Config_ListPage.M_Height_IsChanged){sbParameter.Append("M_Height=@M_Height, ");} if(sys_Config_ListPage.M_URL_IsChanged){sbParameter.Append("M_URL=@M_URL, ");} if(sys_Config_ListPage.M_MType_IsChanged){sbParameter.Append("M_MType=@M_MType, ");} if(sys_Config_ListPage.M_GetDataType_IsChanged){sbParameter.Append("M_GetDataType=@M_GetDataType, ");} if(sys_Config_ListPage.M_SQLParameter_IsChanged){sbParameter.Append("M_SQLParameter=@M_SQLParameter, ");} if(sys_Config_ListPage.M_RowNum_IsChanged){sbParameter.Append("M_RowNum=@M_RowNum, ");} if(sys_Config_ListPage.M_RowList_IsChanged){sbParameter.Append("M_RowList=@M_RowList, ");} if(sys_Config_ListPage.M_FooterRow_IsChanged){sbParameter.Append("M_FooterRow=@M_FooterRow, ");} if(sys_Config_ListPage.M_ViewURL_IsChanged){sbParameter.Append("M_ViewURL=@M_ViewURL, ");} if(sys_Config_ListPage.M_ViewType_IsChanged){sbParameter.Append("M_ViewType=@M_ViewType, ");} if(sys_Config_ListPage.M_Edit_IsChanged){sbParameter.Append("M_Edit=@M_Edit, ");} if(sys_Config_ListPage.M_EditUrl_IsChanged){sbParameter.Append("M_EditUrl=@M_EditUrl, ");} if(sys_Config_ListPage.M_EditSubmitUrl_IsChanged){sbParameter.Append("M_EditSubmitUrl=@M_EditSubmitUrl, ");} if(sys_Config_ListPage.M_OnSelectRow_IsChanged){sbParameter.Append("M_OnSelectRow=@M_OnSelectRow, ");} if(sys_Config_ListPage.M_GridComplete_IsChanged){sbParameter.Append("M_GridComplete=@M_GridComplete, ");} if(sys_Config_ListPage.M_InlineEditing_IsChanged){sbParameter.Append("M_InlineEditing=@M_InlineEditing, ");} if(sys_Config_ListPage.M_ImportURL_IsChanged){sbParameter.Append("M_ImportURL=@M_ImportURL, ");} if(sys_Config_ListPage.M_ImportTable_IsChanged){sbParameter.Append("M_ImportTable=@M_ImportTable, ");} if(sys_Config_ListPage.M_ImportExport_IsChanged){sbParameter.Append("M_ImportExport=@M_ImportExport, ");} if(sys_Config_ListPage.M_AltRows_IsChanged){sbParameter.Append("M_AltRows=@M_AltRows, ");} if(sys_Config_ListPage.M_Altclass_IsChanged){sbParameter.Append("M_Altclass=@M_Altclass, ");} if(sys_Config_ListPage.M_emptyrecords_IsChanged){sbParameter.Append("M_emptyrecords=@M_emptyrecords, ");} if(sys_Config_ListPage.M_Gridstate_IsChanged){sbParameter.Append("M_Gridstate=@M_Gridstate, ");} if(sys_Config_ListPage.M_EditCloumNum_IsChanged){sbParameter.Append("M_EditCloumNum=@M_EditCloumNum, ");} if(sys_Config_ListPage.M_ToolBar_IsChanged){sbParameter.Append("M_ToolBar=@M_ToolBar, ");} if(sys_Config_ListPage.M_ToolBarExtend_IsChanged){sbParameter.Append("M_ToolBarExtend=@M_ToolBarExtend, ");} if(sys_Config_ListPage.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(sys_Config_ListPage.M_ExtendsJs_IsChanged){sbParameter.Append("M_ExtendsJs=@M_ExtendsJs, ");} if(sys_Config_ListPage.M_ExtendsControl_IsChanged){sbParameter.Append("M_ExtendsControl=@M_ExtendsControl, ");} if(sys_Config_ListPage.M_EditTitle_IsChanged){sbParameter.Append("M_EditTitle=@M_EditTitle, ");} if(sys_Config_ListPage.M_MSelect_IsChanged){sbParameter.Append("M_MSelect=@M_MSelect, ");} if(sys_Config_ListPage.M_Parameters_IsChanged){sbParameter.Append("M_Parameters=@M_Parameters, ");} if(sys_Config_ListPage.M_GroupingView_IsChanged){sbParameter.Append("M_GroupingView=@M_GroupingView, ");} if(sys_Config_ListPage.M_FormEditing_IsChanged){sbParameter.Append("M_FormEditing=@M_FormEditing, ");} if(sys_Config_ListPage.M_FormMethod_IsChanged){sbParameter.Append("M_FormMethod=@M_FormMethod, ");} if(sys_Config_ListPage.M_IsAdd_IsChanged){sbParameter.Append("M_IsAdd=@M_IsAdd, ");} if(sys_Config_ListPage.M_IsEdit_IsChanged){sbParameter.Append("M_IsEdit=@M_IsEdit, ");} if(sys_Config_ListPage.M_IsDelete_IsChanged){sbParameter.Append("M_IsDelete=@M_IsDelete, ");} if(sys_Config_ListPage.M_IsView_IsChanged){sbParameter.Append("M_IsView=@M_IsView ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and M_ID=@M_ID; " ); string sql=sb.ToString(); if(sys_Config_ListPage.M_ModuleCode_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ModuleCode)) { idb.AddParameter("@M_ModuleCode", DBNull.Value); } else { idb.AddParameter("@M_ModuleCode", sys_Config_ListPage.M_ModuleCode); } } if(sys_Config_ListPage.M_TableName_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_TableName)) { idb.AddParameter("@M_TableName", DBNull.Value); } else { idb.AddParameter("@M_TableName", sys_Config_ListPage.M_TableName); } } if(sys_Config_ListPage.M_NameSpace_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_NameSpace)) { idb.AddParameter("@M_NameSpace", DBNull.Value); } else { idb.AddParameter("@M_NameSpace", sys_Config_ListPage.M_NameSpace); } } if(sys_Config_ListPage.M_SQL_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQL)) { idb.AddParameter("@M_SQL", DBNull.Value); } else { idb.AddParameter("@M_SQL", sys_Config_ListPage.M_SQL); } } if(sys_Config_ListPage.M_Type_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Type)) { idb.AddParameter("@M_Type", DBNull.Value); } else { idb.AddParameter("@M_Type", sys_Config_ListPage.M_Type); } } if(sys_Config_ListPage.M_Title_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Title)) { idb.AddParameter("@M_Title", DBNull.Value); } else { idb.AddParameter("@M_Title", sys_Config_ListPage.M_Title); } } if(sys_Config_ListPage.M_AutoWidth_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_AutoWidth)) { idb.AddParameter("@M_AutoWidth", DBNull.Value); } else { idb.AddParameter("@M_AutoWidth", sys_Config_ListPage.M_AutoWidth); } } if(sys_Config_ListPage.M_Width_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Width)) { idb.AddParameter("@M_Width", DBNull.Value); } else { idb.AddParameter("@M_Width", sys_Config_ListPage.M_Width); } } if(sys_Config_ListPage.M_Height_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Height)) { idb.AddParameter("@M_Height", DBNull.Value); } else { idb.AddParameter("@M_Height", sys_Config_ListPage.M_Height); } } if(sys_Config_ListPage.M_URL_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_URL)) { idb.AddParameter("@M_URL", DBNull.Value); } else { idb.AddParameter("@M_URL", sys_Config_ListPage.M_URL); } } if(sys_Config_ListPage.M_MType_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_MType)) { idb.AddParameter("@M_MType", DBNull.Value); } else { idb.AddParameter("@M_MType", sys_Config_ListPage.M_MType); } } if(sys_Config_ListPage.M_GetDataType_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_GetDataType)) { idb.AddParameter("@M_GetDataType", DBNull.Value); } else { idb.AddParameter("@M_GetDataType", sys_Config_ListPage.M_GetDataType); } } if(sys_Config_ListPage.M_SQLParameter_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_SQLParameter)) { idb.AddParameter("@M_SQLParameter", DBNull.Value); } else { idb.AddParameter("@M_SQLParameter", sys_Config_ListPage.M_SQLParameter); } } if(sys_Config_ListPage.M_RowNum_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowNum)) { idb.AddParameter("@M_RowNum", DBNull.Value); } else { idb.AddParameter("@M_RowNum", sys_Config_ListPage.M_RowNum); } } if(sys_Config_ListPage.M_RowList_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_RowList)) { idb.AddParameter("@M_RowList", DBNull.Value); } else { idb.AddParameter("@M_RowList", sys_Config_ListPage.M_RowList); } } if(sys_Config_ListPage.M_FooterRow_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_FooterRow)) { idb.AddParameter("@M_FooterRow", DBNull.Value); } else { idb.AddParameter("@M_FooterRow", sys_Config_ListPage.M_FooterRow); } } if(sys_Config_ListPage.M_ViewURL_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewURL)) { idb.AddParameter("@M_ViewURL", DBNull.Value); } else { idb.AddParameter("@M_ViewURL", sys_Config_ListPage.M_ViewURL); } } if(sys_Config_ListPage.M_ViewType_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ViewType)) { idb.AddParameter("@M_ViewType", DBNull.Value); } else { idb.AddParameter("@M_ViewType", sys_Config_ListPage.M_ViewType); } } if(sys_Config_ListPage.M_Edit_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Edit)) { idb.AddParameter("@M_Edit", DBNull.Value); } else { idb.AddParameter("@M_Edit", sys_Config_ListPage.M_Edit); } } if(sys_Config_ListPage.M_EditUrl_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditUrl)) { idb.AddParameter("@M_EditUrl", DBNull.Value); } else { idb.AddParameter("@M_EditUrl", sys_Config_ListPage.M_EditUrl); } } if(sys_Config_ListPage.M_EditSubmitUrl_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditSubmitUrl)) { idb.AddParameter("@M_EditSubmitUrl", DBNull.Value); } else { idb.AddParameter("@M_EditSubmitUrl", sys_Config_ListPage.M_EditSubmitUrl); } } if(sys_Config_ListPage.M_OnSelectRow_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_OnSelectRow)) { idb.AddParameter("@M_OnSelectRow", DBNull.Value); } else { idb.AddParameter("@M_OnSelectRow", sys_Config_ListPage.M_OnSelectRow); } } if(sys_Config_ListPage.M_GridComplete_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_GridComplete)) { idb.AddParameter("@M_GridComplete", DBNull.Value); } else { idb.AddParameter("@M_GridComplete", sys_Config_ListPage.M_GridComplete); } } if(sys_Config_ListPage.M_InlineEditing_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_InlineEditing)) { idb.AddParameter("@M_InlineEditing", DBNull.Value); } else { idb.AddParameter("@M_InlineEditing", sys_Config_ListPage.M_InlineEditing); } } if(sys_Config_ListPage.M_ImportURL_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportURL)) { idb.AddParameter("@M_ImportURL", DBNull.Value); } else { idb.AddParameter("@M_ImportURL", sys_Config_ListPage.M_ImportURL); } } if(sys_Config_ListPage.M_ImportTable_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportTable)) { idb.AddParameter("@M_ImportTable", DBNull.Value); } else { idb.AddParameter("@M_ImportTable", sys_Config_ListPage.M_ImportTable); } } if(sys_Config_ListPage.M_ImportExport_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ImportExport)) { idb.AddParameter("@M_ImportExport", DBNull.Value); } else { idb.AddParameter("@M_ImportExport", sys_Config_ListPage.M_ImportExport); } } if(sys_Config_ListPage.M_AltRows_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_AltRows)) { idb.AddParameter("@M_AltRows", DBNull.Value); } else { idb.AddParameter("@M_AltRows", sys_Config_ListPage.M_AltRows); } } if(sys_Config_ListPage.M_Altclass_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Altclass)) { idb.AddParameter("@M_Altclass", DBNull.Value); } else { idb.AddParameter("@M_Altclass", sys_Config_ListPage.M_Altclass); } } if(sys_Config_ListPage.M_emptyrecords_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_emptyrecords)) { idb.AddParameter("@M_emptyrecords", DBNull.Value); } else { idb.AddParameter("@M_emptyrecords", sys_Config_ListPage.M_emptyrecords); } } if(sys_Config_ListPage.M_Gridstate_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Gridstate)) { idb.AddParameter("@M_Gridstate", DBNull.Value); } else { idb.AddParameter("@M_Gridstate", sys_Config_ListPage.M_Gridstate); } } if(sys_Config_ListPage.M_EditCloumNum_IsChanged) { if (sys_Config_ListPage.M_EditCloumNum == 0) { idb.AddParameter("@M_EditCloumNum", 0); } else { idb.AddParameter("@M_EditCloumNum", sys_Config_ListPage.M_EditCloumNum); } } if(sys_Config_ListPage.M_ToolBar_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBar)) { idb.AddParameter("@M_ToolBar", DBNull.Value); } else { idb.AddParameter("@M_ToolBar", sys_Config_ListPage.M_ToolBar); } } if(sys_Config_ListPage.M_ToolBarExtend_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ToolBarExtend)) { idb.AddParameter("@M_ToolBarExtend", DBNull.Value); } else { idb.AddParameter("@M_ToolBarExtend", sys_Config_ListPage.M_ToolBarExtend); } } if(sys_Config_ListPage.Stat_IsChanged) { if (sys_Config_ListPage.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", sys_Config_ListPage.Stat); } } if(sys_Config_ListPage.M_ExtendsJs_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsJs)) { idb.AddParameter("@M_ExtendsJs", DBNull.Value); } else { idb.AddParameter("@M_ExtendsJs", sys_Config_ListPage.M_ExtendsJs); } } if(sys_Config_ListPage.M_ExtendsControl_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_ExtendsControl)) { idb.AddParameter("@M_ExtendsControl", DBNull.Value); } else { idb.AddParameter("@M_ExtendsControl", sys_Config_ListPage.M_ExtendsControl); } } if(sys_Config_ListPage.M_EditTitle_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_EditTitle)) { idb.AddParameter("@M_EditTitle", DBNull.Value); } else { idb.AddParameter("@M_EditTitle", sys_Config_ListPage.M_EditTitle); } } if(sys_Config_ListPage.M_MSelect_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_MSelect)) { idb.AddParameter("@M_MSelect", DBNull.Value); } else { idb.AddParameter("@M_MSelect", sys_Config_ListPage.M_MSelect); } } if(sys_Config_ListPage.M_Parameters_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_Parameters)) { idb.AddParameter("@M_Parameters", DBNull.Value); } else { idb.AddParameter("@M_Parameters", sys_Config_ListPage.M_Parameters); } } if(sys_Config_ListPage.M_GroupingView_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_GroupingView)) { idb.AddParameter("@M_GroupingView", DBNull.Value); } else { idb.AddParameter("@M_GroupingView", sys_Config_ListPage.M_GroupingView); } } if(sys_Config_ListPage.M_FormEditing_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormEditing)) { idb.AddParameter("@M_FormEditing", DBNull.Value); } else { idb.AddParameter("@M_FormEditing", sys_Config_ListPage.M_FormEditing); } } if(sys_Config_ListPage.M_FormMethod_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_FormMethod)) { idb.AddParameter("@M_FormMethod", DBNull.Value); } else { idb.AddParameter("@M_FormMethod", sys_Config_ListPage.M_FormMethod); } } if(sys_Config_ListPage.M_IsAdd_IsChanged) { if (sys_Config_ListPage.M_IsAdd == 0) { idb.AddParameter("@M_IsAdd", 0); } else { idb.AddParameter("@M_IsAdd", sys_Config_ListPage.M_IsAdd); } } if(sys_Config_ListPage.M_IsEdit_IsChanged) { if (sys_Config_ListPage.M_IsEdit == 0) { idb.AddParameter("@M_IsEdit", 0); } else { idb.AddParameter("@M_IsEdit", sys_Config_ListPage.M_IsEdit); } } if(sys_Config_ListPage.M_IsDelete_IsChanged) { if (sys_Config_ListPage.M_IsDelete == 0) { idb.AddParameter("@M_IsDelete", 0); } else { idb.AddParameter("@M_IsDelete", sys_Config_ListPage.M_IsDelete); } } if(sys_Config_ListPage.M_IsView_IsChanged) { if (string.IsNullOrEmpty(sys_Config_ListPage.M_IsView)) { idb.AddParameter("@M_IsView", DBNull.Value); } else { idb.AddParameter("@M_IsView", sys_Config_ListPage.M_IsView); } } idb.AddParameter("@M_ID", sys_Config_ListPage.M_ID); return idb.ExeCmd(sql); }
public static string JsonForJqgrid(string Module, DataTable dt, int pageIndex, int pageSize, int totalCount) { StringBuilder jsonBuilder = new StringBuilder(); int total = 0; int page = totalCount / pageSize; total = totalCount > pageSize ? totalCount / pageSize : 1; if (totalCount > pageSize) { if (totalCount % pageSize > 0) { total = total + 1; } } if (totalCount == 0) { total = 0; pageIndex = 0; } jsonBuilder.Append("{\"Page\":" + pageIndex + ",\"Total\":" + total + ",\"Records\":" + totalCount + ",\"Rows\":"); #region 对时间进行格式化 Sys_Config_ListPage M_Model = new Sys_Config_ListPage(); List<Sys_Config_Fieled> listfiled = new List<Sys_Config_Fieled>(); GetListConfig(Module, out M_Model, out listfiled); DataTable newDt = dt.Clone(); //DataTable resultDt = dt.Clone(); //string json = JsonConvert.SerializeObject(dt, new DataTableConverter(), new JsonDateConverter("yyyy-MM-dd")); for (var x = 0; x < newDt.Columns.Count; x++) { var D_Index = dt.Columns[x].ColumnName; var tmpModel = listfiled.Where(o => o.D_Index == D_Index); if (tmpModel.Count() > 0) { if (tmpModel.FirstOrDefault().D_EditType == "datetime") { newDt.Columns[x].DataType = typeof(string); } else if (tmpModel.FirstOrDefault().D_EditType == "date") { newDt.Columns[x].DataType = typeof(string); } } } newDt.Rows.Clear(); for (var i = 0; i < dt.Rows.Count; i++) { DataRow newRow = newDt.NewRow(); for (var j = 0; j < dt.Columns.Count; j++) { var D_Index = dt.Columns[j].ColumnName; var tmpModel = listfiled.Where(o => o.D_Index == D_Index); if (tmpModel.Count() > 0) { if (tmpModel.FirstOrDefault().D_EditType == "datetime") { newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString()) ? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd HH:mm:ss")).Replace("\"", " ") : ""; } else if (tmpModel.FirstOrDefault().D_EditType == "date") { //newDt.Columns[j].DataType = typeof(string); newRow[D_Index] = dt.Rows[i][D_Index] != null && !string.IsNullOrEmpty(dt.Rows[i][D_Index].ToString()) ? JsonConvert.SerializeObject(DateTime.Parse(dt.Rows[i][D_Index].ToString()), new JsonDateConverter("yyyy-MM-dd")).Replace("\"", " ") : ""; } else { newRow[D_Index] = dt.Rows[i][D_Index]; } } } newDt.Rows.Add(newRow); } #endregion jsonBuilder.Append(JsonConvert.SerializeObject(newDt, new DataTableConverter())); //jsonBuilder.Append(" ,\"UserData\":{ \"PUD_Num\":100 } "); jsonBuilder.Append("}"); return jsonBuilder.ToString(); }