/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <PEST_TREESPECIES_PEST_Model> getListModel(PEST_TREESPECIES_PEST_SW sw) { var result = new List <PEST_TREESPECIES_PEST_Model>(); DataTable dt = BaseDT.PEST_TREESPECIES_PEST.getDT(sw); DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); for (int i = 0; i < dt.Rows.Count; i++) { PEST_TREESPECIES_PEST_Model m = new PEST_TREESPECIES_PEST_Model(); m.PEST_TREESPECIES_PESTID = dt.Rows[i]["PEST_TREESPECIES_PESTID"].ToString(); m.TREESPECIESCODE = dt.Rows[i]["TREESPECIESCODE"].ToString(); m.TREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TREESPECIESCODE); m.PESTBYCODE = dt.Rows[i]["PESTBYCODE"].ToString(); m.PESTBYNAME = 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); result.Add(m); } dt.Clear(); dt.Dispose(); dtBiolo.Clear(); dtBiolo.Dispose(); return(result); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_TREESPECIES_PEST_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_TREESPECIES_PEST.Add(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } else if (m.opMethod == "Del") { Message msg = BaseDT.PEST_TREESPECIES_PEST.Del(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } return(new Message(false, "无效操作!", "")); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_TREESPECIES_PEST_Model getModel(PEST_TREESPECIES_PEST_SW sw) { DataTable dt = BaseDT.PEST_TREESPECIES_PEST.getDT(sw); PEST_TREESPECIES_PEST_Model m = new PEST_TREESPECIES_PEST_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.PEST_TREESPECIES_PESTID = dt.Rows[i]["PEST_TREESPECIES_PESTID"].ToString(); m.TREESPECIESCODE = dt.Rows[i]["TREESPECIESCODE"].ToString(); m.PESTBYCODE = dt.Rows[i]["PESTBYCODE"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_TREESPECIES_PEST_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_TREESPECIES_PEST(TREESPECIESCODE, PESTBYCODE) "); for (int i = 0; i < arrPESTBYCODE.Length; i++) { if (!isExists(new PEST_TREESPECIES_PEST_SW { TREESPECIESCODE = m.TREESPECIESCODE, PESTBYCODE = arrPESTBYCODE[i] })) { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(m.TREESPECIESCODE)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrPESTBYCODE[i])); 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_TREESPECIES_PEST_Model m) { List <string> sqllist = new List <string>(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("Delete From PEST_TREESPECIES_PEST WHERE 1=1 "); sb.AppendFormat(" AND TREESPECIESCODE = '{0}'", ClsSql.EncodeSql(m.TREESPECIESCODE)); 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, "删除失败,事物回滚!", "")); } }