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));
}
