/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_LOCALPESTJOIN_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_LOCALPESTJOIN.Add(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } else if (m.opMethod == "Del") { Message msg = BaseDT.PEST_LOCALPESTJOIN.Del(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } return(new Message(false, "无效操作!", "")); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_LOCALPESTJOIN_Model m) { List <string> sqllist = new List <string>(); string[] arrPESTBYCODE = m.PESTBYCODE.Split(','); StringBuilder sbInsert = new StringBuilder(); if (arrPESTBYCODE.Length > 0) { sbInsert.AppendFormat("INSERT INTO PEST_LOCALPESTJOIN(BYORGNO, PESTBYCODE, SEARCHTYPE) "); for (int i = 0; i < arrPESTBYCODE.Length; i++) { if (!isExists(new PEST_LOCALPESTJOIN_SW { BYORGNO = m.BYORGNO, SEARCHTYPE = m.SEARCHTYPE, PESTBYCODE = arrPESTBYCODE[i] })) { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrPESTBYCODE[i])); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SEARCHTYPE)); sbInsert.AppendFormat(" UNION ALL "); } } string insertStr = sbInsert.ToString(); if (insertStr.Contains(" UNION ALL ")) { insertStr = insertStr.Substring(0, insertStr.Length - 10); sqllist.Add(insertStr); } } var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y > 0) { return(new Message(true, "添加成功!", "")); } else if (y == 0) { return(new Message(true, "该生物已关联!", "")); } else { return(new Message(false, "添加失败,事物回滚!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(PEST_LOCALPESTJOIN_Model m) { List <string> sqllist = new List <string>(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("Delete From PEST_LOCALPESTJOIN WHERE 1=1 "); sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(" AND SEARCHTYPE = '{0}'", ClsSql.EncodeSql(m.SEARCHTYPE)); sb.AppendFormat(" AND PESTBYCODE IN ({0})", ClsSql.SwitchStrToSqlIn(m.PESTBYCODE)); sqllist.Add(sb.ToString()); var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y > 0) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,事物回滚!", "")); } }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <PEST_LOCALPESTJOIN_Model> getListModel(PEST_LOCALPESTJOIN_SW sw) { var result = new List <PEST_LOCALPESTJOIN_Model>(); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 DataTable dt123 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "123" }); //调查类型 DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); DataTable dt = BaseDT.PEST_LOCALPESTJOIN.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { PEST_LOCALPESTJOIN_Model m = new PEST_LOCALPESTJOIN_Model(); m.PEST_LOCALPESTJOINID = dt.Rows[i]["PEST_LOCALPESTJOINID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.PESTBYCODE = dt.Rows[i]["PESTBYCODE"].ToString(); m.PESTBYCODENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTBYCODE); m.PESTKECODE = m.PESTBYCODE.Substring(0, 10) + "0000"; m.PESTKENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTKECODE); m.PESTSHUCODE = m.PESTBYCODE.Substring(0, 12) + "00"; m.PESTSHUNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.PESTSHUCODE); m.SEARCHTYPE = dt.Rows[i]["SEARCHTYPE"].ToString(); m.SEARCHTYPENAME = BaseDT.T_SYS_DICT.getName(dt123, m.SEARCHTYPE); result.Add(m); } dtORG.Clear(); dtORG.Dispose(); dt123.Clear(); dt123.Dispose(); dtBiolo.Clear(); dtBiolo.Dispose(); dt.Clear(); dt.Dispose(); return(result); }