/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(PEST_REPORT_DIEPINESURVEY_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE PEST_REPORT_DIEPINESURVEY"); sb.AppendFormat(" SET "); sb.AppendFormat("BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",FINDER='{0}'", ClsSql.EncodeSql(m.FINDER)); sb.AppendFormat(",FINDDATE='{0}'", ClsSql.EncodeSql(m.FINDDATE)); sb.AppendFormat(",LINKTELL='{0}'", ClsSql.EncodeSql(m.LINKTELL)); sb.AppendFormat(",DIEPINECOUNT={0}", ClsSql.saveNullField(m.DIEPINECOUNT)); sb.AppendFormat(",REPORTDATE='{0}'", ClsSql.EncodeSql(m.REPORTDATE)); sb.AppendFormat(",SAMPLINGCOUNT='{0}'", ClsSql.EncodeSql(m.SAMPLINGCOUNT)); sb.AppendFormat(",AUTHENTICATERESULT={0}", ClsSql.saveNullField(m.AUTHENTICATERESULT)); sb.AppendFormat(" WHERE PEST_REPORT_DIEPINESURVEYID= '{0}'", ClsSql.EncodeSql(m.PEST_REPORT_DIEPINESURVEYID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.returnUrl)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", m.returnUrl)); } }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(FIRELOST_LOSTTYPE_FARMPASTUREPRODUCT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM FIRELOST_LOSTTYPE_FARMPASTUREPRODUCT WHERE 1=1"); if (string.IsNullOrEmpty(sw.FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID) == false) { sb.AppendFormat(" AND FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID = '{0}'", ClsSql.EncodeSql(sw.FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID)); } if (string.IsNullOrEmpty(sw.FIRELOST_FIREINFOID) == false) { sb.AppendFormat(" AND FIRELOST_FIREINFOID = '{0}'", ClsSql.EncodeSql(sw.FIRELOST_FIREINFOID)); } if (string.IsNullOrEmpty(sw.FARMPASTUREPRODUCNAME) == false) { sb.AppendFormat(" AND FARMPASTUREPRODUCNAME like '%{0}%'", ClsSql.EncodeSql(sw.FARMPASTUREPRODUCNAME)); } if (string.IsNullOrEmpty(sw.FARMPASTUREPRODUCCODE) == false) { sb.AppendFormat(" AND FARMPASTUREPRODUCCODE = '{0}'", ClsSql.EncodeSql(sw.FARMPASTUREPRODUCCODE)); } string sql = "SELECT FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID, FIRELOST_FIREINFOID, FARMPASTUREPRODUCNAME, FARMPASTUREPRODUCCODE, LOSEMONEYCOUNT, LOSECOUNT, BASEPRICE, MARK " + sb.ToString() + " ORDER BY FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Save(WILD_ANIMALPROP_Model m) { StringBuilder sb = new StringBuilder(); if (isExists(new WILD_ANIMALPROP_SW { BIOLOGICALTYPECODE = m.BIOLOGICALTYPECODE })) { sb.AppendFormat("Update WILD_ANIMALPROP Set "); sb.AppendFormat(" PROTECTIONLEVELCODE='{0}'", ClsSql.EncodeSql(m.PROTECTIONLEVELCODE)); sb.AppendFormat(",LIVINGSTATUSCODE='{0}'", ClsSql.EncodeSql(m.LIVINGSTATUSCODE)); sb.AppendFormat(" WHERE BIOLOGICALTYPECODE= '{0}'", ClsSql.EncodeSql(m.BIOLOGICALTYPECODE)); } else { sb.AppendFormat("Insert Into WILD_ANIMALPROP(BIOLOGICALTYPECODE, PROTECTIONLEVELCODE, LIVINGSTATUSCODE)"); sb.AppendFormat(" Values("); sb.AppendFormat(" '{0}'", ClsSql.EncodeSql(m.BIOLOGICALTYPECODE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PROTECTIONLEVELCODE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LIVINGSTATUSCODE)); sb.AppendFormat(")"); } bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败!", "")); } }
/// <summary> /// 添加返回当前记录的id /// </summary> /// <param name="o"></param> /// <returns></returns> public static Message Add(OD_ODTYPE_Model o) {//增加判断该值班日期是否已存在 StringBuilder sbExits = new StringBuilder(); sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo()); sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND); if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true) { return(new Message(false, "新建失败,在该值班日期范围内已存在历史值班日期!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("insert into OD_TYPE(OD_TYPENAME,OD_DATEBEGIN,OD_DATEEND,BYORGNO) output inserted.OD_TYPEID values("); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_TYPENAME)); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEBEGIN)); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEEND)); sb.AppendFormat("'{0}')", ClsSql.EncodeSql(SystemCls.getCurUserOrgNo())); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); return(new Message(true, "新建成功", strid)); } catch (Exception) { throw; } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYSSEC_IPSUSER_Model m) { //判断用户序号是否存在于系统扩展表中 if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW { USERID = m.USERID }) == false) { return(new Message(false, "修改失败,系统用户不存在!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("update T_SYSSEC_IPSUSER"); sb.AppendFormat(" set "); sb.AppendFormat(" SEX='{0}'", ClsSql.EncodeSql(m.SEX)); sb.AppendFormat(",PHONE='{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",USERJOB='{0}'", ClsSql.EncodeSql(m.USERJOB)); sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID)); 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 DataTable getDT(PEST_PESTINFOFILE_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_PESTINFOFILE WHERE 1=1"); #region 查询条件 //生物物种编码 if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false) { sb.AppendFormat(" AND BIOLOGICALTYPECODE = '{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE)); } //附近名称 if (string.IsNullOrEmpty(sw.PESTFILETITLE) == false) { sb.AppendFormat(" AND PESTFILETITLE = '{0}'", ClsSql.EncodeSql(sw.PESTFILETITLE)); } //附件类别 if (string.IsNullOrEmpty(sw.PESTFILETYPE) == false) { sb.AppendFormat(" AND PESTFILETYPE = '{0}'", ClsSql.EncodeSql(sw.PESTFILETYPE)); } #endregion string sql = "SELECT PESTFILEID, BIOLOGICALTYPECODE, PESTFILETITLE, PESTFILETYPE, PESTFILENAME, UPLOADTIME, UID " + sb.ToString() + " ORDER BY UPLOADTIME "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(DC_UTILITY_MONITORINGSTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE DC_UTILITY_MONITORINGSTATION"); sb.AppendFormat(" set "); sb.AppendFormat("NUMBER={0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",NAME={0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",ADDRESS={0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",MODEL={0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",TRANSFERMODETYPE={0}", ClsSql.saveNullField(m.TRANSFERMODETYPE)); sb.AppendFormat(",MONICONTENT={0}", ClsSql.saveNullField(m.MONICONTENT)); sb.AppendFormat(",BUILDDATE={0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",USESTATE={0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",MANAGERSTATE={0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",WORTH={0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(",BUILDDATEBEGIN={0}", ClsSql.saveNullField(m.BUILDDATEBEGIN)); sb.AppendFormat(",BUILDDATEEND={0}", ClsSql.saveNullField(m.BUILDDATEEND)); sb.AppendFormat(" where DC_UTILITY_MONITORINGSTATION_ID= '{0}'", ClsSql.EncodeSql(m.DC_UTILITY_MONITORINGSTATION_ID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.DC_UTILITY_MONITORINGSTATION_ID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message MdyTP(DC_PHOTO_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE DC_PHOTO"); sb.AppendFormat(" set "); //sb.AppendFormat("PHOTO_ID={0}", ClsSql.saveNullField(m.PHOTO_ID)); sb.AppendFormat("PHOTOTITLE={0}", ClsSql.saveNullField(m.PHOTOTITLE)); //sb.AppendFormat(",PHOTOFILENAME={0}", ClsSql.saveNullField(m.PHOTOFILENAME)); sb.AppendFormat(",PHOTOEXPLAIN={0}", ClsSql.saveNullField(m.PHOTOEXPLAIN)); sb.AppendFormat(",PHOTOTIME={0}", ClsSql.saveNullField(m.PHOTOTIME)); sb.AppendFormat(",PHOTOTYPE={0}", ClsSql.saveNullField(m.PHOTOTYPE)); sb.AppendFormat(",PRID={0}", ClsSql.saveNullField(m.PRID)); sb.AppendFormat(" where PHOTO_ID= '{0}'", ClsSql.EncodeSql(m.PHOTO_ID)); 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 DataTable getDT(DC_ARMY_MEMBER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM DC_ARMY_MEMBER"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.DC_ARMY_MEMBER_ID) == false) { sb.AppendFormat(" AND DC_ARMY_MEMBER_ID = '{0}'", ClsSql.EncodeSql(sw.DC_ARMY_MEMBER_ID)); } if (string.IsNullOrEmpty(sw.DC_ARMY_ID) == false) { sb.AppendFormat(" AND DC_ARMY_ID = '{0}'", ClsSql.EncodeSql(sw.DC_ARMY_ID)); } if (string.IsNullOrEmpty(sw.MEMBERNAME) == false) { sb.AppendFormat(" AND MEMBERNAME like '%{0}%'", ClsSql.EncodeSql(sw.MEMBERNAME)); } if (string.IsNullOrEmpty(sw.SEX) == false) { sb.AppendFormat(" AND SEX = '{0}'", ClsSql.EncodeSql(sw.SEX)); } string sql = ""; sql = "SELECT DC_ARMY_MEMBER_ID, DC_ARMY_ID, MEMBERNAME, SEX, CONTACTS, BIRTH" + sb.ToString() + " order by MEMBERNAME"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(DC_PHOTO_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM DC_PHOTO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PHOTO_ID) == false) { sb.AppendFormat(" AND PHOTO_ID = '{0}'", ClsSql.EncodeSql(sw.PHOTO_ID)); } if (string.IsNullOrEmpty(sw.PHOTOTYPE) == false) { sb.AppendFormat(" AND PHOTOTYPE = '{0}'", ClsSql.EncodeSql(sw.PHOTOTYPE)); } if (string.IsNullOrEmpty(sw.PRID) == false) { sb.AppendFormat(" AND PRID = '{0}'", ClsSql.EncodeSql(sw.PRID)); } string sql = ""; sql = "SELECT PHOTO_ID, PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID" + sb.ToString() + " order by PHOTO_ID desc"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static DataTable getDT(DC_PHOTO_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM DC_PHOTO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PHOTO_ID) == false) { sb.AppendFormat(" AND PHOTO_ID = '{0}'", ClsSql.EncodeSql(sw.PHOTO_ID)); } if (string.IsNullOrEmpty(sw.PHOTOTYPE) == false) { sb.AppendFormat(" AND PHOTOTYPE = '{0}'", ClsSql.EncodeSql(sw.PHOTOTYPE)); } if (string.IsNullOrEmpty(sw.PRID) == false) { sb.AppendFormat(" AND PRID = '{0}'", ClsSql.EncodeSql(sw.PRID)); } string sql = "SELECT PHOTO_ID, PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID" + sb.ToString() + " order by PHOTO_ID desc"; string sqlC = "select count(1) " + sb.ToString(); total = int.Parse(DataBaseClass.ReturnSqlField(sqlC)); sw.curPage = PagerCls.getCurPage(new PagerSW { curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total }); DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a"); return(ds.Tables[0]); }
/// <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="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(PEST_REPORT_DIEPINESURVEY_Model m) { string[] arrDIEPINESURVEYID = m.PEST_REPORT_DIEPINESURVEYID.Split(','); StringBuilder sb = new StringBuilder(); sb.AppendFormat("DELETE FROM PEST_REPORT_DIEPINESURVEY WHERE PEST_REPORT_DIEPINESURVEYID in ("); for (int i = 0; i < arrDIEPINESURVEYID.Length; i++) { if (i != arrDIEPINESURVEYID.Length - 1) { sb.AppendFormat("'{0}',", ClsSql.EncodeSql(arrDIEPINESURVEYID[i])); } else { sb.AppendFormat("'{0}'", ClsSql.EncodeSql(arrDIEPINESURVEYID[i])); } } sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", m.returnUrl)); } else { return(new Message(false, "删除失败!", m.returnUrl)); } }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(FIRERECORD_REPORT9_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from FIRERECORD_REPORT9 where 1=1"); if (string.IsNullOrEmpty(sw.FIRERECORD_REPORT9ID) == false) { sb.AppendFormat(" and FIRERECORD_REPORT9ID='{0}'", ClsSql.EncodeSql(sw.FIRERECORD_REPORT9ID)); } if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" and BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.REPORTYEAR) == false) { sb.AppendFormat(" and REPORTYEAR='{0}'", ClsSql.EncodeSql(sw.REPORTYEAR)); } if (string.IsNullOrEmpty(sw.REPORTCODE) == false) { sb.AppendFormat(" and REPORTCODE='{0}'", ClsSql.EncodeSql(sw.REPORTCODE)); } if (string.IsNullOrEmpty(sw.SSXTYPELEVELCODE) == false) { sb.AppendFormat(" and SSXTYPELEVELCODE='{0}'", ClsSql.EncodeSql(sw.SSXTYPELEVELCODE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(DC_EQUIP_NEW_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE DC_EQUIP_NEW"); sb.AppendFormat(" set "); sb.AppendFormat("EQUIPTYPE={0}", ClsSql.saveNullField(m.EQUIPTYPE)); sb.AppendFormat(",NUMBER={0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",NAME={0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",MODEL={0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",BUYYEAR={0}", ClsSql.saveNullField(m.BUYYEAR)); sb.AppendFormat(",USESTATE={0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",STOREADDR={0}", ClsSql.saveNullField(m.STOREADDR)); sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",WORTH={0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(",EQUIPAMOUNT={0}", ClsSql.saveNullField(m.EQUIPAMOUNT)); sb.AppendFormat(",REPID={0}", ClsSql.saveNullField(m.REPID)); sb.AppendFormat(",DCSUPPROPUNIT={0}", ClsSql.saveNullField(m.DCSUPPROPUNIT)); sb.AppendFormat(",PRICE={0}", ClsSql.saveNullField(m.PRICE)); sb.AppendFormat(" where DC_EQUIP_NEW_ID= '{0}'", ClsSql.EncodeSql(m.DC_EQUIP_NEW_ID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.DC_EQUIP_NEW_ID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYS_ORG_CWH_Model m) { if (string.IsNullOrEmpty(m.ORDERBY))//如果排序号为空,则取最大+1 { m.ORDERBY = DataBaseClass.ReturnSqlField("select max(ORDERBY)+1 from T_SYS_ORG_CWH where BYORGNO='" + ClsSql.EncodeSql(m.BYORGNO) + "'"); } if (string.IsNullOrEmpty(m.ORDERBY)) { m.ORDERBY = "1"; } StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE T_SYS_ORG_CWH"); sb.AppendFormat(" set "); sb.AppendFormat("BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",CWHNAME='{0}'", ClsSql.EncodeSql(m.CWHNAME)); sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(" where CWHID= '{0}'", ClsSql.EncodeSql(m.CWHID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(JC_MONITOR_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT IMBID, TTBH, IMBTIME, JD, WD, SPJ, FYJ, IMBIMGURL, MANSTATE, MANRESULT, MANTIME,MANUSERID"); sb.AppendFormat(" from JC_MONITOR"); sb.AppendFormat(" WHERE 1 = 1"); if (string.IsNullOrEmpty(sw.IMBID) == false) { sb.AppendFormat(" AND IMBID = '{0}'", ClsSql.EncodeSql(sw.IMBID)); } if (string.IsNullOrEmpty(sw.TTBH) == false) { sb.AppendFormat(" AND TTBH = '{0}'", ClsSql.EncodeSql(sw.TTBH)); } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND IMBTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND IMBTIME<='{0} 23:59:59'", sw.DateEnd); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } string sql = sb.ToString() + " order by IMBTIME DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <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 Add(JC_MONITOR_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO JC_MONITOR(TTBH, IMBTIME, JD, WD, SPJ, FYJ, IMBIMGURL)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.TTBH)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.IMBTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.WD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SPJ)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FYJ)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.IMBIMGURL)); 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>true存在 false不存在</returns> public static bool isExists(OD_HANDOVER_SW sw) { //ONDUTYDATE, BYORGNO, ONDUTYUSERTYPE, ONDUTYTYPE, ONDUTYUSERID, OPTIME, OPCONTENT StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from OD_HANDOVER where 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" and BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.ODHID) == false) { sb.AppendFormat(" and ODHID='{0}'", ClsSql.EncodeSql(sw.ODHID)); } if (string.IsNullOrEmpty(sw.ONDUTYUSERTYPE) == false) { sb.AppendFormat(" and ONDUTYUSERTYPE='{0}'", ClsSql.EncodeSql(sw.ONDUTYUSERTYPE)); } if (string.IsNullOrEmpty(sw.ONDUTYTYPE) == false) { sb.AppendFormat(" and ONDUTYTYPE='{0}'", ClsSql.EncodeSql(sw.ONDUTYTYPE)); } if (string.IsNullOrEmpty(sw.ONDUTYUSERID) == false) { sb.AppendFormat(" and ONDUTYUSERID='{0}'", ClsSql.EncodeSql(sw.ONDUTYUSERID)); } if (string.IsNullOrEmpty(sw.ONDUTYDATE) == false) { sb.AppendFormat(" and ONDUTYDATE='{0}'", ClsSql.EncodeSql(sw.ONDUTYDATE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(FIRELOST_LOSTTYPE_ATTACK_P3_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM FIRELOST_LOSTTYPE_ATTACK_P3 WHERE 1=1"); if (string.IsNullOrEmpty(sw.P3ID) == false) { sb.AppendFormat(" AND P3ID = '{0}'", ClsSql.EncodeSql(sw.P3ID)); } if (string.IsNullOrEmpty(sw.FIRELOST_FIREINFOID) == false) { sb.AppendFormat(" AND FIRELOST_FIREINFOID = '{0}'", ClsSql.EncodeSql(sw.FIRELOST_FIREINFOID)); } if (string.IsNullOrEmpty(sw.P3NAME) == false) { sb.AppendFormat(" AND P3NAME like '%{0}%'", ClsSql.EncodeSql(sw.P3NAME)); } if (string.IsNullOrEmpty(sw.P3CODE) == false) { sb.AppendFormat(" AND P3CODE = '{0}'", ClsSql.EncodeSql(sw.P3CODE)); } string sql = "SELECT P3ID, FIRELOST_FIREINFOID, P3NAME, P3CODE, LOSEMONEYCOUNT, P3MONEY, ATTACKNUMBERS, ATTACKDAYS, MARK " + sb.ToString() + " ORDER BY P3ID "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYSSEC_IPSUSER_Model m) { //判断用户序号是否存在于系统扩展表中 if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW { USERID = m.USERID }) == false) { return(new Message(false, "添加失败,系统用户不存在!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYSSEC_IPSUSER(USERID,SEX,PHONE,USERJOB)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.USERID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SEX)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERJOB)); sb.AppendFormat(")"); 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 Mdy(ART_DOCUMENT_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE ART_DOCUMENT"); sb.AppendFormat(" set "); sb.AppendFormat(" ARTTYPEID='{0}'", ClsSql.EncodeSql(m.ARTTYPEID)); sb.AppendFormat(",ARTTITLE='{0}'", ClsSql.EncodeSql(m.ARTTITLE)); sb.AppendFormat(",ARTTAG='{0}'", ClsSql.EncodeSql(m.ARTTAG)); //sb.AppendFormat(",ARTTIME='{0}'", ClsSql.EncodeSql(m.ARTTIME)); sb.AppendFormat(",ARTCONTENT='{0}'", ClsSql.EncodeSql(m.ARTCONTENT)); sb.AppendFormat(",ARTCHECKSTATUS='{0}'", ClsSql.EncodeSql(m.ARTCHECKSTATUS)); sb.AppendFormat(",ARTADDUSERID='{0}'", ClsSql.EncodeSql(m.ARTADDUSERID)); sb.AppendFormat(",ARTCHECKTIME='{0}'", ClsSql.EncodeSql(m.ARTCHECKTIME)); sb.AppendFormat(",ARTCHECKUSERID='{0}'", ClsSql.EncodeSql(m.ARTCHECKUSERID)); sb.AppendFormat(",PLANFILENAME='{0}'", ClsSql.EncodeSql(m.PLANFILENAME)); sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(" where ARTID= '{0}'", ClsSql.EncodeSql(m.ARTID)); 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 MdyLastOpTime(T_SYSSEC_IPSUSER_Model m) { //判断用户序号是否存在于系统扩展表中 if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW { USERID = m.USERID }) == false) { return(new Message(false, "修改失败,系统用户不存在!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("update T_SYSSEC_USER"); sb.AppendFormat(" set "); sb.AppendFormat(" LASTOPTIME='{0}'", ClsSql.EncodeSql(PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now))); sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID)); 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 Man(JC_PERALARM_Model m) { if (string.IsNullOrEmpty(m.MANTIME)) { m.MANTIME = ClsSwitch.SwitTM(DateTime.Now); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE JC_PERALARM"); sb.AppendFormat(" set "); sb.AppendFormat("MANSTATE='{0}'", ClsSql.EncodeSql(m.MANSTATE)); sb.AppendFormat(",MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT)); sb.AppendFormat(",MANTIME='{0}'", ClsSql.EncodeSql(m.MANTIME)); sb.AppendFormat(",MANUSERID='{0}'", ClsSql.EncodeSql(m.MANUSERID)); sb.AppendFormat(" where PERALARMID= '{0}'", ClsSql.EncodeSql(m.PERALARMID)); 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 DataTable getDT(PEST_REPORT_SCXCBFZMX_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT * FROM PEST_REPORT_SCXCBFZMX WHERE 1=1"); if (!string.IsNullOrEmpty(sw.PEST_REPORT_SCXCBFZMXID)) { sb.AppendFormat(" AND PEST_REPORT_SCXCBFZMXID = '{0}'", ClsSql.EncodeSql(sw.PEST_REPORT_SCXCBFZMXID)); } if (!string.IsNullOrEmpty(sw.PEST_REPORT_SCXCBFZID)) { sb.AppendFormat(" AND PEST_REPORT_SCXCBFZID = '{0}'", ClsSql.EncodeSql(sw.PEST_REPORT_SCXCBFZID)); } if (!string.IsNullOrEmpty(sw.SCXCBFZMXTYPEID)) { sb.AppendFormat(" AND SCXCBFZMXTYPEID = '{0}'", ClsSql.EncodeSql(sw.SCXCBFZMXTYPEID)); } if (!string.IsNullOrEmpty(sw.SCXCBFZMXTYPEVALUE)) { sb.AppendFormat(" AND SCXCBFZMXTYPEVALUE = '{0}'", ClsSql.EncodeSql(sw.SCXCBFZMXTYPEVALUE)); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(JC_PERALARM_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO JC_PERALARM(FIRENAME,BYORGNO,PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT ,MANSTATE , MANRESULT, MANTIME, MANUSERID,JD, WD, PEARLARMPRE)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.FIRENAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMPHONE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMADDRESS)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMCONTENT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANSTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANRESULT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANTIME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANUSERID)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PEARLARMPRE)); //sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PEARLARMISSUED)); sb.AppendFormat(")"); 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 Man(T_IPS_ALARM_Model m) { if (string.IsNullOrEmpty(m.ALARMID)) { return(new Message(false, "修改失败,请选择要处理的记录!", "")); } StringBuilder sb = new StringBuilder(); //(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE) sb.AppendFormat("UPDATE T_IPS_ALARM"); sb.AppendFormat(" set "); sb.AppendFormat(" ALARMCONTENT='{0}'", ClsSql.EncodeSql(m.ALARMCONTENT)); sb.AppendFormat(" ,MANSTATE='{0}'", "1"); sb.AppendFormat(" ,MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT)); sb.AppendFormat(" ,MANTIME='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sb.AppendFormat(" ,MANUSERID='{0}'", SystemCls.getUserID()); sb.AppendFormat(" where ALARMID= '{0}'", ClsSql.EncodeSql(m.ALARMID)); 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(PEST_REPORT_DIEPINESURVEY_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO PEST_REPORT_DIEPINESURVEY(BYORGNO, FINDER, FINDDATE, LINKTELL, DIEPINECOUNT, REPORTDATE, SAMPLINGCOUNT, AUTHENTICATERESULT)"); sb.AppendFormat(" VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FINDER)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FINDDATE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LINKTELL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DIEPINECOUNT)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.REPORTDATE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SAMPLINGCOUNT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.AUTHENTICATERESULT)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", m.returnUrl)); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", m.returnUrl)); } }