/// <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="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="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)); } }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">总记录数</param> /// <returns></returns> public static List <PEST_REPORT_DIEPINESURVEY_Model> getListModel(PEST_REPORT_DIEPINESURVEY_SW sw, out int total) { var result = new List <PEST_REPORT_DIEPINESURVEY_Model>(); DataTable dt = BaseDT.PEST_REPORT_DIEPINESURVEY.getDT(sw, out total); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 for (int i = 0; i < dt.Rows.Count; i++) { PEST_REPORT_DIEPINESURVEY_Model m = new PEST_REPORT_DIEPINESURVEY_Model(); m.PEST_REPORT_DIEPINESURVEYID = dt.Rows[i]["PEST_REPORT_DIEPINESURVEYID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.FINDER = dt.Rows[i]["FINDER"].ToString(); m.FINDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FINDDATE"].ToString()); m.LINKTELL = dt.Rows[i]["LINKTELL"].ToString(); m.DIEPINECOUNT = dt.Rows[i]["DIEPINECOUNT"].ToString(); m.REPORTDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["REPORTDATE"].ToString()); m.SAMPLINGCOUNT = dt.Rows[i]["SAMPLINGCOUNT"].ToString(); m.AUTHENTICATERESULT = dt.Rows[i]["AUTHENTICATERESULT"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(result); }
/// <summary> /// 获取单条数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns></returns> public static PEST_REPORT_DIEPINESURVEY_Model getModel(PEST_REPORT_DIEPINESURVEY_SW sw) { DataTable dt = BaseDT.PEST_REPORT_DIEPINESURVEY.getDT(sw); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 PEST_REPORT_DIEPINESURVEY_Model m = new PEST_REPORT_DIEPINESURVEY_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.PEST_REPORT_DIEPINESURVEYID = dt.Rows[i]["PEST_REPORT_DIEPINESURVEYID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.FINDER = dt.Rows[i]["FINDER"].ToString(); m.FINDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FINDDATE"].ToString()); m.LINKTELL = dt.Rows[i]["LINKTELL"].ToString(); m.DIEPINECOUNT = dt.Rows[i]["DIEPINECOUNT"].ToString(); m.REPORTDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["REPORTDATE"].ToString()); m.SAMPLINGCOUNT = dt.Rows[i]["SAMPLINGCOUNT"].ToString(); m.AUTHENTICATERESULT = dt.Rows[i]["AUTHENTICATERESULT"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(m); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型T_ALL_AREA_Model</param> /// <returns>参见模型Message</returns> public static Message Manager(PEST_REPORT_DIEPINESURVEY_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_REPORT_DIEPINESURVEY.Add(m); if (msg.Success == false) { return(new Message(msg.Success, msg.Msg, "")); } msg.Msg = msg.Msg + "," + BaseDT.PEST_REPORT_DIEPINESURVEY.GetMaxID(); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Mdy") { Message msg = BaseDT.PEST_REPORT_DIEPINESURVEY.Mdy(m); if (msg.Success == false) { return(new Message(msg.Success, msg.Msg, "")); } msg.Msg = msg.Msg + "," + BaseDT.PEST_REPORT_DIEPINESURVEY.GetMaxID(); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Del") { return(BaseDT.PEST_REPORT_DIEPINESURVEY.Del(m)); } return(new Message(false, "无效操作", m.returnUrl)); }