/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(JC_FIRE_PLAN_Model m)
{
StringBuilder sb = new StringBuilder();
//HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO
sb.AppendFormat("UPDATE JC_FIRE_PLAN");
sb.AppendFormat(" set ");
sb.AppendFormat("BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",FIRELEVEL='{0}'", ClsSql.EncodeSql(m.FIRELEVEL));
sb.AppendFormat(",PLANTITLE='{0}'", ClsSql.EncodeSql(m.PLANTITLE));
sb.AppendFormat(",PLANCONTENT='{0}'", ClsSql.EncodeSql(m.PLANCONTENT));
sb.AppendFormat(",PLANFILENAME='{0}'", ClsSql.EncodeSql(m.PLANFILENAME));
sb.AppendFormat(" where JC_FIRE_PLANID= '{0}'", ClsSql.EncodeSql(m.JC_FIRE_PLANID));
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 Del(JC_FIRE_PLAN_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete JC_FIRE_PLAN");
sb.AppendFormat(" where JC_FIRE_PLANID= '{0}'", ClsSql.EncodeSql(m.JC_FIRE_PLANID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 获取相应单位的火线等级预案
/// </summary>
/// <param name="dr"></param>
/// <param name="dtORG"></param>
/// <param name="dtFIRELEVEL"></param>
/// <param name="org"></param>
/// <returns></returns>
private static IEnumerable <JC_FIRE_PLAN_Model> GetYAList(DataRow[] dr, DataTable dtORG, DataTable dtFIRELEVEL, string org)
{
var result = new List <JC_FIRE_PLAN_Model>();
for (int i = 0; i < dr.Length; i++)
{
JC_FIRE_PLAN_Model m = new JC_FIRE_PLAN_Model();
m.JC_FIRE_PLANID = dr[i]["JC_FIRE_PLANID"].ToString();
m.BYORGNO = dr[i]["BYORGNO"].ToString();
m.FIRELEVEL = dr[i]["FIRELEVEL"].ToString();
m.PLANTITLE = dr[i]["PLANTITLE"].ToString();
m.PLANCONTENT = dr[i]["PLANCONTENT"].ToString();
m.PLANFILENAME = dr[i]["PLANFILENAME"].ToString();
m.BYORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);//单位名称
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.FIRELEVEL);
result.Add(m);
}
return(result);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(JC_FIRE_PLAN_Model m)
{
if (m.opMethod == "Add")
{
//SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_FIRE_PLAN.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.JC_FIRE_PLAN.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.JC_FIRE_PLAN.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 Add(JC_FIRE_PLAN_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO JC_FIRE_PLAN(BYORGNO, FIRELEVEL, PLANTITLE, PLANCONTENT, PLANFILENAME)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FIRELEVEL));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLANTITLE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLANCONTENT));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLANFILENAME));
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 JC_FIRE_PLAN_Model getModel(JC_FIRE_PLAN_SW sw)
{
var result = new List <JC_FIRE_PLAN_Model>();
DataTable dt = BaseDT.JC_FIRE_PLAN.getDT(sw);//列表
JC_FIRE_PLAN_Model m = new JC_FIRE_PLAN_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.JC_FIRE_PLANID = dt.Rows[i]["JC_FIRE_PLANID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.PLANTITLE = dt.Rows[i]["PLANTITLE"].ToString();
m.PLANCONTENT = dt.Rows[i]["PLANCONTENT"].ToString();
m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
m.BYORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); //单位名称
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //预案
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.FIRELEVEL);
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取分页
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_FIRE_PLAN_Model> getModelList(JC_FIRE_PLAN_SW sw, out int total)
{
var result = new List <JC_FIRE_PLAN_Model>();
DataTable dt = BaseDT.JC_FIRE_PLAN.getDT(sw, out total);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //预案
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_FIRE_PLAN_Model m = new JC_FIRE_PLAN_Model();
m.JC_FIRE_PLANID = dt.Rows[i]["JC_FIRE_PLANID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.PLANTITLE = dt.Rows[i]["PLANTITLE"].ToString();
m.PLANCONTENT = dt.Rows[i]["PLANCONTENT"].ToString();
m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString();
m.BYORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);//单位名称
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.FIRELEVEL);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
return(result);
}
