/// <summary> /// 根据资源ID,获取资源配置信息 /// </summary> /// <param name="ResID"></param> /// <returns></returns> public static SysSettings GetSysSettingsByResID(string ResID) { SysSettings Sys = null; WebServices.Services Resource = new WebServices.Services(); // string sql = "select top(1) * from SysSettings where [Value]='" + ResID + "' "; // DataSet ds = Resource.SelectData(sql); UserInfo user = CommonGetInfo.GetUser(); DataSet ds = Resource.GetDataListByResID("437496952875", "", CommonMethod.FilterSql(" and 值='" + ResID + "'"), user.ID); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { Sys = new SysSettings(); Sys.ShowTitle = ds.Tables[0].Rows[0]["显示Title"].ToString(); Sys.ENTableName = ds.Tables[0].Rows[0]["参数关键字"].ToString(); Sys.KeyWordValue = ds.Tables[0].Rows[0]["参数关键字"].ToString(); Sys.ResID = ds.Tables[0].Rows[0]["值"].ToString(); Sys.AlignColStr = ds.Tables[0].Rows[0]["左对齐显示字段"].ToString(); Sys.AddUrl = ds.Tables[0].Rows[0]["添加地址"].ToString(); Sys.EidtUrl = ds.Tables[0].Rows[0]["编辑地址"].ToString(); Sys.AccessoryCol = ds.Tables[0].Rows[0]["附件字段"].ToString(); Sys.FJGLJD = ds.Tables[0].Rows[0]["附件主子表关联字段"].ToString(); Sys.AccessoryResID = ds.Tables[0].Rows[0]["附件ResID"].ToString(); Sys.SettingsNum = ds.Tables[0].Rows[0]["列表配置号"].ToString(); Sys.LBLX = ds.Tables[0].Rows[0]["列表类型"].ToString(); Sys.DialogWidth = ds.Tables[0].Rows[0]["弹出层宽度"].ToString() == "" ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["弹出层宽度"]); Sys.DialogHeight = ds.Tables[0].Rows[0]["弹出层高度"].ToString() == "" ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["弹出层高度"]); Sys.DefaultOrder = ds.Tables[0].Rows[0]["默认排序"].ToString(); Sys.SortBy = ds.Tables[0].Rows[0]["排序类型"].ToString(); Sys.TableName = ds.Tables[0].Rows[0]["数据表名称"].ToString(); Sys.FilterCondtion = ds.Tables[0].Rows[0]["数据筛选条件"].ToString(); DataRow dr = ds.Tables[0].Rows[0]; Sys.IsCheckBox = NetReusables.DbField.GetBool(ref dr, "是否显示复选框"); Sys.IsAdd = NetReusables.DbField.GetBool(ref dr, "启用添加"); Sys.IsUpdate = NetReusables.DbField.GetBool(ref dr, "启用修改"); Sys.IsDelete = NetReusables.DbField.GetBool(ref dr, "启用删除"); Sys.IsExp = NetReusables.DbField.GetBool(ref dr, "启用导出"); Sys.IsStartWidth = NetReusables.DbField.GetBool(ref dr, "启用字段宽度设置"); Sys.IsOrder = NetReusables.DbField.GetBool(ref dr, "是否支持排序"); Sys.IsRowRight = NetReusables.DbField.GetBool(ref dr, "是否启用行过滤"); Sys.URLTarget = ds.Tables[0].Rows[0]["页面打开方式"].ToString(); Sys.FootStr = ds.Tables[0].Rows[0]["统计字段"].ToString(); return(Sys); } else { return(Sys); } } else { return(Sys); } }
/// <summary> /// 获取资源ID /// </summary> /// <param name="KeyWord"></param> /// <returns></returns> public static string GetResIDByENKekWord(string KeyWord) { WebServices.Services Resource = new WebServices.Services(); //string sql = "select [Value] from SysSettings where ENKeyWord='" + KeyWord + "'"; //DataSet ds = Resource.SelectData(sql); UserInfo user = CommonGetInfo.GetUser(); DataSet ds = Resource.GetDataListByResID("437496952875", "", CommonMethod.FilterSql(" and 参数关键字='" + KeyWord + "'"), user.ID); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0].Rows[0]["值"].ToString()); } else { return(""); } } else { return(""); } }
protected void Page_Load(object sender, EventArgs e) { UserID = this.CurrentUser.ID; UserName = this.CurrentUser.Name; string Condition = ""; string json = ""; string typeValue = Request["typeValue"]; int PageSize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]); int PageNumber = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]); if (typeValue == "GetDataByType") { string ByType = Request["ByType"] == null ? "" : Request["ByType"].ToString(); if (ByType == "0") { typeValue = "CommonGetDataByProc"; } else { typeValue = "GetDataByUserDefinedSql"; } } switch (typeValue) { case "GetDataByUserDefinedSql": { string ResID = ""; string SortField = ""; string SortBy = ""; string QueryKeystr = ""; string ROW_NUMBER_ORDER = ""; bool NoPaging = false; List <ReportFoot> vReportFoots = null; if (!string.IsNullOrEmpty(Request["ReportFoot"])) { string s = Request["ReportFoot"].ToString(); vReportFoots = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ReportFoot> >(s); } if (!string.IsNullOrEmpty(Request["Condition"])) { Condition = Request["Condition"].ToString(); } QueryKeystr = Request["QueryKeystr"] == null ? "" : Request["QueryKeystr"].ToString(); if (!string.IsNullOrWhiteSpace(QueryKeystr)) { if (QueryKeystr.Substring(0, 4).ToLower().Trim() == "and") { Condition = Condition + QueryKeystr; } else { Condition = Condition + " and " + QueryKeystr; } } if (!string.IsNullOrEmpty(Request["page"])) { PageNumber = Convert.ToInt32(Request["page"]); } if (Request["sort"] != null) { SortField = Request["sort"].ToString(); } if (Request["order"] != null) { SortBy = Request["order"].ToString(); } if (Request["ROW_NUMBER_ORDER"] != null) { ROW_NUMBER_ORDER = Request["ROW_NUMBER_ORDER"].ToString(); } if (Request["NoPaging"] != null) { NoPaging = true; } if (Request["UserDefinedSql"] != null) { ResID = Request["UserDefinedSql"].ToString().Trim(); } json = CommonGetInfo.GetDataByUserDefinedSql(ResID, PageNumber, PageSize, SortField, SortBy, UserID, Condition, ROW_NUMBER_ORDER, NoPaging, vReportFoots, false); break; } case "GetALLCommonSearchField": { string argResourcesId = Request["argResourcesId"] == null ? "" : Request["argResourcesId"].ToString(); string argSearchType = Request["argSearchType"] == null ? "" : Request["argSearchType"].ToString(); string argReportKey = Request["argReportKey"] == null ? "" : Request["argReportKey"].ToString(); string argIsDynamicallyCreatTableHead = Request["argIsDynamicallyCreatTableHead"] == null ? "" : Request["argIsDynamicallyCreatTableHead"].ToString(); json = CommonGetInfo.GetALLCommonSearchField(argResourcesId, argReportKey, argSearchType, argIsDynamicallyCreatTableHead); } break; case "GetDictionaryReturnRelatedColumn": Services oServices = new Services(); string ResourceID = Request["ResourceID"]; string ResourceColumn = Request["ResourceColumn"]; DataTable dt = oServices.GetDictionaryReturnRelatedColumn(ResourceID, ResourceColumn).Tables[0]; json = Newtonsoft.Json.JsonConvert.SerializeObject(dt); break; case "GetDictionaryReturnColumn": oServices = new Services(); ResourceID = Request["ResourceID"]; ResourceColumn = Request["ResourceColumn"]; bool IsMultiselect = Convert.ToBoolean(Convert.ToInt32(Request["IsMultiselect"])); dt = oServices.GetDictionaryReturnColumn(ResourceID, ResourceColumn); string gridField = ""; string searchField = ""; // string DicResourceID = ""; string str = ""; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; if (DbField.GetInt(ref dr, "DataType") == 9) { string strEnable = "s='<input type=\"checkbox\" name=\"ch_IsEnable\" value=\"_blank\" id=\"ch_IsEnable\" disabled=\"true\" '+(row." + DbField.GetStr(ref dr, "CD_DISPNAME") + "==\"1\"?\"Checked\":\"\")+' />';"; gridField += ",{field: '" + DbField.GetStr(ref dr, "CD_DISPNAME") + "',title:'" + DbField.GetStr(ref dr, "CD_DISPNAME") + "',width:100, sortable:true ,align:'center',formatter: function (value, row, index) {" + strEnable + " return s;}}"; } else { gridField += ",{field: '" + DbField.GetStr(ref dr, "CD_DISPNAME") + "',title:'" + DbField.GetStr(ref dr, "CD_DISPNAME") + "',width:100, sortable:true ,align:'center'}"; } searchField += ",{field:'" + DbField.GetStr(ref dr, "CD_DISPNAME") + "'}"; } dt = oServices.GetDictionaryReturnRelatedColumn(ResourceID, ResourceColumn).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; if (!IsMultiselect) { str += "," + DbField.GetStr(ref dr, "ResColCNName") + ":\"'+rowData." + DbField.GetStr(ref dr, "DicColCNName") + "+'\""; } else { str += "," + DbField.GetStr(ref dr, "ResColCNName") + ":" + DbField.GetStr(ref dr, "DicColCNName") + ""; } } if (!IsMultiselect) { gridField = "{title:'选择',field:'选择',width:50,align:'center' ,formatter:function(value,rowData,rowIndex){return '<a href=\"javascript:\" onclick=SelectOneRow({" + str.Substring(1) + "})>选择</a>';}}" + gridField; } else { gridField = "{field: 'ID',title:'',checkbox:true,width:30, sortable:false ,align:'center'}" + gridField; } if (gridField.Trim() != "") { gridField = "[[" + gridField + "]]"; } if (searchField.Trim() != "") { searchField = "[#][" + searchField.Substring(1) + "]"; } json = gridField + searchField; break; case "GetDictionaryList": oServices = new Services(); ResourceID = Request["ResourceID"]; ResourceColumn = Server.UrlDecode(Request["ResourceColumn"]); if (Request["Condition"] != null) { Condition = Server.UrlDecode(Request["Condition"]); } string DicResourceID = oServices.GetDictionaryReturnResourceID(ResourceID, ResourceColumn); PageParameter p = new PageParameter(); p.PageIndex = PageNumber - 1; p.PageSize = PageSize; p.SortField = "ID"; p.SortBy = ""; DataSet ds = oServices.GetPageOfDataList(Convert.ToInt64(DicResourceID), CommonMethod.FilterSql(Condition), p, "test"); string RowCount = oServices.GetDataListRecordCount(Convert.ToInt64(DicResourceID), UserID, CommonMethod.FilterSql(Condition)).ToString(); json = "{\"total\":" + RowCount + ",\"rows\":" + Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0]) + "}"; break; case "GetDataOfReportOfDynamicHeadReportColumnStrBySqlStr": { string ByType = Request["ByType"] == null ? "" : Request["ByType"].ToString(); string filterRulesByHeadStr = ""; string frozenColumnsJson = ""; string DynamicHeadReportStr = Request["DynamicHeadReportStr"]; if (ByType == "0") { string ProcName = Request["ProcName"] == null ? "" : Request["ProcName"].ToString(); string ProcOutPutCount = Request["ProcOutPutCount"] == null ? "" : Request["ProcOutPutCount"].ToString(); string ProcInPutStr = Request["ProcInPutStr"] == null ? "" : Request["ProcInPutStr"].ToString(); DataTable vDT = new DataTable(); json = CommonGetDataByProc(CommonGetInfo.GetUser(), ProcOutPutCount, ProcInPutStr, ProcName, "", PageSize.ToString(), PageNumber.ToString(), "", "", "", "", out vDT, false, null, true); } else { string UserDefinedSql = Request["UserDefinedSql"] == null ? "" : Request["UserDefinedSql"].ToString(); string SortField = Request["sort"] == null ? "" : Request["sort"].ToString(); string SortBy = Request["order"] == null ? "" : Request["order"].ToString(); Condition = Request["Condition"] == null ? "" : Request["Condition"].ToString(); string ROW_NUMBER_ORDER = Request["ROW_NUMBER_ORDER"].ToString(); bool NoPaging = Request["NoPaging"] == null ? false : true; bool IsExport = Request["IsExport"] == null ? false : true;; List <ReportFoot> vReportFoots = null; if (!string.IsNullOrEmpty(Request["ReportFoot"])) { string s = Request["ReportFoot"].ToString(); vReportFoots = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ReportFoot> >(s); } json = CommonGetInfo.GetDataByUserDefinedSql(UserDefinedSql, PageNumber, PageSize, SortField, SortBy, UserID, "", ROW_NUMBER_ORDER, NoPaging, vReportFoots, IsExport, Condition.Trim()); } json = CommonGetInfo.GetColumnsJson(null, out filterRulesByHeadStr, out frozenColumnsJson, json, DynamicHeadReportStr) + "#" + filterRulesByHeadStr + "#" + frozenColumnsJson; } break; case "CommonGetUserDefinedToolBars": { string keyWordValue = Request["keyWordValue"] == null ? "" : Request["keyWordValue"].ToString(); string argToolBarType = Request["argToolBarType"] == null ? "" : Request["argToolBarType"].ToString(); bool argIsUseNewEasyui = Request["argIsUseNewEasyui"] == null ? true : (Request["argIsUseNewEasyui"].ToString() == "1" ? true : false); string DelNameStr = ""; json = "^" + CommonGetInfo.CommonGetUserDefinedToolBars(keyWordValue, out DelNameStr, argToolBarType, argIsUseNewEasyui) + "^"; json += "***" + DelNameStr; } break; case "CommonGetDataByProc": { string ProcName = Request["ProcName"] == null ? "" : Request["ProcName"].ToString(); string ProcOutPutCount = Request["ProcOutPutCount"] == null ? "" : Request["ProcOutPutCount"].ToString(); string ProcInPutStr = Request["ProcInPutStr"] == null ? "" : Request["ProcInPutStr"].ToString(); string SortField = Request["sort"] == null ? "" : Request["sort"].ToString(); string SortBy = Request["order"] == null ? "" : Request["order"].ToString(); bool IsExport = Request["IsExport"] == null ? false : true; DataTable vDT = new DataTable(); json = CommonGetDataByProc(CommonGetInfo.GetUser(), ProcOutPutCount, ProcInPutStr, ProcName, "", PageSize.ToString(), PageNumber.ToString(), "1", "", SortField, SortBy, out vDT, false, null, IsExport); break; } default: break; } Response.Write(json); }