/// <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, "无效操作", "")); }