/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型PEST_COLLECTDATA_Model</param>
/// <returns>参见模型Message</returns>
public static Message Manager(PEST_COLLECTDATA_Model m)
{
if (m.opMethod == "Add")
{
Message msg = BaseDT.PEST_COLLECTDATA.Add(m);
if (msg.Success == false)
{
return(new Message(msg.Success, msg.Msg, ""));
}
msg.Msg = msg.Msg + "," + m.KID;
return(new Message(msg.Success, msg.Msg, msg.Url));
}
if (m.opMethod == "Mdy")
{
Message msg = BaseDT.PEST_COLLECTDATA.Mdy(m);
if (msg.Success == false)
{
return(new Message(msg.Success, msg.Msg, ""));
}
msg.Msg = msg.Msg + "," + m.KID;
return(new Message(msg.Success, msg.Msg, msg.Url));
}
if (m.opMethod == "Del")
{
Message msg = BaseDT.PEST_COLLECTDATA.Del(m);
return(new Message(msg.Success, msg.Msg, msg.Url));
}
return(new Message(false, "无效操作!", m.returnUrl));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(PEST_COLLECTDATA_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO PEST_COLLECTDATA(HID, BYORGNO, COLLECTRESOURCE, VILLAGENAME, SMALLADDRESS, SMALLCLASSCODE, SMALLCLASSAREA,");
sb.AppendFormat("HOSTTREESPECIESCODE, SEARCHTYPE, COLLECTPESTCODE, HARMPOSITION, HARMLEVEL, DEADCOUNT, UNKNOWNDIEOFFCOUNT ,");
sb.AppendFormat("ELSEDIEOFFCOUNT, SAMPLECOUNT, MARK, UPLOADTIME, MANSTATE, MANRESULT, MANTIME, MANUSERID, KID, JWDLIST) ");
sb.AppendFormat(" OUTPUT INSERTED.PESTCOLLDATAID ");
sb.AppendFormat(" VALUES(");
sb.AppendFormat(" '{0}'", ClsSql.EncodeSql(m.HID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.COLLECTRESOURCE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.VILLAGENAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SMALLADDRESS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SMALLCLASSCODE));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.SMALLCLASSAREA));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.HOSTTREESPECIESCODE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SEARCHTYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.COLLECTPESTCODE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.HARMPOSITION));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.HARMLEVEL));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.DEADCOUNT));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.UNKNOWNDIEOFFCOUNT));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.ELSEDIEOFFCOUNT));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.SAMPLECOUNT));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.MARK));
sb.AppendFormat(",'{0}'", m.UPLOADTIME);
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.MANSTATE));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.MANRESULT));
sb.AppendFormat(",'{0}'", m.MANTIME);
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.MANUSERID));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.KID));
sb.AppendFormat(", {0}", ClsSql.saveNullField(m.JWDLIST));
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, "添加失败!", ""));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(PEST_COLLECTDATA_Model m)
{
if (isExists(new PEST_COLLECTDATA_SW {
PESTCOLLDATAID = m.PESTCOLLDATAID
}) == false)
{
return(new Message(false, "修改失败,采集数据不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Update PEST_COLLECTDATA SET ");
sb.AppendFormat(" HID='{0}'", ClsSql.EncodeSql(m.HID));
sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",COLLECTRESOURCE='{0}'", ClsSql.EncodeSql(m.COLLECTRESOURCE));
sb.AppendFormat(",VILLAGENAME='{0}'", ClsSql.EncodeSql(m.VILLAGENAME));
sb.AppendFormat(",SMALLADDRESS='{0}'", ClsSql.EncodeSql(m.SMALLADDRESS));
sb.AppendFormat(",SMALLCLASSCODE='{0}'", ClsSql.EncodeSql(m.SMALLCLASSCODE));
sb.AppendFormat(",SMALLCLASSAREA={0}", ClsSql.saveNullField(m.SMALLCLASSAREA));
sb.AppendFormat(",HOSTTREESPECIESCODE='{0}'", ClsSql.EncodeSql(m.HOSTTREESPECIESCODE));
sb.AppendFormat(",SEARCHTYPE='{0}'", ClsSql.EncodeSql(m.SEARCHTYPE));
sb.AppendFormat(",COLLECTPESTCODE='{0}'", ClsSql.EncodeSql(m.COLLECTPESTCODE));
sb.AppendFormat(",HARMPOSITION='{0}'", ClsSql.EncodeSql(m.HARMPOSITION));
sb.AppendFormat(",HARMLEVEL='{0}'", ClsSql.EncodeSql(m.HARMLEVEL));
sb.AppendFormat(",DEADCOUNT={0}", ClsSql.saveNullField(m.DEADCOUNT));
sb.AppendFormat(",UNKNOWNDIEOFFCOUNT={0}", ClsSql.saveNullField(m.UNKNOWNDIEOFFCOUNT));
sb.AppendFormat(",ELSEDIEOFFCOUNT={0}", ClsSql.saveNullField(m.ELSEDIEOFFCOUNT));
sb.AppendFormat(",SAMPLECOUNT={0}", ClsSql.saveNullField(m.SAMPLECOUNT));
sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK));
sb.AppendFormat(",MANSTATE='{0}'", ClsSql.EncodeSql(m.MANSTATE));
sb.AppendFormat(",MANRESULT={0}", ClsSql.saveNullField(m.MANRESULT));
sb.AppendFormat(",MANTIME='{0}'", m.MANTIME);
sb.AppendFormat(",MANUSERID='{0}'", ClsSql.EncodeSql(m.MANUSERID));
sb.AppendFormat(",KID={0}", ClsSql.saveNullField(m.KID));
sb.AppendFormat(",JWDLIST={0}", ClsSql.saveNullField(m.JWDLIST));
sb.AppendFormat(" WHERE PESTCOLLDATAID= '{0}'", ClsSql.EncodeSql(m.PESTCOLLDATAID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", m.PESTCOLLDATAID));
}
else
{
return(new Message(false, "修改失败!", ""));
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(PEST_COLLECTDATA_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete from PEST_COLLECTDATA ");
sb.AppendFormat(" WHERE PESTCOLLDATAID= '{0}'", ClsSql.EncodeSql(m.PESTCOLLDATAID));
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 PEST_COLLECTDATA_Model getModel(PEST_COLLECTDATA_SW sw)
{
DataTable dt = BaseDT.PEST_COLLECTDATA.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); //生物类别
DataTable dt55 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "55"
}); //危害部位
DataTable dt56 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "56"
}); //危害程度
DataTable dt57 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "57"
}); //处理状态
DataTable dt123 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "123"
}); //调查类型
PEST_COLLECTDATA_Model m = new PEST_COLLECTDATA_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.PESTCOLLDATAID = dt.Rows[i]["PESTCOLLDATAID"].ToString();
m.HID = dt.Rows[i]["HID"].ToString();
m.COLLECTRESOURCE = dt.Rows[i]["COLLECTRESOURCE"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.VILLAGENAME = dt.Rows[i]["VILLAGENAME"].ToString();
m.SMALLADDRESS = dt.Rows[i]["SMALLADDRESS"].ToString();
m.SMALLCLASSCODE = dt.Rows[i]["SMALLCLASSCODE"].ToString();
m.SMALLCLASSAREA = dt.Rows[i]["SMALLCLASSAREA"].ToString();
m.HOSTTREESPECIESCODE = dt.Rows[i]["HOSTTREESPECIESCODE"].ToString();
m.HOSTTREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.HOSTTREESPECIESCODE);
m.SEARCHTYPE = dt.Rows[i]["SEARCHTYPE"].ToString();
m.SEARCHTYPENAME = BaseDT.T_SYS_DICT.getName(dt123, m.SEARCHTYPE);
m.COLLECTPESTCODE = dt.Rows[i]["COLLECTPESTCODE"].ToString();
m.COLLECTPESTNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.COLLECTPESTCODE);
m.HARMPOSITION = dt.Rows[i]["HARMPOSITION"].ToString();
m.HARMPOSITIONNAME = BaseDT.T_SYS_DICT.getName(dt55, m.HARMPOSITION);
m.HARMLEVEL = dt.Rows[i]["HARMLEVEL"].ToString();
m.HARMLEVELNAME = BaseDT.T_SYS_DICT.getName(dt56, m.HARMPOSITION);
m.DEADCOUNT = dt.Rows[i]["DEADCOUNT"].ToString();
m.UNKNOWNDIEOFFCOUNT = dt.Rows[i]["UNKNOWNDIEOFFCOUNT"].ToString();
m.ELSEDIEOFFCOUNT = dt.Rows[i]["ELSEDIEOFFCOUNT"].ToString();
m.SAMPLECOUNT = dt.Rows[i]["SAMPLECOUNT"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.UPLOADTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["UPLOADTIME"].ToString());
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANSTATENAME = BaseDT.T_SYS_DICT.getName(dt57, m.MANSTATE);
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
m.KID = dt.Rows[i]["KID"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
dt55.Clear();
dt55.Dispose();
dt56.Clear();
dt56.Dispose();
dt57.Clear();
dt57.Dispose();
return(m);
}
/// <summary>
/// 分页获取用户列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <PEST_COLLECTDATA_Model> getModeList(PEST_COLLECTDATA_SW sw, out int total)
{
var result = new List <PEST_COLLECTDATA_Model>();
DataTable dt = BaseDT.PEST_COLLECTDATA.getDT(sw, out total);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); //生物类别
DataTable dt102 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "102"
}); //危害部位
DataTable dt103 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "103"
}); //危害程度
DataTable dt104 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "104"
}); //处理状态
DataTable dt123 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "123"
}); //调查类型
for (int i = 0; i < dt.Rows.Count; i++)
{
PEST_COLLECTDATA_Model m = new PEST_COLLECTDATA_Model();
m.PESTCOLLDATAID = dt.Rows[i]["PESTCOLLDATAID"].ToString();
m.HID = dt.Rows[i]["HID"].ToString();
m.COLLECTRESOURCE = dt.Rows[i]["COLLECTRESOURCE"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.VILLAGENAME = dt.Rows[i]["VILLAGENAME"].ToString();
m.SMALLADDRESS = dt.Rows[i]["SMALLADDRESS"].ToString();
m.SMALLCLASSCODE = dt.Rows[i]["SMALLCLASSCODE"].ToString();
m.SMALLCLASSAREA = dt.Rows[i]["SMALLCLASSAREA"].ToString();
m.HOSTTREESPECIESCODE = dt.Rows[i]["HOSTTREESPECIESCODE"].ToString();
m.HOSTTREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.HOSTTREESPECIESCODE);
m.SEARCHTYPE = dt.Rows[i]["SEARCHTYPE"].ToString();
m.SEARCHTYPENAME = BaseDT.T_SYS_DICT.getName(dt123, m.SEARCHTYPE);
m.COLLECTPESTCODE = dt.Rows[i]["COLLECTPESTCODE"].ToString();
m.COLLECTPESTNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.COLLECTPESTCODE);
m.HARMPOSITION = dt.Rows[i]["HARMPOSITION"].ToString();
m.HARMPOSITIONNAME = BaseDT.T_SYS_DICT.getName(dt102, m.HARMPOSITION);
m.HARMLEVEL = dt.Rows[i]["HARMLEVEL"].ToString();
m.HARMLEVELNAME = BaseDT.T_SYS_DICT.getName(dt103, m.HARMPOSITION);
m.DEADCOUNT = dt.Rows[i]["DEADCOUNT"].ToString();
m.UNKNOWNDIEOFFCOUNT = dt.Rows[i]["UNKNOWNDIEOFFCOUNT"].ToString();
m.ELSEDIEOFFCOUNT = dt.Rows[i]["ELSEDIEOFFCOUNT"].ToString();
m.SAMPLECOUNT = dt.Rows[i]["SAMPLECOUNT"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.UPLOADTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["UPLOADTIME"].ToString());
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANSTATENAME = BaseDT.T_SYS_DICT.getName(dt104, m.MANSTATE);
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
m.KID = dt.Rows[i]["KID"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
dt102.Clear();
dt102.Dispose();
dt103.Clear();
dt103.Dispose();
dt104.Clear();
dt104.Dispose();
dt123.Clear();
dt123.Dispose();
return(result);
}
