/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYS_DICTModel m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE T_SYS_DICT ");
sb.AppendFormat(" SET ");
//sb.AppendFormat("DICTID={0}", ClsSql.EncodeSql(m.DICTID));
//sb.AppendFormat("DICTFLAG='{0}'",ClsSql.EncodeSql(m.DICTFLAG));
sb.AppendFormat(" DICTNAME='{0}'", ClsSql.EncodeSql(m.DICTNAME));
sb.AppendFormat(",DICTVALUE='{0}'", ClsSql.EncodeSql(m.DICTVALUE));
sb.AppendFormat(",STANDBY1='{0}'", ClsSql.EncodeSql(m.STANDBY1));
sb.AppendFormat(",STANDBY2='{0}'", ClsSql.EncodeSql(m.STANDBY2));
sb.AppendFormat(",STANDBY3='{0}'", ClsSql.EncodeSql(m.STANDBY3));
sb.AppendFormat(",STANDBY4='{0}'", ClsSql.EncodeSql(m.STANDBY4));
sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY));
//sb.AppendFormat("ISMAN={0}", ClsSql.EncodeSql(m.ISMAN));
sb.AppendFormat(" where DICTID='{0}'", ClsSql.EncodeSql(m.DICTID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYS_DICTModel m)
{
if (isExists(new T_SYS_DICTSW {
DICTTYPEID = m.DICTTYPEID, DICTVALUE = m.DICTVALUE
}))
{
return(new Message(false, "添加失败，该值已存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYS_DICT(DICTTYPEID,DICTNAME, DICTVALUE, ORDERBY,STANDBY1,STANDBY2,STANDBY3,STANDBY4)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.DICTTYPEID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DICTNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DICTVALUE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.STANDBY1));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.STANDBY2));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.STANDBY3));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.STANDBY4));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败，请检查输入框是否正确!", ""));
}
}
/// <summary>
/// 获取有记录的所有类型
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <T_SYS_DICTModel> getDict45(T_SYS_ORG_LINK_SW sw)
{
DataTable dt45 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "45"
}); //组织机构联系人类型
DataTable dt = BaseDT.T_SYS_ORG_LINK.getDT(sw); //列表
var result = new List <T_SYS_DICTModel>();
for (int i = 0; i < dt45.Rows.Count; i++)
{
T_SYS_DICTModel m = new T_SYS_DICTModel();
m.DICTTYPEID = dt45.Rows[i]["DICTTYPEID"].ToString();
m.DICTID = dt45.Rows[i]["DICTID"].ToString();
m.DICTTYPEID = dt45.Rows[i]["DICTTYPEID"].ToString();
m.DICTNAME = dt45.Rows[i]["DICTNAME"].ToString();
m.DICTVALUE = dt45.Rows[i]["DICTVALUE"].ToString();
m.ORDERBY = dt45.Rows[i]["ORDERBY"].ToString();
m.STANDBY1 = dt45.Rows[i]["STANDBY1"].ToString();
m.STANDBY2 = dt45.Rows[i]["STANDBY2"].ToString();
m.STANDBY3 = dt45.Rows[i]["STANDBY3"].ToString();
m.STANDBY4 = dt45.Rows[i]["STANDBY4"].ToString();
DataRow[] dr = dt.Select("ORGLINKTYPE='" + m.DICTVALUE + "'");
//if(dr.Count()>0)不需要判断是否有记录，而是显示所有类别
result.Add(m);
}
return(result);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(T_SYS_DICTModel m)
{
if (m.opMethod == "Add")
{
return(BaseDT.T_SYS_DICT.Add(m));
}
if (m.opMethod == "Mdy")
{
return(BaseDT.T_SYS_DICT.Mdy(m));
}
if (m.opMethod == "Del")
{
return(BaseDT.T_SYS_DICT.Del(m));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_SYS_DICTModel m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("DELETE T_SYS_DICT ");
sb.AppendFormat(" WHERE DICTID= '{0}' ", ClsSql.EncodeSql(m.DICTID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败!", ""));
}
}
/// <summary>
/// 获取所有响应列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable<YJ_XY_WORK_Model> getModelListMan(YJ_XY_WORK_SW sw)
{
var result = new List<YJ_XY_WORK_Model>();
DataTable dt = BaseDT.YJ_XY_WORK.getDT(sw);//列表
DataTable dt24 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "24"});//火情预警等级
DataTable dt25 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "25" });//预警响应部门
for (int i = 0; i < dt24.Rows.Count; i++)
{
for (int k = 0; k < dt25.Rows.Count; k++)
{
YJ_XY_WORK_Model m = new YJ_XY_WORK_Model();
m.DANGERCLASS = dt24.Rows[i]["DICTVALUE"].ToString();
m.YJXYDEPT = dt25.Rows[k]["DICTVALUE"].ToString();
m.YJXYID = BaseDT.YJ_XY_WORK.getID(dt, m.DANGERCLASS, m.YJXYDEPT);
m.YJXYCONTENT = BaseDT.YJ_XY_WORK.getContent(dt, m.DANGERCLASS, m.YJXYDEPT);
m.DANGERCLASSName = dt24.Rows[i]["DICTNAME"].ToString();// BaseDT.T_SYS_DICT.getName(dt24, m.DANGERCLASS);
m.YJXYDEPTName = dt25.Rows[k]["DICTNAME"].ToString();
T_SYS_DICTModel dm = new T_SYS_DICTModel();
dm.STANDBY1 = dt24.Rows[i]["STANDBY1"].ToString();
m.dicModel = dm;
result.Add(m);
}
}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// YJ_XY_WORK_Model m = new YJ_XY_WORK_Model();
// m.YJXYID = dt.Rows[i]["YJXYID"].ToString();
// m.DANGERCLASS = dt.Rows[i]["DANGERCLASS"].ToString();
// m.YJXYDEPT = dt.Rows[i]["YJXYDEPT"].ToString();
// m.YJXYCONTENT = dt.Rows[i]["YJXYCONTENT"].ToString();
// m.DANGERCLASSName = BaseDT.T_SYS_DICT.getName(dt24, m.DANGERCLASS);
// m.YJXYDEPTName = BaseDT.T_SYS_DICT.getName(dt24, m.YJXYDEPT);
// result.Add(m);
//}
dt.Clear();
dt.Dispose();
dt24.Clear();
dt24.Dispose();
dt25.Clear();
dt25.Dispose();
return result;
}
/// <summary>
/// 获取字典数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYS_DICTModel> getListModel(T_SYS_DICTSW sw)
{
var result = new List <T_SYS_DICTModel>();
DataTable dt = BaseDT.T_SYS_DICT.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_DICTModel m = new T_SYS_DICTModel();
m.DICTID = dt.Rows[i]["DICTID"].ToString();
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTNAME = dt.Rows[i]["DICTNAME"].ToString();
m.DICTVALUE = dt.Rows[i]["DICTVALUE"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.STANDBY1 = dt.Rows[i]["STANDBY1"].ToString();
m.STANDBY2 = dt.Rows[i]["STANDBY2"].ToString();
m.STANDBY3 = dt.Rows[i]["STANDBY3"].ToString();
m.STANDBY4 = dt.Rows[i]["STANDBY4"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_DICTModel getModel(T_SYS_DICTSW sw)
{
DataTable dt = BaseDT.T_SYS_DICT.getDT(sw);
T_SYS_DICTModel m = new T_SYS_DICTModel();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.DICTID = dt.Rows[i]["DICTID"].ToString();
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTNAME = dt.Rows[i]["DICTNAME"].ToString();
m.DICTVALUE = dt.Rows[i]["DICTVALUE"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.STANDBY1 = dt.Rows[i]["STANDBY1"].ToString();
m.STANDBY2 = dt.Rows[i]["STANDBY2"].ToString();
m.STANDBY3 = dt.Rows[i]["STANDBY3"].ToString();
m.STANDBY4 = dt.Rows[i]["STANDBY4"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
