/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static YJ_XY_WORK_Model getModel(YJ_XY_WORK_SW sw)
{
var result = new List<YJ_XY_WORK_Model>();
DataTable dt = BaseDT.YJ_XY_WORK.getDT(sw);//列表
YJ_XY_WORK_Model m = new YJ_XY_WORK_Model();
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" });//预警响应部门
m.DANGERCLASS = sw.DANGERCLASS;
m.YJXYDEPT = sw.YJXYDEPT;
m.YJXYID = BaseDT.YJ_XY_WORK.getID(dt, m.DANGERCLASS, m.YJXYDEPT);
m.YJXYCONTENT = BaseDT.YJ_XY_WORK.getContent(dt, m.DANGERCLASS, m.YJXYDEPT).Replace("<br>", "\n");
m.DANGERCLASSName = BaseDT.T_SYS_DICT.getName(dt24, m.DANGERCLASS);
m.YJXYDEPTName = BaseDT.T_SYS_DICT.getName(dt25, m.YJXYDEPT);
result.Add(m);
dt24.Clear();
dt24.Dispose();
dt25.Clear();
dt25.Dispose();
dt.Clear();
dt.Dispose();
return m;
}
/// <summary>
/// 获取文档列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable<YJ_XY_WORK_Model> getModelList(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 < 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="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(YJ_XY_WORK_Model m)
{
if (string.IsNullOrEmpty(m.YJXYCONTENT)==false)
m.YJXYCONTENT = m.YJXYCONTENT.Replace("\r\n", "<br>").Replace("\r", "<br>").Replace("\n", "<br>");//.Replace(@"\\n", "<br>").Replace(@"\r", "<br>").Replace(@"\n", "<br>").Replace(@"\r\n", "<br>");
if (m.opMethod == "Add")
{
//SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.YJ_XY_WORK.Add(m);
return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
}
if (m.opMethod == "Mdy")
{
//SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.YJ_XY_WORK.Mdy(m);
return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
}
if (m.opMethod == "Del")
{
//SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.YJ_XY_WORK.Del(m);
return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
}
return new Message(false, "无效操作", "");
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(YJ_XY_WORK_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete YJ_XY_WORK");
sb.AppendFormat(" where YJXYID= '{0}'", ClsSql.EncodeSql(m.YJXYID));
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="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(YJ_XY_WORK_Model m)
{
StringBuilder sb = new StringBuilder();
//HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO
sb.AppendFormat("UPDATE YJ_XY_WORK");
sb.AppendFormat(" set ");
//sb.AppendFormat("DANGERCLASS='{0}'", ClsSql.EncodeSql(m.DANGERCLASS));
//sb.AppendFormat(",YJXYDEPT='{0}'", ClsSql.EncodeSql(m.YJXYDEPT));
sb.AppendFormat("YJXYCONTENT='{0}'", ClsSql.EncodeSql(m.YJXYCONTENT));
sb.AppendFormat(" where YJXYID= '{0}'", ClsSql.EncodeSql(m.YJXYID));
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(YJ_XY_WORK_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO YJ_XY_WORK( DANGERCLASS, YJXYDEPT, YJXYCONTENT)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.DANGERCLASS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.YJXYDEPT));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.YJXYCONTENT));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
