public static string createData(string strParentId, string strDictType, string strDictCode, string strDictName, string strRemark) { string strDictId = GetSerialNumber("dict_id"); TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.ID = strDictId; TSysDictVo.DICT_TYPE = HttpContext.Current.Server.UrlDecode(strDictType); TSysDictVo.DICT_TEXT = HttpContext.Current.Server.UrlDecode(strDictName); TSysDictVo.DICT_CODE = HttpContext.Current.Server.UrlDecode(strDictCode); TSysDictVo.DICT_GROUP = "dict"; TSysDictVo.PARENT_CODE = strParentId; TSysDictVo.AUTO_LOAD = "1"; TSysDictVo.REMARK = strRemark; bool isSuccess = new TSysDictLogic().Create(TSysDictVo); if (isSuccess) { new PageBase().WriteLog("新增字典项数据", "", new UserLogInfo().UserInfo.USER_NAME + "新增字典项数据" + TSysDictVo.ID); return(strDictId); } else { return("0"); } }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysDict">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysDictVo tSysDict, int iIndex, int iCount) { string strSQL = " select * from T_SYS_DICT {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tSysDict)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress <TSysDictVo>(tSysDict, strSQL, iIndex, iCount))); }
/// <summary> /// 获取下拉字典项 /// </summary> /// <returns></returns> private string getDict(string strDictType) { //return getDictJsonString(strDictType); TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.DICT_TYPE = strDictType; if (Request.Params["type"] != null) { if (Request.Params["type"].ToString() == "other") { TSysDictVo.DICT_CODE = "03,04,05,07"; } else if (Request.Params["type"].ToString() == "drugs") { TSysDictVo.DICT_CODE = "01,02"; } else if (Request.Params["type"].ToString() == "office") { TSysDictVo.DICT_CODE = "06"; } } DataTable dt = new i3.BusinessLogic.Sys.Resource.TSysDictLogic().SelectByTable(TSysDictVo); return(DataTableToJson(dt)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysDict_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysDict_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysDictVo tSysDict_UpdateSet, TSysDictVo tSysDict_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tSysDict_UpdateSet, TSysDictVo.T_SYS_DICT_TABLE); strSQL += this.BuildWhereStatement(tSysDict_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysDict">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysDictVo tSysDict) { string strSQL = SqlHelper.BuildUpdateExpress(tSysDict, TSysDictVo.T_SYS_DICT_TABLE); strSQL += string.Format(" where ID='{0}' ", tSysDict.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public void initFirstList() { string strDictId = ""; TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.DICT_CODE = "watershed"; DataTable dt = new TSysDictLogic().SelectByTable(TSysDictVo); if (dt.Rows.Count == 0) { return; } strDictId = dt.Rows[0]["ID"].ToString(); TSysDictVo TSysDictVoTemp = new TSysDictVo(); TSysDictVoTemp.PARENT_CODE = strDictId; DataTable objTable = new TSysDictLogic().SelectByTable(TSysDictVoTemp); this.oneList.DataSource = objTable; this.oneList.DataTextField = "DICT_TEXT"; this.oneList.DataValueField = "ID"; this.oneList.DataBind(); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysDictVo tSysDict) { string strSQL = "delete from T_SYS_DICT "; strSQL += this.BuildWhereStatement(tSysDict); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获得标准类型 /// </summary> /// <returns></returns> public string getStandardInfo() { TSysDictVo objtd = new TSysDictVo(); objtd.DICT_TYPE = "STANDARD_TYPE"; DataTable dt = new TSysDictLogic().SelectByTable(objtd); return(DataTableToJson(dt)); }
public static string GetStandard(string strValue) { TSysDictVo objtd = new TSysDictVo(); objtd.DICT_TYPE = "STANDARD_TYPE"; objtd.DICT_CODE = strValue; objtd = new TSysDictLogic().Details(objtd); return(objtd.DICT_TEXT); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.PARENT_CODE = Request["PARENT_CODE"].ToString(); DataTable dt = new TSysDictLogic().SelectByTable(TSysDictVo); return(DataTableToJson(dt)); }
public static List <object> GetDeptItems() { List <object> listResult = new List <object>(); DataTable dt = new DataTable(); TSysDictVo objVo = new TSysDictVo(); objVo.DICT_TYPE = "dept"; dt = new TSysDictLogic().SelectByTable(objVo); listResult = LigerGridSelectDataToJson(dt, dt.Rows.Count); return(listResult); }
public static List <object> GetOpreator() { List <object> reslut = new List <object>(); DataTable dtSt = new DataTable(); TSysDictVo objtd = new TSysDictVo(); objtd.DICT_TYPE = "logic_operator"; dtSt = new TSysDictLogic().SelectByTable(objtd); reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count); //reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd); return(reslut); }
//获取字典项 private string GetDict(string strTYPE) { TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.DICT_TYPE = "PART_TYPE"; DataTable dt = new i3.BusinessLogic.Sys.Resource.TSysDictLogic().SelectByTable(TSysDictVo); DataRow[] rows = dt.Select("DICT_TEXT='" + strTYPE + "'"); string type = rows[0]["DICT_CODE"].ToString(); return(type); }
public static List <object> GetMonitorValue() { List <object> reslut = new List <object>(); DataTable dtSt = new DataTable(); TSysDictVo objtd = new TSysDictVo(); objtd.DICT_TYPE = "MONITOR_VALUE_TYPE"; dtSt = new TSysDictLogic().SelectByTable(objtd); reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count); //reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd); return(reslut); }
public static string GetDict(string strType, string strCode) { if (!string.IsNullOrEmpty(strCode)) { TSysDictVo objtd = new TSysDictVo(); objtd.DICT_TYPE = strType; objtd.DICT_CODE = strCode; objtd = new TSysDictLogic().Details(objtd); return(objtd.DICT_TEXT); } return(""); }
/// <summary> /// 获取字典项数据 /// </summary> /// <returns></returns> protected string getDictInfo() { TSysDictVo TSysDictVo = new TSysDictVo(); //如果不是系统超级管理员登陆,则显示部分字典项 if (new PageBase().LogInfo.UserInfo.ID != "000000001") { TSysDictVo.IS_HIDE = "0"; } DataTable dt = new TSysDictLogic().SelectByTable(TSysDictVo); return(DataTableToJson(dt)); }
/// <summary> /// 获取监测类别 /// </summary> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public void GetMonitorsDutys( ) { DataTable dtSt = new DataTable(); DataTable dtDict = new DataTable(); TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo(); objtd.IS_DEL = "0"; dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd); TSysDictVo objDit = new TSysDictVo(); objDit.DICT_TYPE = "duty_other"; dtDict = new TSysDictLogic().SelectByTable(objDit); if (dtSt.Rows.Count > 0) { int Sum = 0; foreach (DataRow drr in dtSt.Rows) { Sum++; nodes = "{ Id:'" + drr["ID"].ToString() + "',pId:'0',Code:'" + drr["ID"] + "',Name:'" + drr["MONITOR_TYPE_NAME"] + "'"; if (Sum == 1) { nodes += " ,open:true},\r\n"; } else { nodes += " },\r\n"; } for (int i = 0; i < dtDict.Rows.Count; i++) { nodes += "{ Id:'" + dtDict.Rows[i]["ID"] + "',pId:'" + drr["ID"] + "',Code:'" + dtDict.Rows[i]["DICT_CODE"].ToString() + "',Name:'" + dtDict.Rows[i]["DICT_TEXT"].ToString() + "'"; if (i == dtDict.Rows.Count - 1) { nodes += "}\r\n"; } else { nodes += "},\r\n"; } } treenodes.Add(nodes); } } string rootNode = "{ Id:'0',pId:'',Code:'0',Name:'监测类别岗位职责集合',open:true},"; varNodes = "[" + rootNode + "" + String.Join(",\r\n", treenodes.ToArray()) + "]"; }
/// <summary> /// 获取部门信息 /// </summary> /// <returns></returns> protected string getDeptInfo() { int intTotalCount = 0; string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TSysDictVo objDict = new TSysDictVo(); objDict.DICT_TYPE = "dept"; intTotalCount = new TSysDictLogic().GetSelectResultCount(objDict); return(CreateToJson(new TSysDictLogic().SelectByTable(objDict, 0, 0), intTotalCount)); }
/// <summary> /// 获取对应字典项类型的字典项text和code /// </summary> /// <param name="strDictType">字典项类型</param> /// <returns>字典项字符串“text,code|text,code|text,code”</returns> private string Get_Post_Dict(string strDictType) { string strResult = ""; TSysDictVo objDictVo = new TSysDictVo(); objDictVo.DICT_TYPE = strDictType; objDictVo.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD; objDictVo.SORT_TYPE = ConstValues.SortType.ASC; DataTable dt = new TSysDictLogic().SelectByTable(objDictVo, 0, 0); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; strResult += (strResult.Length > 0 ? "|" : "") + dr[TSysDictVo.DICT_CODE_FIELD].ToString() + "," + dr[TSysDictVo.DICT_TEXT_FIELD].ToString(); } return(strResult); }
/// <summary> /// 根据监测类别获取天气项目 /// </summary> /// <returns>Json</returns> protected string GetWeatherInfo() { string strDictType = ""; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value); if (objSubtask.MONITOR_ID == "000000004") { strDictType = "noise_weather"; } else { strDictType = "gerenal_weather"; } TSysDictVo objDict = new TSysDictVo(); objDict.DICT_TYPE = strDictType; objDict.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD; DataTable dt = new TSysDictLogic().SelectByTable(objDict, 0, 0); return(DataTableToJson(dt)); }
/// <summary> /// 根据监测类别获取天气项目 /// </summary> /// <returns>Json</returns> protected string GetWeatherInfo() { string strDictType = ""; if (this.MONITOR_ID.Value.Trim() == "000000004") { strDictType = "noise_weather"; } else { strDictType = "gerenal_weather"; } TSysDictVo objDict = new TSysDictVo(); objDict.DICT_TYPE = strDictType; objDict.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD; DataTable dt = new TSysDictLogic().SelectByTable(objDict, 0, 0); return(DataTableToJson(dt)); }
public static string editData(string id, string strDictType, string strDictCode, string strDictName, string strRemark) { TSysDictVo TSysDictVo = new TSysDictVo(); TSysDictVo.ID = id; TSysDictVo.DICT_TYPE = HttpContext.Current.Server.UrlDecode(strDictType); TSysDictVo.DICT_TEXT = HttpContext.Current.Server.UrlDecode(strDictName); TSysDictVo.DICT_CODE = HttpContext.Current.Server.UrlDecode(strDictCode); TSysDictVo.REMARK = strRemark; bool isSuccess = new TSysDictLogic().Edit(TSysDictVo); if (isSuccess) { new PageBase().WriteLog("编辑字典项数据", "", new UserLogInfo().UserInfo.USER_NAME + "编辑字典项数据" + TSysDictVo.ID); return("1"); } else { return("0"); } }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TEnvPRiverVo TEnvPRiver = new TEnvPRiverVo(); TEnvPRiver.ID = Request["id"].ToString(); TEnvPRiver.IS_DEL = "0"; TEnvPRiverVo TEnvPRiverVoTemp = new TEnvPRiverLogic().Details(TEnvPRiver); //条件项ID string strConditionId = TEnvPRiverVoTemp.CONDITION_ID; //根据条件项获取评价标准名称 //string strStanderId = new i3.BusinessLogic.Channels.Base.Evaluation.TBaseEvaluationConInfoLogic().Details(strConditionId).STANDARD_ID; //根据评价标准ID获取评价标准名称 //string strStanderName = new i3.BusinessLogic.Channels.Base.Evaluation.TBaseEvaluationInfoLogic().Details(strStanderId).STANDARD_NAME; string strStanderName = new i3.BusinessLogic.Channels.Base.Evaluation.TBaseEvaluationInfoLogic().Details(strConditionId).STANDARD_NAME; TEnvPRiverVoTemp.REMARK1 = strStanderName; //获取流域名称 string strValley = new i3.BusinessLogic.Sys.Resource.TSysDictLogic().Details(TEnvPRiverVoTemp.VALLEY_ID).DICT_TEXT; TEnvPRiverVoTemp.REMARK2 = strValley; //获取河流名称 string strRiver = new i3.BusinessLogic.Sys.Resource.TSysDictLogic().Details(TEnvPRiverVoTemp.RIVER_ID).DICT_TEXT; TEnvPRiverVoTemp.REMARK3 = strRiver; //类型 if (!string.IsNullOrEmpty(TEnvPRiverVoTemp.REMARK4)) { TSysDictVo vo = new TSysDictVo(); vo.DICT_TEXT = TEnvPRiverVoTemp.REMARK4; vo.DICT_TYPE = "ENV_RIVER"; TSysDictVo vos = new i3.BusinessLogic.Sys.Resource.TSysDictLogic().Details(vo); TEnvPRiverVoTemp.REMARK4 = vos.DICT_TEXT; } return(ToJson(TEnvPRiverVoTemp)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysDict">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysDictVo> SelectByObject(TSysDictVo tSysDict, int iIndex, int iCount) { return(access.SelectByObject(tSysDict, iIndex, iCount)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysDict">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysDictVo tSysDict, int iIndex, int iCount) { return(access.SelectByTable(tSysDict, iIndex, iCount)); }
public TSysDictLogic(TSysDictVo _tSysDict) { tSysDict = _tSysDict; access = new TSysDictAccess(); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysDictVo tSysDict) { return(access.Delete(tSysDict)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysDict">对象条件</param> /// <returns>对象</returns> public TSysDictVo Details(TSysDictVo tSysDict) { return(access.Details(tSysDict)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysDict"></param> /// <returns></returns> public DataTable SelectByTable(TSysDictVo tSysDict) { return(access.SelectByTable(tSysDict)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysDict">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysDictVo tSysDict) { return(access.GetSelectResultCount(tSysDict)); }