/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(DC_UTILITY_ISOLATIONSTRIP_Model m) { StringBuilder sb = new StringBuilder(); //sb.AppendFormat("INSERT INTO DC_UTILITY_ISOLATIONSTRIP(ISOLATIONTYPE, NUMBER, NAME, BYORGNO, BUILDDATE, USESTATE,MANAGERSTATE, WIDTH, LENGTH, JDBEGIN, WDBEGIN, JDEND, WDEND,JWDLIST)"); sb.AppendFormat("INSERT INTO DC_UTILITY_ISOLATIONSTRIP( ISOLATIONTYPE, NUMBER, NAME, BYORGNO, BUILDDATE, USESTATE,MANAGERSTATE, WIDTH, LENGTH, JDBEGIN, WDBEGIN, JDEND, WDEND,JWDLIST,PLANAREA,REALAREA,WORTH,KINDTYPE,POSITION,PRICE,ALLEYWAYWIDETH,TREETYPE,ENTRYTIME,BUILDDATEBEGIN,BUILDDATEEND) output inserted.DC_UTILITY_ISOLATIONSTRIP_ID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.ISOLATIONTYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WIDTH)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.LENGTH)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JDBEGIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WDBEGIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JDEND)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WDEND)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JWDLIST)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PLANAREA)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.REALAREA)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.KINDTYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.Position)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.Price)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.AlleywayWideth)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.TREETYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ENTRYTIME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEBEGIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEEND)); sb.AppendFormat(")"); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); if (string.IsNullOrEmpty(strid) == false) { return(new Message(true, "添加成功!", strid)); } else { return(new Message(false, "添加失败!请检查输入框是否正确!", strid)); } } catch (Exception) { throw; } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(YJ_DCSMS_TMP_Model m) { //if (string.IsNullOrEmpty(m.ORDERBY) == true) // m.ORDERBY = "0"; //if (string.IsNullOrEmpty(m.ISENABLE) == true) // m.ISENABLE = "0"; StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE YJ_DCSMS_TMP"); sb.AppendFormat(" set "); sb.AppendFormat("TMPCONTENT='{0}'", ClsSql.EncodeSql(m.TMPCONTENT)); sb.AppendFormat(",SMSSENDUSERLIST='{0}'", ClsSql.EncodeSql(m.SMSSENDUSERLIST)); if (string.IsNullOrEmpty(m.SMSGROUPNAME) == false) { sb.AppendFormat(",SMSGROUPNAME='{0}'", ClsSql.EncodeSql(m.SMSGROUPNAME)); } if (string.IsNullOrEmpty(m.SMSGROUPTYPE) == false) { sb.AppendFormat(",SMSGROUPTYPE='{0}'", ClsSql.EncodeSql(m.SMSGROUPTYPE)); } if (string.IsNullOrEmpty(m.DANGERCLASS) == false) { sb.AppendFormat(",DANGERCLASS='{0}'", ClsSql.EncodeSql(m.DANGERCLASS)); } if (string.IsNullOrEmpty(m.ORDERBY) == false) { sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY)); } if (string.IsNullOrEmpty(m.ISENABLE) == false) { sb.AppendFormat(",ISENABLE='{0}'", ClsSql.EncodeSql(m.ISENABLE)); } if (string.IsNullOrEmpty(m.TID) == false) { sb.AppendFormat(",TID='{0}'", ClsSql.EncodeSql(m.TID)); } sb.AppendFormat(" where YJ_DCSMS_TMPID= '{0}'", ClsSql.EncodeSql(m.YJ_DCSMS_TMPID)); 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(T_SYS_ADDREDDBOOK_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM T_SYS_ADDREDDBOOK a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.ADID) == false) { sb.AppendFormat(" AND ADID = '{0}'", ClsSql.EncodeSql(sw.ADID)); } if (string.IsNullOrEmpty(sw.ATID) == false) { sb.AppendFormat(" AND ATID = '{0}'", ClsSql.EncodeSql(sw.ATID)); } //if (string.IsNullOrEmpty(sw.ORGNO) == false) // sb.AppendFormat(" AND ORGNO = '{0}'", ClsSql.EncodeSql(sw.ORGNO)); if (string.IsNullOrEmpty(sw.PHONE) == false) { sb.AppendFormat(" AND PHONE like '%{0}%'", ClsSql.EncodeSql(sw.PHONE)); } if (string.IsNullOrEmpty(sw.ADNAME) == false) { sb.AppendFormat(" AND ADNAME like '%{0}%'", ClsSql.EncodeSql(sw.ADNAME)); } //if (string.IsNullOrEmpty(sw.TopORGNO) == false) //{ // if (PublicCls.OrgIsShi(sw.TopORGNO)) // { // sb.AppendFormat(" and ORGNO like '{0}%'", PublicCls.getShiIncOrgNo(sw.TopORGNO)); // } // else if (PublicCls.OrgIsXian(sw.TopORGNO)) // { // sb.AppendFormat(" and ORGNO like '{0}%'", PublicCls.getXianIncOrgNo(sw.TopORGNO)); // } // else // { // sb.AppendFormat(" and ORGNO = '{0}'", PublicCls.getZhenIncOrgNo(sw.TopORGNO)); // } //} string sql = "SELECT ADID,ATID, ORGNO, ADNAME, USERJOB, PHONE, Tell, ORDERBY " + sb.ToString() + " order by ORDERBY"; 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(DC_SUPPLIESPROP_Model m) { if (DC_SUPPLIESPROP.isExists(new DC_SUPPLIESPROP_Model { DC_SUPPLIESPROP_ID = m.DC_SUPPLIESPROP_ID }) == false) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO DC_SUPPLIESPROP(DC_SUPPLIESPROP_ID,DCSUPPROPNAME, DCSUPPROPMODEL, DCSUPPROPUNIT, DCSUPPROPFACTORY, MARK)"); sb.AppendFormat("VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.DC_SUPPLIESPROP_ID)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DCSUPPROPNAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DCSUPPROPMODEL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DCSUPPROPUNIT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DCSUPPROPFACTORY)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", m.DC_SUPPLIESPROP_ID)); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } } else { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE DC_SUPPLIESPROP"); sb.AppendFormat(" set "); sb.AppendFormat("DCSUPPROPNAME={0}", ClsSql.saveNullField(m.DCSUPPROPNAME)); sb.AppendFormat(",DCSUPPROPMODEL={0}", ClsSql.saveNullField(m.DCSUPPROPMODEL)); sb.AppendFormat(",DCSUPPROPUNIT={0}", ClsSql.saveNullField(m.DCSUPPROPUNIT)); sb.AppendFormat(",DCSUPPROPFACTORY={0}", ClsSql.saveNullField(m.DCSUPPROPFACTORY)); sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(" where DC_SUPPLIESPROP_ID= '{0}'", ClsSql.EncodeSql(m.DC_SUPPLIESPROP_ID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.DC_SUPPLIESPROP_ID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(DC_UTILITY_MONITORINGSTATION_Model m) { if (DC_UTILITY_MONITORINGSTATION.isExistsPoint(new DC_UTILITY_MONITORINGSTATION_Model { JD = m.JD, WD = m.WD }) == false) { StringBuilder sb = new StringBuilder(); //sb.AppendFormat("INSERT INTO DC_UTILITY_MONITORINGSTATION(NUMBER, NAME, ADDRESS, MODEL, BYORGNO,TRANSFERMODETYPE, MONICONTENT, BUILDDATE, USESTATE, MANAGERSTATE, MARK, JD, WD)"); sb.AppendFormat("INSERT INTO DC_UTILITY_MONITORINGSTATION( NUMBER, NAME, ADDRESS, MODEL, BYORGNO,TRANSFERMODETYPE, MONICONTENT, BUILDDATE, USESTATE, MANAGERSTATE, MARK, JD, WD,WORTH,BUILDDATEBEGIN,BUILDDATEEND) output inserted.DC_UTILITY_MONITORINGSTATION_ID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.TRANSFERMODETYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MONICONTENT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEBEGIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEEND)); sb.AppendFormat(")"); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); if (string.IsNullOrEmpty(strid) == false) { return(new Message(true, "添加成功!", strid)); } else { return(new Message(false, "添加失败!请检查输入框是否正确!", strid)); } } catch (Exception) { throw; } } else { return(new Message(false, "添加失败,已有相同的位置的监测站!", "")); } }
/// <summary> /// 获取报表数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns></returns> public static DataTable getDT(FIRERECORD_REPORT9_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT * FROM FIRERECORD_REPORT9 WHERE 1=1"); if (!string.IsNullOrEmpty(sw.FIRERECORD_REPORT9ID)) { sb.AppendFormat(" AND FIRERECORD_REPORT9ID = '{0}'", sw.FIRERECORD_REPORT9ID); } if (!string.IsNullOrEmpty(sw.BYORGNO)) { if (sw.BYORGNO.Substring(4, 11) == "00000000000")//获取所有市的 { sb.AppendFormat(" AND SUBSTRING(BYORGNO,1,4) = '{0}'", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); } else if (sw.BYORGNO.Substring(6, 9) == "000000000")//获取所有县的 { sb.AppendFormat(" AND SUBSTRING(BYORGNO,1,6) = '{0}'", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); } else if (sw.BYORGNO.Substring(9, 6) == "000000")//获取所有乡镇的 { sb.AppendFormat(" AND SUBSTRING(BYORGNO,1,9) = '{0}'", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } } if (!string.IsNullOrEmpty(sw.REPORTYEAR)) { sb.AppendFormat(" AND REPORTYEAR = '{0}'", sw.REPORTYEAR); } if (!string.IsNullOrEmpty(sw.REPORTCODE)) { sb.AppendFormat(" AND REPORTCODE = '{0}'", sw.REPORTCODE); } if (!string.IsNullOrEmpty(sw.SSXTYPELEVELCODE)) { sb.AppendFormat(" AND SSXTYPELEVELCODE = '{0}'", sw.SSXTYPELEVELCODE); } if (!string.IsNullOrEmpty(sw.REPORTVALUE)) { sb.AppendFormat(" AND REPORTVALUE = '{0}'", sw.REPORTVALUE); } sb.AppendFormat(" ORDER BY FIRERECORD_REPORT9ID"); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 森林防火基础设施统计 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(FIRERECORD_REPORT10_Model m) { List <string> sqllist = new List <string>(); string[] arrREPORTCODE = m.REPORTCODE.Split(','); string[] arrREPORTVALUE = m.REPORTVALUE.Split(','); for (int i = 0; i < arrREPORTVALUE.Length - 1; i++) { #region 更新 if (isExists(new FIRERECORD_REPORT10_SW { BYORGNO = m.BYORGNO, REPORTYEAR = m.REPORTYEAR, REPORTCODE = arrREPORTCODE[i], })) { StringBuilder sbUpdate = new StringBuilder(); sbUpdate.AppendFormat("UPDATE FIRERECORD_REPORT10 SET "); sbUpdate.AppendFormat(" REPORTVALUE= '{0}'", ClsSql.EncodeSql(arrREPORTVALUE[i])); sbUpdate.AppendFormat(" where BYORGNO= '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sbUpdate.AppendFormat(" and REPORTYEAR= '{0}'", ClsSql.EncodeSql(m.REPORTYEAR)); sbUpdate.AppendFormat(" and REPORTCODE= '{0}'", ClsSql.EncodeSql(arrREPORTCODE[i])); //sbUpdate.AppendFormat(" and REPORTVALUE= '{0}'", ClsSql.EncodeSql(arrREPORTVALUE[i])); sqllist.Add(sbUpdate.ToString()); } #endregion #region 添加 else { StringBuilder sbInsert = new StringBuilder(); sbInsert.AppendFormat("INSERT INTO FIRERECORD_REPORT10(BYORGNO,REPORTYEAR,REPORTCODE,REPORTVALUE)"); sbInsert.AppendFormat(" VALUES("); sbInsert.AppendFormat(" {0}", ClsSql.saveNullField(m.BYORGNO)); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(m.REPORTYEAR)); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrREPORTCODE[i])); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrREPORTVALUE[i])); sbInsert.AppendFormat(")"); sqllist.Add(sbInsert.ToString()); } #endregion } var j = DataBaseClass.ExecuteSqlTran(sqllist); if (j >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚机制!", "")); } }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_SYS_LOG_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM T_SYS_LOG"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.LOGID) == false) { sb.AppendFormat(" AND LOGID = '{0}'", ClsSql.EncodeSql(sw.LOGID)); } if (string.IsNullOrEmpty(sw.LOGTYPE) == false) { sb.AppendFormat(" AND LOGTYPE = '{0}'", ClsSql.EncodeSql(sw.LOGTYPE)); } if (string.IsNullOrEmpty(sw.OPERATION) == false) { sb.AppendFormat(" AND OPERATION like '%{0}%'", ClsSql.EncodeSql(sw.OPERATION)); } if (string.IsNullOrEmpty(sw.LOGINUSERID) == false) { sb.AppendFormat(" AND LOGINUSERID IN({0})", ClsSql.EncodeSql(sw.LOGINUSERID)); } if (string.IsNullOrEmpty(sw.TIMEBegin) == false) { sb.AppendFormat(" AND OPERATETIME >= '{0}'", ClsSql.EncodeSql(sw.TIMEBegin)); } if (string.IsNullOrEmpty(sw.TIMEEnd) == false) { sb.AppendFormat(" AND OPERATETIME <= '{0}'", ClsSql.EncodeSql(sw.TIMEEnd)); } if (string.IsNullOrEmpty(sw.SYSFLAG) == false) { sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG)); } string sql = "SELECT LOGID, LOGTYPE, OPERATION, OPERATIONCONTENT, LOGINUSERID, USERIP, OPERATETIME,SYSFLAG" + sb.ToString() + " order by OPERATETIME 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="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(WILD_LOCALANIMAL_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from WILD_LOCALANIMAL where 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" and BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false) { sb.AppendFormat(" and BIOLOGICALTYPECODE='{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(DUTY_CLASS_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from DUTY_CLASS where 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" and BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.DUTYCLASSID) == false) { sb.AppendFormat(" and DUTYCLASSID='{0}'", ClsSql.EncodeSql(sw.DUTYCLASSID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(T_SYSSEC_IPSUSER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYSSEC_USER where 1=1"); if (string.IsNullOrEmpty(sw.USERID) == false) { sb.AppendFormat(" and USERID={0}", ClsSql.EncodeSql(sw.USERID)); } if (string.IsNullOrEmpty(sw.LOGINUSERNAME) == false) { sb.AppendFormat(" and LOGINUSERNAME='******'", ClsSql.EncodeSql(sw.LOGINUSERNAME)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_SYS_LOG_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT LOGID, LOGTYPE, OPERATION, OPERATIONCONTENT, LOGINUSERID, USERIP, OPERATETIME,SYSFLAG"); sb.AppendFormat(" FROM T_SYS_LOG"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.LOGID) == false) { sb.AppendFormat(" AND LOGID = '{0}'", ClsSql.EncodeSql(sw.LOGID)); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message MdyJWD(DC_ARMY_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE DC_ARMY"); sb.AppendFormat(" set "); sb.AppendFormat("JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(" where DC_ARMY_ID= '{0}'", ClsSql.EncodeSql(m.DC_ARMY_ID)); 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 Save(T_SYSSEC_ROLE_RIGHT_Model m) { if (string.IsNullOrEmpty(m.ROLEID)) { return(null); } //首先删除 DataBaseClass.ExeSql("delete T_SYSSEC_ROLE_RIGHT where ROLEID=" + ClsSql.EncodeSql(m.ROLEID)); if (string.IsNullOrEmpty(m.RIGHTID) == false) { //一次性插入该用户对应的角色 DataBaseClass.ExeSql("INSERT INTO T_SYSSEC_ROLE_RIGHT (ROLEID, RIGHTID) SELECT " + m.ROLEID + " , RIGHTID FROM T_SYSSEC_RIGHT WHERE RIGHTID IN (" + ClsSql.SwitchStrToSqlIn(m.RIGHTID) + ")"); } return(new Message(true, "保存成功!", "")); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(PEST_PESTDYNAMICPROP_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from PEST_PESTDYNAMICPROP where 1=1"); if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false) { sb.AppendFormat(" and BIOLOGICALTYPECODE='{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE)); } if (string.IsNullOrEmpty(sw.DYNAMICPROPCODE) == false) { sb.AppendFormat(" and DYNAMICPROPCODE='{0}'", ClsSql.EncodeSql(sw.DYNAMICPROPCODE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(T_SYS_TREESPECIES_PEST_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYS_TREESPECIES_PEST where 1=1"); if (string.IsNullOrEmpty(sw.PESTCODE) == false) { sb.AppendFormat(" and PESTCODE='{0}'", ClsSql.EncodeSql(sw.PESTCODE)); } if (string.IsNullOrEmpty(sw.TSPCODE) == false) { sb.AppendFormat(" and TSPCODE='{0}'", ClsSql.EncodeSql(sw.TSPCODE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(T_SYSSEC_RIGHT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYSSEC_RIGHT where 1=1"); if (string.IsNullOrEmpty(sw.RIGHTID) == false) { sb.AppendFormat(" and RIGHTID='{0}'", ClsSql.EncodeSql(sw.RIGHTID)); } if (string.IsNullOrEmpty(sw.SYSFLAG) == false) { sb.AppendFormat(" and SYSFLAG='{0}'", ClsSql.EncodeSql(sw.SYSFLAG)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(T_SYSSEC_USER_DEFINPROP_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYSSEC_USER_DEFINPROP where 1=1"); if (string.IsNullOrEmpty(sw.UID) == false) { sb.AppendFormat(" and UID='{0}'", ClsSql.EncodeSql(sw.UID)); } if (string.IsNullOrEmpty(sw.DICTVALUE) == false) { sb.AppendFormat(" and DICTVALUE='{0}'", ClsSql.EncodeSql(sw.DICTVALUE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 点的修改 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Mdy(WILD_BotanyPoint_Model m) { if (TD_WILD_BOTANYDISTRIBUTE.isExists(new WILD_BotanyPoint_Model { OBJECTID = m.OBJECTID }) == false) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("insert into BOTANYPOINT(OBJECTID,NAME,JD,WD,Shape,TYPE,BYORGNO) values("); sb.AppendFormat("{0},", ClsSql.saveNullField(m.OBJECTID)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.JD)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.WD)); sb.AppendFormat("{0},", m.Shape); sb.AppendFormat("{0},", ClsSql.saveNullField(m.TYPE)); sb.AppendFormat("{0})", ClsSql.saveNullField(m.BYORGNO)); bool bln = SDEDataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } } else { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE BOTANYPOINT"); sb.AppendFormat(" set "); sb.AppendFormat("NAME={0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",TYPE={0}", ClsSql.saveNullField(m.TYPE)); sb.AppendFormat(",Shape={0}", m.Shape); sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(" where OBJECTID= {0}", ClsSql.saveNullField(m.OBJECTID)); bool bln = SDEDataBaseClass.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(JC_UAV_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM JC_UAV"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.UAVID) == false) { sb.AppendFormat(" AND UAVID = '{0}'", ClsSql.EncodeSql(sw.UAVID)); } if (string.IsNullOrEmpty(sw.UAVNAME) == false) { sb.AppendFormat(" AND UAVNAME like '%{0}%'", ClsSql.EncodeSql(sw.UAVNAME)); } if (string.IsNullOrEmpty(sw.UAVEQUIPNAME) == false) { sb.AppendFormat(" AND UAVEQUIPNAME like '%{0}%'", ClsSql.EncodeSql(sw.UAVEQUIPNAME)); } if (!string.IsNullOrEmpty(sw.BYORGNO)) { if (sw.BYORGNO.Substring(4, 11) == "00000000000")//获取所有市的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); } else if (sw.BYORGNO.Substring(6, 9) == "000000000")//获取所有县的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); } else if (sw.BYORGNO.Substring(9, 6) == "000000")//获取所有乡镇的 { sb.AppendFormat(" AND(SUBSTRING(BYORGNO,1,9) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); } else if (sw.BYORGNO.Substring(12, 3) == "000")//获取所有村的 { sb.AppendFormat(" AND(SUBSTRING(BYORGNO,1,12) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 12))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } } string sql = "SELECT UAVID,BYORGNO,UAVNAME,UAVEQUIPNAME,ORDERBY" + sb.ToString() + " order by ORDERBY desc"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DataTable getDT(PEST_REPORT_CONTROL_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT * FROM PEST_REPORT_CONTROL WHERE 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); } else if (sw.BYORGNO.Substring(6, 9) == "000000000" && sw.BYORGNO.Substring(4, 11) != "00000000000") //获取所有县的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); } else if (sw.BYORGNO.Substring(9, 6) == "000000" && sw.BYORGNO.Substring(6, 9) != "000000000") //获取所有乡镇的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); } else if (sw.BYORGNO.Substring(9, 6) != "000000") //获取所有村的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,12) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 12))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } } if (!string.IsNullOrEmpty(sw.HAPPENYEAR)) { sb.AppendFormat(" AND HAPPENYEAR = '{0}'", ClsSql.EncodeSql(sw.HAPPENYEAR)); } if (!string.IsNullOrEmpty(sw.HAPPENMONTH)) { sb.AppendFormat(" AND HAPPENMONTH = '{0}'", ClsSql.EncodeSql(sw.HAPPENMONTH)); } if (!string.IsNullOrEmpty(sw.PESTBYCODE)) { sb.AppendFormat(" AND PESTBYCODE = '{0}'", ClsSql.EncodeSql(sw.PESTBYCODE)); } if (!string.IsNullOrEmpty(sw.CONTROLMETHODCODE)) { sb.AppendFormat(" AND CONTROLMETHODCODE = '{0}'", ClsSql.EncodeSql(sw.CONTROLMETHODCODE)); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT2(T_SYSSEC_IPSUSER_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM T_SYSSEC_IPSUSER a right outer join T_SYSSEC_USER b on a.userid=b.userid WHERE 1=1"); //针对护林员用户,系统用户表中需要有对应的记录 sb.AppendFormat(" AND b.USERID is not null"); //根据登录用户名查询 if (string.IsNullOrEmpty(sw.LOGINUSERNAME) == false) { sb.AppendFormat(" AND b.LOGINUSERNAME like '%{0}%'", sw.LOGINUSERNAME); } //根据用户名查询 if (string.IsNullOrEmpty(sw.USERNAME) == false) { sb.AppendFormat(" AND b.USERNAME like '%{0}%'", sw.USERNAME); } //根据组织机构查询 if (!string.IsNullOrEmpty(sw.ORGNO)) { sb.AppendFormat(" AND b.ORGNO = '{0}'", ClsSql.EncodeSql(sw.ORGNO)); } //根据是否开通OA if (!string.IsNullOrEmpty(sw.IsOpenOA)) { if (sw.IsOpenOA == "1") { sb.AppendFormat(" AND b.IsOpenOA = '{0}'", ClsSql.EncodeSql(sw.IsOpenOA)); } else { sb.AppendFormat(" AND (b.IsOpenOA = '{0}' or b.IsOpenOA is NULL )", ClsSql.EncodeSql(sw.IsOpenOA)); } } string sql = "SELECT a.GID,a.SEX, a.PHONE, a.USERJOB" + ",b.USERID,b.ORGNO, b.LOGINUSERNAME, b.USERNAME, b.USERPWD, b.REGISTERTIME, b.LOGINNUM, b.LOGINIP, b.LASTTIME, b.NOTE,b.DEPARTMENT,b.IsOpenOA" + sb.ToString() + " order by b.ORGNO"; 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="sw"></param> /// <returns></returns> public static string getNum(DC_ARMY_SW sw) { string total = ""; StringBuilder sb = new StringBuilder(); sb.AppendFormat(" from DC_ARMY a "); sb.AppendFormat("where 1 = 1 "); if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的 sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); else if (sw.BYORGNO.Substring(6, 9) == "000000000" && sw.BYORGNO.Substring(4, 11) != "00000000000") //获取所有县的 sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); else sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); string sqlC = "select count(1) " + sb.ToString(); total = (DataBaseClass.ReturnSqlField(sqlC)).ToString(); return total; }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_MONITORINGSTATION_Model m) { if (IsExistsPoint(new PEST_MONITORINGSTATION_Model { JD = m.JD, WD = m.WD }) == false) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO PEST_MONITORINGSTATION(NUMBER, NAME, ADDRESS, MODEL, BYORGNO, TRANSFERMODETYPE, MONICONTENT, BUILDDATE, USESTATE, MANAGERSTATE, MARK, JD, WD, WORTH)"); sb.AppendFormat(" OUTPUT INSERTED.PEST_MONITORINGSTATIONID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.TRANSFERMODETYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MONICONTENT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(")"); try { string sId = DataBaseClass.ReturnSqlField(sb.ToString()); if (sId != "") { return(new Message(true, "添加成功!", sId)); } else { return(new Message(false, "添加失败!", "")); } } catch { return(new Message(false, "添加失败!", "")); } } else { return(new Message(false, "添加失败,已有相同的位置的监测点!", "")); } }
/// <summary> /// 获取分页数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(JC_INFRAREDCAMERA_BASICINFO_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM JC_INFRAREDCAMERA_BASICINFO a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.INFRAREDCAMERAID) == false) { sb.AppendFormat(" AND INFRAREDCAMERAID = '{0}'", ClsSql.EncodeSql(sw.INFRAREDCAMERAID)); } if (string.IsNullOrEmpty(sw.PHONE) == false) { sb.AppendFormat(" AND PHONE = '{0}'", ClsSql.EncodeSql(sw.PHONE)); } if (string.IsNullOrEmpty(sw.BYORGNO) == false) { if (PublicCls.OrgIsShi(sw.BYORGNO)) { sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getShiIncOrgNo(sw.BYORGNO)); } else if (PublicCls.OrgIsXian(sw.BYORGNO)) { sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getXianIncOrgNo(sw.BYORGNO)); } else if (PublicCls.OrgIsZhen(sw.BYORGNO)) { sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getZhenIncOrgNo(sw.BYORGNO)); } else { sb.AppendFormat(" and BYORGNO = '{0}'", sw.BYORGNO); } } string sql = "SELECT INFRAREDCAMERAID,BYORGNO,INFRAREDCAMERANAME,PHONE,JD,WD,GC,ADDRESS" + sb.ToString() + " order by BYORGNO"; 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 Add(DC_UTILITY_OVERWATCH_Model m) { if (DC_UTILITY_OVERWATCH.isExistsPoint(new DC_UTILITY_OVERWATCH_Model { JD = m.JD, WD = m.WD }) == false) { StringBuilder sb = new StringBuilder(); //sb.AppendFormat("INSERT INTO DC_UTILITY_OVERWATCH( NUMBER, NAME, ORGNOS, AREA, BUILDDATE, FLOOR, STRUCTURETYPE, SUBFACILITIES, MARK, JD, WD)"); sb.AppendFormat("INSERT INTO DC_UTILITY_OVERWATCH( NUMBER, NAME, ORGNOS, AREA, BUILDDATE, FLOOR, STRUCTURETYPE, SUBFACILITIES, MARK, JD, WD,WORTH,BUILDDATEBEGIN,BUILDDATEEND) output inserted.DC_UTILITY_OVERWATCH_ID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ORGNOS)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.AREA)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FLOOR)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.STRUCTURETYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.SUBFACILITIES)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEBEGIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATEEND)); sb.AppendFormat(")"); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); if (string.IsNullOrEmpty(strid) == false) { return(new Message(true, "添加成功!", strid)); } else { return(new Message(false, "添加失败!请检查输入框是否正确!", strid)); } } catch (Exception) { throw; } } else { return(new Message(false, "添加失败,已有相同的位置的瞭望台!", "")); } }
/// <summary> /// 分页获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">总记录数</param> /// <returns>参见模型</returns> public static DataTable getDT(PEST_LOCALTREESPECIES_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_LOCALTREESPECIES WHERE 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { if (sw.BYORGNO.Substring(4, 11) == "00000000000") //获取所有市的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); } else if (sw.BYORGNO.Substring(6, 9) == "000000000" && sw.BYORGNO.Substring(4, 11) != "00000000000") //获取所有县的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); } else if (sw.BYORGNO.Substring(9, 6) == "000000" && sw.BYORGNO.Substring(6, 9) != "000000000") //获取所有乡镇的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); } else if (sw.BYORGNO.Substring(9, 6) != "000000") //获取所有村的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,12) = '{0}')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 12))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } } if (!string.IsNullOrEmpty(sw.TSPCODE)) { sb.AppendFormat(" AND TSPCODE = '{0}'", ClsSql.EncodeSql(sw.TSPCODE)); } if (!string.IsNullOrEmpty(sw.TSPAREA)) { sb.AppendFormat(" AND TSPAREA = '{0}'", ClsSql.EncodeSql(sw.TSPAREA)); } string sql = " SELECT PEST_LOCALTREESPECIESID, BYORGNO, TSPCODE, TSPAREA " + sb.ToString() + " ORDER BY BYORGNO "; 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="sw"></param> /// <returns></returns> public static DataTable getDT(T_SYS_ORG_CWH_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM T_SYS_ORG_CWH"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.CWHID) == false) { sb.AppendFormat(" AND CWHID = '{0}'", ClsSql.EncodeSql(sw.CWHID)); } if (string.IsNullOrEmpty(sw.ORGNO) == false) { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.ORGNO)); } if (string.IsNullOrEmpty(sw.CWHNAME) == false) { sb.AppendFormat(" AND (CWHNAME like '%{0}%')", ClsSql.EncodeSql(sw.CWHNAME)); } if (!string.IsNullOrEmpty(sw.BYORGNO)) { if (sw.BYORGNO.Substring(4, 11) == "00000000000")//获取所有市的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,4) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 4))); } else if (sw.BYORGNO.Substring(6, 9) == "000000000")//获取所有县的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,6) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 6))); } else if (sw.BYORGNO.Substring(9, 6) == "000000")//获取所有乡镇的 { sb.AppendFormat(" AND (SUBSTRING(BYORGNO,1,9) = '{0}' or BYORGNO is null or BYORGNO='')", ClsSql.EncodeSql(sw.BYORGNO.Substring(0, 9))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } } string sql = "SELECT CWHID, BYORGNO, CWHNAME+'村委会' as CWHNAME, ORDERBY" + sb.ToString() + " order by BYORGNO,ORDERBY"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Save(PEST_REPORT_SCXCBFZMX_Model m) { List <string> sqllist = new List <string>(); string[] arrBYORGNO = m.BYORGNO.Split(','); string[] arrSCXCBFZMXTYPEID = m.SCXCBFZMXTYPEID.Split(','); string[] arrSCXCBFZMXTYPEVALUE = m.SCXCBFZMXTYPEVALUE.Split(','); string[] arrSCXCBFZMXVARCHAR = m.SCXCBFZMXVARCHAR.Split(','); #region 更新 if (arrSCXCBFZMXTYPEID.Length - 1 > 0) { StringBuilder sbInsert = new StringBuilder(); sbInsert.AppendFormat("INSERT INTO PEST_REPORT_SCXCBFZMX( PEST_REPORT_SCXCBFZID, SCXCBFZMXTYPEID, SCXCBFZMXTYPEVALUE, SCXCBFZMXVARCHAR)"); for (int i = 0; i < arrSCXCBFZMXTYPEID.Length - 1; i++) { string sql = "Select PEST_REPORT_SCXCBFZID From PEST_REPORT_SCXCBFZ WHERE BYORGNO='" + arrBYORGNO[i] + "' AND SCXCBFZYEAR='" + m.SCXCBFZYEAR + "'"; string SCXCBFZID = DataBaseClass.ReturnSqlField(sql); if (SCXCBFZID != "") { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(SCXCBFZID)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrSCXCBFZMXTYPEID[i])); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrSCXCBFZMXTYPEVALUE[i])); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrSCXCBFZMXVARCHAR[i])); sbInsert.AppendFormat(" UNION ALL "); } } string insertStr = sbInsert.ToString(); if (insertStr.Contains(" UNION ALL ")) { insertStr = insertStr.Substring(0, insertStr.Length - 10); sqllist.Add(insertStr); } } #endregion var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚机制!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(FIRELOST_LOSTTYPE_FARMPASTUREPRODUCT_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete FIRELOST_LOSTTYPE_FARMPASTUREPRODUCT"); sb.AppendFormat(" where FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID= '{0}'", ClsSql.EncodeSql(m.FIRELOST_LOSTTYPE_FARMPASTUREPRODUCTID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败!", "")); } }