/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(Sys_Config_Refer model) { bool result = false; var e = new ModelExceptions(); int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } return(result); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> //public bool Insert(Sys_Config_Refer model,bool IsValid) //{ // var e = new ModelExceptions(); // bool result = false; // if (e.IsValid && IsValid) // { // //完成了验证,开始更新数据库了 // int _result = instance.Add(model); // if (_result > 0) // { // result = true; // } // } // return result; //} /// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Sys_Config_Refer GetModel(string strCondition) { List <Sys_Config_Refer> list = instance.GetListByWhere(strCondition); Sys_Config_Refer model = new Sys_Config_Refer(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return(model); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(Sys_Config_Refer model, bool IsValid) { var e = new ModelExceptions(); bool result = false; if (e.IsValid && IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return(result); }
/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> //public bool Update(Sys_Config_Refer model) //{ // bool result = false; // var e = new ModelExceptions(); // int _rseult = instance.Update(model); // if (_rseult > 0) // { // result = true; // } // return result; //} /// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> //public bool Update(Sys_Config_Refer model,bool IsValid) //{ // bool result = false; // var e = new ModelExceptions(); // if(e.IsValid && IsValid){ // int _rseult = instance.Update(model); // if (_rseult > 0) // { // result = true; // } // } // return result; //} /// <summary> /// 逻辑删除数据 /// </summary> /// <param name='model'>model</param> /// <returns>bool</returns> public bool Delete(string Condition) { bool result = false; List <Sys_Config_Refer> list = instance.GetListByWhere(Condition); if (list.Count > 0) { Sys_Config_Refer model = list[0]; model.Stat = 1; int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return(result); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(Sys_Config_Refer model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// 获取所有的通用参考主表 Sys_Config_Refer对象(即:一条记录 /// </summary> public List <Sys_Config_Refer> GetAll() { List <Sys_Config_Refer> ret = new List <Sys_Config_Refer>(); string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer where 1=1 AND ((Stat is null) or (Stat=0) ) order by R_ID desc "; SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer(); if (dr["R_ID"] != DBNull.Value) { sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]); } if (dr["R_ModuleName"] != DBNull.Value) { sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]); } if (dr["R_NameSpace"] != DBNull.Value) { sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]); } if (dr["R_Title"] != DBNull.Value) { sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]); } if (dr["R_Width"] != DBNull.Value) { sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]); } if (dr["R_Height"] != DBNull.Value) { sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]); } if (dr["Stat"] != DBNull.Value) { sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["R_TableName"] != DBNull.Value) { sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]); } if (dr["R_FilterSql"] != DBNull.Value) { sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]); } if (dr["R_SQL"] != DBNull.Value) { sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]); } if (dr["R_Url"] != DBNull.Value) { sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]); } ret.Add(sys_Config_Refer); } }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> /// 获取指定的通用参考主表 Sys_Config_Refer对象集合 /// </summary> public List <Sys_Config_Refer> GetListByWhere(string strCondition) { List <Sys_Config_Refer> ret = new List <Sys_Config_Refer>(); string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) "; if (!string.IsNullOrEmpty(strCondition)) { strCondition.Replace('\'', '"'); //防sql注入 sql += strCondition; } sql += " ORDER BY R_ID DESC "; SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer(); if (dr["R_ID"] != DBNull.Value) { sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]); } if (dr["R_ModuleName"] != DBNull.Value) { sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]); } if (dr["R_NameSpace"] != DBNull.Value) { sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]); } if (dr["R_Title"] != DBNull.Value) { sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]); } if (dr["R_Width"] != DBNull.Value) { sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]); } if (dr["R_Height"] != DBNull.Value) { sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]); } if (dr["Stat"] != DBNull.Value) { sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["R_TableName"] != DBNull.Value) { sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]); } if (dr["R_FilterSql"] != DBNull.Value) { sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]); } if (dr["R_SQL"] != DBNull.Value) { sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]); } if (dr["R_Url"] != DBNull.Value) { sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]); } ret.Add(sys_Config_Refer); } }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> /// 获取指定的通用参考主表 Sys_Config_Refer对象(即:一条记录 /// </summary> public Sys_Config_Refer GetByKey(decimal r_ID) { Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer(); string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND R_ID=@R_ID "; idb.AddParameter("@R_ID", r_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["R_ID"] != DBNull.Value) { sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]); } if (dr["R_ModuleName"] != DBNull.Value) { sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]); } if (dr["R_NameSpace"] != DBNull.Value) { sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]); } if (dr["R_Title"] != DBNull.Value) { sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]); } if (dr["R_Width"] != DBNull.Value) { sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]); } if (dr["R_Height"] != DBNull.Value) { sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]); } if (dr["Stat"] != DBNull.Value) { sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["R_TableName"] != DBNull.Value) { sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]); } if (dr["R_FilterSql"] != DBNull.Value) { sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]); } if (dr["R_SQL"] != DBNull.Value) { sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]); } if (dr["R_Url"] != DBNull.Value) { sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]); } } }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(sys_Config_Refer); }
/// <summary> /// 更新通用参考主表 Sys_Config_Refer对象(即:一条记录 /// </summary> public int Update(Sys_Config_Refer sys_Config_Refer) { StringBuilder sbParameter = new StringBuilder(); StringBuilder sb = new StringBuilder(); sb.Append(@"UPDATE Sys_Config_Refer SET "); if (sys_Config_Refer.R_ModuleName_IsChanged) { sbParameter.Append("R_ModuleName=@R_ModuleName, "); } if (sys_Config_Refer.R_NameSpace_IsChanged) { sbParameter.Append("R_NameSpace=@R_NameSpace, "); } if (sys_Config_Refer.R_Title_IsChanged) { sbParameter.Append("R_Title=@R_Title, "); } if (sys_Config_Refer.R_Width_IsChanged) { sbParameter.Append("R_Width=@R_Width, "); } if (sys_Config_Refer.R_Height_IsChanged) { sbParameter.Append("R_Height=@R_Height, "); } if (sys_Config_Refer.Stat_IsChanged) { sbParameter.Append("Stat=@Stat, "); } if (sys_Config_Refer.R_TableName_IsChanged) { sbParameter.Append("R_TableName=@R_TableName, "); } if (sys_Config_Refer.R_FilterSql_IsChanged) { sbParameter.Append("R_FilterSql=@R_FilterSql, "); } if (sys_Config_Refer.R_SQL_IsChanged) { sbParameter.Append("R_SQL=@R_SQL, "); } if (sys_Config_Refer.R_Url_IsChanged) { sbParameter.Append("R_Url=@R_Url "); } sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and R_ID=@R_ID; "); string sql = sb.ToString(); if (sys_Config_Refer.R_ModuleName_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_ModuleName)) { idb.AddParameter("@R_ModuleName", DBNull.Value); } else { idb.AddParameter("@R_ModuleName", sys_Config_Refer.R_ModuleName); } } if (sys_Config_Refer.R_NameSpace_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_NameSpace)) { idb.AddParameter("@R_NameSpace", DBNull.Value); } else { idb.AddParameter("@R_NameSpace", sys_Config_Refer.R_NameSpace); } } if (sys_Config_Refer.R_Title_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_Title)) { idb.AddParameter("@R_Title", DBNull.Value); } else { idb.AddParameter("@R_Title", sys_Config_Refer.R_Title); } } if (sys_Config_Refer.R_Width_IsChanged) { if (sys_Config_Refer.R_Width == 0) { idb.AddParameter("@R_Width", 0); } else { idb.AddParameter("@R_Width", sys_Config_Refer.R_Width); } } if (sys_Config_Refer.R_Height_IsChanged) { if (sys_Config_Refer.R_Height == 0) { idb.AddParameter("@R_Height", 0); } else { idb.AddParameter("@R_Height", sys_Config_Refer.R_Height); } } if (sys_Config_Refer.Stat_IsChanged) { if (sys_Config_Refer.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", sys_Config_Refer.Stat); } } if (sys_Config_Refer.R_TableName_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_TableName)) { idb.AddParameter("@R_TableName", DBNull.Value); } else { idb.AddParameter("@R_TableName", sys_Config_Refer.R_TableName); } } if (sys_Config_Refer.R_FilterSql_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_FilterSql)) { idb.AddParameter("@R_FilterSql", DBNull.Value); } else { idb.AddParameter("@R_FilterSql", sys_Config_Refer.R_FilterSql); } } if (sys_Config_Refer.R_SQL_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_SQL)) { idb.AddParameter("@R_SQL", DBNull.Value); } else { idb.AddParameter("@R_SQL", sys_Config_Refer.R_SQL); } } if (sys_Config_Refer.R_Url_IsChanged) { if (string.IsNullOrEmpty(sys_Config_Refer.R_Url)) { idb.AddParameter("@R_Url", DBNull.Value); } else { idb.AddParameter("@R_Url", sys_Config_Refer.R_Url); } } idb.AddParameter("@R_ID", sys_Config_Refer.R_ID); return(idb.ExeCmd(sql)); }
/// <summary> /// 添加通用参考主表 Sys_Config_Refer对象(即:一条记录) /// </summary> public int Add(Sys_Config_Refer sys_Config_Refer) { string sql = "INSERT INTO Sys_Config_Refer (R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url) VALUES (@R_ModuleName,@R_NameSpace,@R_Title,@R_Width,@R_Height,@Stat,@R_TableName,@R_FilterSql,@R_SQL,@R_Url)"; if (string.IsNullOrEmpty(sys_Config_Refer.R_ModuleName)) { idb.AddParameter("@R_ModuleName", DBNull.Value); } else { idb.AddParameter("@R_ModuleName", sys_Config_Refer.R_ModuleName); } if (string.IsNullOrEmpty(sys_Config_Refer.R_NameSpace)) { idb.AddParameter("@R_NameSpace", DBNull.Value); } else { idb.AddParameter("@R_NameSpace", sys_Config_Refer.R_NameSpace); } if (string.IsNullOrEmpty(sys_Config_Refer.R_Title)) { idb.AddParameter("@R_Title", DBNull.Value); } else { idb.AddParameter("@R_Title", sys_Config_Refer.R_Title); } if (sys_Config_Refer.R_Width == 0) { idb.AddParameter("@R_Width", 0); } else { idb.AddParameter("@R_Width", sys_Config_Refer.R_Width); } if (sys_Config_Refer.R_Height == 0) { idb.AddParameter("@R_Height", 0); } else { idb.AddParameter("@R_Height", sys_Config_Refer.R_Height); } if (sys_Config_Refer.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", sys_Config_Refer.Stat); } if (string.IsNullOrEmpty(sys_Config_Refer.R_TableName)) { idb.AddParameter("@R_TableName", DBNull.Value); } else { idb.AddParameter("@R_TableName", sys_Config_Refer.R_TableName); } if (string.IsNullOrEmpty(sys_Config_Refer.R_FilterSql)) { idb.AddParameter("@R_FilterSql", DBNull.Value); } else { idb.AddParameter("@R_FilterSql", sys_Config_Refer.R_FilterSql); } if (string.IsNullOrEmpty(sys_Config_Refer.R_SQL)) { idb.AddParameter("@R_SQL", DBNull.Value); } else { idb.AddParameter("@R_SQL", sys_Config_Refer.R_SQL); } if (string.IsNullOrEmpty(sys_Config_Refer.R_Url)) { idb.AddParameter("@R_Url", DBNull.Value); } else { idb.AddParameter("@R_Url", sys_Config_Refer.R_Url); } return(idb.ExeCmd(sql)); }
public ActionResult GetData(int page, int rows, string search, string sidx, string sord) { string Name = Request["name"] == null ? "" : Request["name"].ToString(); string filters = Request["filters"] == null ? "" : Request["filters"].ToString(); string filter = Request["filter"] == null ? "" : Request["filter"].ToString(); string ModuleName = Request["m"] == null ? "" : Request["m"].ToString(); string NameSpace = Request["n"] == null ? "" : Request["n"].ToString(); string filtersSql = string.Empty; string mapSqlFilter = string.Empty; if (!string.IsNullOrEmpty(filters)) { filtersSql = BulidJqGridSearch.BuildSearch(filters); } Bll_Sys_Config_Refer configRefer = new Bll_Sys_Config_Refer(); Bll_Sys_Config_Field_Refer configReferList = new Bll_Sys_Config_Field_Refer(); Sys_Config_Refer model = configRefer.GetListByCode(" AND R_ModuleName='" + ModuleName + "'")[0]; var referList = configReferList.GetListByCode(" AND D_ModuleName='" + ModuleName + "'").Where(o => !string.IsNullOrEmpty(o.D_DictKey)); Bll_Bse_Dict DictInstance = new Bll_Bse_Dict(); DataTable dt = new DataTable(); if (!string.IsNullOrEmpty(model.R_SQL)) { if (!string.IsNullOrEmpty(filter)) { model.R_SQL = model.R_SQL + filter; } if (!string.IsNullOrEmpty(filtersSql)) { model.R_SQL = model.R_SQL + " AND " + filtersSql; } dt = configRefer.ListBySql(model.R_SQL); } else { string _filtersql = !String.IsNullOrEmpty(model.R_FilterSql) ? model.R_FilterSql : ""; _filtersql = _filtersql + filter; //#region 特殊映射处理 //if (ModuleName=="HR_StuffModule") //{ // //读取映射配置表中公司配置 // Bll_Comm comm = new Bll_Comm(); // string mapFilter = ""; // var mapModel = comm.CommMap(ModuleName, "Company"); // if (mapModel!=null) // { // var deptList = comm.GetChildListDeptNon(comm.CommMap(ModuleName, "Company").Map_Object); // if (deptList.Count()>0) // { // foreach (var item in deptList) // { // } // for (int i = 0; i < deptList.Count;i++ ) // { // if (i==(deptList.Count-1)) // { // mapFilter += "'" + deptList[i].Dept_Code+"'"; // } // else // { // mapFilter += "'" + deptList[i].Dept_Code+ "',"; // } // } // mapFilter.TrimEnd(','); // } // mapSqlFilter = " Stuff_DepCode in(" + mapFilter + ")"; // } //} //#endregion //为空时不初始化 //if (!string.IsNullOrEmpty(filter)) //{ // dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter); //} dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter); } DataTable newdt = DataTablePage.GetPagedTable(dt, page, rows); #region 字典进行转换 //对字典进行转换 for (int i = 0; i < newdt.Rows.Count; i++) { foreach (var item in referList.ToList()) { var value = newdt.Rows[i][item.D_Index] != null ? newdt.Rows[i][item.D_Index].ToString() : ""; var DictResult = DictInstance.GetListByCode(" AND Dict_Code='" + value + "' AND Dict_Key='" + item.D_DictKey + "' "); if (DictResult.Count > 0) { newdt.Rows[i][item.D_Index] = DictResult.FirstOrDefault().Dict_Name; } } } #endregion var json = DataTablePage.JsonForJqgrid(newdt, page, rows, dt.Rows.Count); return(JavaScript(json)); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Sys_Config_Refer GetModel(int id) { Sys_Config_Refer model = instance.GetByKey(id); return(model); }
public static string ReferControlEx( this HtmlHelper helper, string ModuleName, string NameSpace, bool Multiselect) { string str = string.Empty; ADOSys_Config_Refer ReferInstance = new ADOSys_Config_Refer(); ADOSys_Config_Field_Refer DListInstance = new ADOSys_Config_Field_Refer(); if (string.IsNullOrEmpty(ModuleName) || string.IsNullOrEmpty(NameSpace)) { return string.Empty; } Sys_Config_Refer MRefer = ReferInstance.GetListByWhere(" AND R_ModuleName='" + ModuleName + "'")[0]; List<Sys_Config_Field_Refer> D_List = DListInstance.GetListByWhere(" AND D_ModuleName='" + ModuleName + "'"); #region JqGrid Html 列表显示部分 string html = @" <div class='Comm_Ref' id='{ModuleName}{M_NameSpace}' style='display:none'> {ToolBar} <div id='{M_NameSpace}search'> </div> <table id='{M_NameSpace}grid'' class='scroll' cellpadding='0' cellspacing='0'> </table> <div id='{M_NameSpace}pager' class='scroll' style='text-align: center;'> </div> <div style='float:right;padding-top:20px'> <span> <input id='btnok_{M_NameSpace}' type='button' value='确定'/> <input type='button' value='关闭' onclick='{M_NameSpace}Close()'/> </span> </div> </div>"; #endregion #region JqGrid Js部分 string js_header = @"<script type='text/javascript'>"; string js_footer = @"</script>"; string jsBody = @" var {M_NameSpace}_{ModuleName}_GridControl = { setupGrid: function(grid, pager, search, dataurl) { grid.jqGrid({ url: dataurl, mtype: 'post', rowNum: 10, rowList: [10,20,50], pager: pager, sortorder: 'asc', viewrecords: true, multiselect: {MultiSelect}, //多选时出现checkbox width: '{M_Width}', height: '{M_Height}', autowidth: false, rownumbers: true, gridview: true, footerrow: false, colNames: [{M_ColNames_list}], colModel: [{M_ColModel_List}], gridComplete: function() { var ids = grid.jqGrid('getDataIDs'); for (var i = 0; i < ids.length; i++) { var cl = ids[i]; var ret = grid.jqGrid('getRowData', cl); var operation=''; {M_GridComplete} grid.jqGrid('setRowData', ids[i], { Edit: operation }); } }, userDataOnFooter: true }) }, Init: function(dataurl, targetPreFix) { var gridobj = targetPreFix + 'grid'; var pagerobj = targetPreFix + 'pager'; var searchobj = targetPreFix + 'search'; {M_NameSpace}_{ModuleName}_GridControl.setupGrid($('#' + gridobj), $('#' + pagerobj), $('#' + searchobj), dataurl); $('#' + gridobj).navGrid('#'+pagerobj, { refresh: false, edit: false, add: false, del: false, search:false,multipleSearch:false }); } } "; #endregion string btnMJs = @" $('#btnok_{M_NameSpace}').click(function(){ var grid = $('#{M_NameSpace}grid'); var curids = grid.getGridParam('selarrrow'); //获取选择行的id if(curids!=''){ var ids=new Array(); var selectRows=new Array(); //selectRows.length=0; ids=curids.toString().split(','); for(var i=0;i<ids.length;i++){ var data = grid.getRowData(ids[i]); //获取行号为curid的数据 if(data!=null){ selectRows.push(data); } } {M_NameSpace}callback(selectRows); $('#{ModuleName}{M_NameSpace}').dialog('close'); } }); "; string btnSJs = @" $('#btnok_{M_NameSpace}').click(function(){ var grid = $('#{M_NameSpace}grid'); var curid = grid.getGridParam('selrow'); //获取选择行的id var data = grid.getRowData(curid); //获取行号为curid的数据 if(curid==null) return; {M_NameSpace}callback(data); $('#{ModuleName}{M_NameSpace}').dialog('close'); }); "; //0131 YSW #region JqGrid调用部分 string callJs = @" <script type='text/javascript'> var {M_NameSpace}callback; $(document).ready(function() { {M_NameSpace}_{ModuleName}_GridControl.Init('{M_URL}','{M_NameSpace}'); //初始化层 $('#{ModuleName}{M_NameSpace}').dialog({ autoOpen: false, width: {Width}, height: {Height},title:'{M_Title}' }); //$('#{M_NameSpace}grid').jqGrid('filterGrid','#{M_NameSpace}grid', { multipleSearch:true } ); {BtnJs} }); function {ModuleName}{M_NameSpace}OpenRefer(callback){ $('#{ModuleName}{M_NameSpace}').dialog('open'); {M_NameSpace}callback=callback; } function {ModuleName}{M_NameSpace}OpenReferWithFilter(_filter,callback){ var _url={filterUrl}; var refGrid=$('#{M_NameSpace}grid'); refGrid.setGridParam({ url: _url }); refGrid.trigger('reloadGrid'); $('#{ModuleName}{M_NameSpace}').dialog('open'); {M_NameSpace}callback=callback; } function {M_NameSpace}Close(){ $('#{ModuleName}{M_NameSpace}').dialog('close'); } function {M_NameSpace}ToolBarSearch(){ $('#{M_NameSpace}grid').jqGrid('searchGrid', { multipleSearch:true } ); } </script> "; #endregion #region 生成列头 string strColNames = string.Empty; D_List = D_List.OrderBy(o => o.D_Order).ToList(); for (int i = 0; i < D_List.Count; i++) { if (i != (D_List.Count - 1)) { strColNames += "'" + D_List[i].D_Name.Trim() + "'" + ","; } else { strColNames += "'" + D_List[i].D_Name.Trim() + "'"; } } #endregion #region 生成列详细配置 StringBuilder header = new StringBuilder(); string header_template = @"{ name: '{D_Index}',width:100,index: '{D_Index}', align: 'center', {D_Hidden} searchoptions:{ sopt: ['eq', 'ne', 'cn'] } }"; string header_template_fix = ","; for (var m = 0; m < D_List.Count; m++) { string tmpFix = m != (D_List.Count - 1) ? header_template_fix : ""; header.AppendLine(header_template .Replace("{D_Name}", D_List[m].D_Name.Trim()) .Replace("{D_Index}", D_List[m].D_Index.Trim()) .Replace("{D_Hidden}", !string.IsNullOrEmpty(D_List[m].D_Hidden) ? "hidden:" + D_List[m].D_Hidden + "," : "") + tmpFix); } #endregion str += html; str += js_header + jsBody + js_footer; str += callJs; string url = string.Empty; string filter = string.Empty; if (!string.IsNullOrEmpty(MRefer.R_Url)) { url = MRefer.R_Url; filter = "'" + MRefer.R_Url + "?filter='+_filter"; } else { url = string.Format("/Sys_Config_Refer/GetData/?name={0}&m={1}&n={2}", MRefer.R_TableName, MRefer.R_ModuleName, MRefer.R_NameSpace); filter = "'/Sys_Config_Refer/GetData/?name=" + MRefer.R_TableName + "&m=" + MRefer.R_ModuleName + "&n=" + MRefer.R_NameSpace + "&filter='+_filter"; } string tool = string.Empty; if (string.IsNullOrEmpty(MRefer.R_Tool)) { tool = ""; } else { tool = MRefer.R_Tool; } str = str .Replace("{BtnJs}", Multiselect ? btnMJs : btnSJs) .Replace("{ModuleName}", ModuleName) .Replace("{M_NameSpace}", NameSpace) .Replace("{Width}", MRefer.R_Width.ToString()) .Replace("{Height}", MRefer.R_Height.ToString()) .Replace("{M_Width}", (MRefer.R_Width * 0.93).ToString()) .Replace("{M_Height}", (MRefer.R_Height * 0.4).ToString()) .Replace("{M_Title}", MRefer.R_Title) .Replace("{M_ColNames_list}", strColNames) .Replace("{M_ColModel_List}", header.ToString()) .Replace("{M_GridComplete}", "") .Replace("{M_URL}", url) .Replace("{filterUrl}", filter) .Replace("{Width}", "") .Replace("{Height}", "") .Replace("{Table}", MRefer.R_TableName) .Replace("{MultiSelect}", Multiselect ? "true" : "false") //.Replace("{ToolBar}", helper.Common_ToolBarForListPage(ModuleName, "", //"'add':'hidden','edit':'hidden','del':'hidden','import':'hidden','export':'hidden',view:'hidden'")); .Replace("{ToolBar}", helper.GenToolbarNoPermissionHelper(ModuleName,NameSpace, tool)); return str; }