/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <JC_FIRE_REPORT_Model> getModelList(JC_FIRE_REPORT_SW sw)
{
var result = new List <JC_FIRE_REPORT_Model>();
DataTable dt = BaseDT.JC_FIRE_REPORT.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_FIRE_REPORT_Model m = new JC_FIRE_REPORT_Model();
m.ID = dt.Rows[i]["ID"].ToString();
m.OWERJCFID = dt.Rows[i]["OWERJCFID"].ToString();
m.FILENAME = dt.Rows[i]["FILENAME"].ToString();
m.FILESIZE = dt.Rows[i]["FILESIZE"].ToString();
m.FILEURL = dt.Rows[i]["FILEURL"].ToString();
//m.UPLOADTIME = dt.Rows[i]["UPLOADTIME"].ToString();
m.UPLOADTIME = ClsSwitch.SwitTM(dt.Rows[i]["UPLOADTIME"].ToString());
m.UPLOADUSERID = dt.Rows[i]["UPLOADUSERID"].ToString();
m.UPLOADORGNO = dt.Rows[i]["UPLOADORGNO"].ToString();
m.UPLOANAME = T_SYSSEC_IPSUSERCls.getModel(new T_SYSSEC_IPSUSER_SW()
{
USERID = m.UPLOADUSERID
}).USERNAME;
m.UPLOADORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.UPLOADORGNO);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Add(JC_FIRE_REPORT_SW m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" INSERT INTO JC_FIRE_REPORT ( OWERJCFID, FILENAME, FILESIZE, FILEURL, UPLOADTIME,UPLOADUSERID,UPLOADORGNO)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.OWERJCFID));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.FILENAME));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.FILESIZE));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.FILEURL));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(ClsSwitch.SwitTM(m.UPLOADTIME)));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(m.UPLOADUSERID));
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.UPLOADORGNO));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
logs.Error(sb.ToString());
return(new Message(false, "添加失败!", ""));
}
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(JC_FIRE_REPORT_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM JC_FIRE_REPORT");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.OWERJCFID) == false)
{
sb.AppendFormat(" AND OWERJCFID = '{0}'", ClsSql.EncodeSql(sw.OWERJCFID));
}
if (string.IsNullOrEmpty(sw.FILENAME) == false)
{
sb.AppendFormat(" AND FILENAME = '{0}'", ClsSql.EncodeSql(sw.FILENAME));
}
if (string.IsNullOrEmpty(sw.FILESIZE) == false)
{
sb.AppendFormat(" AND FILESIZE = '{0}'", ClsSql.EncodeSql(sw.FILESIZE));
}
if (string.IsNullOrEmpty(sw.FILEURL) == false)
{
sb.AppendFormat(" AND FILEURL = '{0}'", ClsSql.EncodeSql(sw.FILEURL));
}
if (string.IsNullOrEmpty(sw.UPLOADTIME) == false)
{
sb.AppendFormat(" AND UPLOADTIME = '{0}'", ClsSql.EncodeSql(sw.UPLOADTIME));
}
if (string.IsNullOrEmpty(sw.UPLOADUSERID) == false)
{
sb.AppendFormat(" AND UPLOADUSERID = '{0}'", ClsSql.EncodeSql(sw.UPLOADUSERID));
}
if (string.IsNullOrEmpty(sw.UPLOADORGNO) == false)
{
sb.AppendFormat(" AND UPLOADORGNO = '{0}'", ClsSql.EncodeSql(sw.UPLOADORGNO));
}
string sql = "SELECT ID,OWERJCFID, FILENAME, FILESIZE, FILEURL, UPLOADTIME, UPLOADUSERID, UPLOADORGNO"
+ sb.ToString()
+ " order by OWERJCFID";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(JC_FIRE_REPORT_SW m)
{
if (m.opMethod == "Add")
{
//SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msg = BaseDT.JC_FIRE_REPORT.Add(m);
return(new Message(msg.Success, msg.Msg, ""));
}
//if (m.opMethod == "Mdy")
//{
// //SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
// Message msgUser = BaseDT.JC_FIRE_REPORT.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_REPORT.Del(m);
// return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
//}
return(new Message(false, "无效操作", ""));
}
