/// <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, "删除失败!", ""));
}
}
