/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_LOCALTREESPECIES_Model getModel(PEST_LOCALTREESPECIES_SW sw) { DataTable dt = BaseDT.PEST_LOCALTREESPECIES.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()); PEST_LOCALTREESPECIES_Model m = new PEST_LOCALTREESPECIES_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.PEST_LOCALTREESPECIESID = dt.Rows[i]["PEST_LOCALTREESPECIESID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString(); m.TSPNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPCODE); m.TSPKECODE = m.TSPCODE.Substring(0, 10) + "0000"; m.TSPKENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPKECODE); m.TSPSHUCODE = m.TSPCODE.Substring(0, 12) + "00"; m.TSPSHUNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPSHUCODE); m.TSPAREA = dt.Rows[i]["TSPAREA"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); dtBiolo.Clear(); dtBiolo.Dispose(); return(m); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <PEST_LOCALTREESPECIES_Model> getListModel(PEST_LOCALTREESPECIES_SW sw) { var result = new List <PEST_LOCALTREESPECIES_Model>(); DataTable dt = BaseDT.PEST_LOCALTREESPECIES.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()); for (int i = 0; i < dt.Rows.Count; i++) { PEST_LOCALTREESPECIES_Model m = new PEST_LOCALTREESPECIES_Model(); m.PEST_LOCALTREESPECIESID = dt.Rows[i]["PEST_LOCALTREESPECIESID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString(); m.TSPNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPCODE); m.TSPKECODE = m.TSPCODE.Substring(0, 10) + "0000"; m.TSPKENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPKECODE); m.TSPSHUCODE = m.TSPCODE.Substring(0, 12) + "00"; m.TSPSHUNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.TSPSHUCODE); m.TSPAREA = dt.Rows[i]["TSPAREA"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); dtBiolo.Clear(); dtBiolo.Dispose(); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(PEST_LOCALTREESPECIES_Model m) { List <string> sqllist = new List <string>(); string[] arrId = m.PEST_LOCALTREESPECIESID.Split(','); string[] arrTSPAREA = m.TSPAREA.Split(','); if (arrId.Length > 1) { for (int i = 0; i < arrId.Length - 1; i++) { if (isExists(new PEST_LOCALTREESPECIES_SW { PEST_LOCALTREESPECIESID = arrId[i] })) { StringBuilder sbUpdate = new StringBuilder(); sbUpdate.AppendFormat("UPDATE PEST_LOCALTREESPECIES SET "); sbUpdate.AppendFormat(" TSPAREA={0}", ClsSql.saveNullField(arrTSPAREA[i])); sbUpdate.AppendFormat(" where PEST_LOCALTREESPECIESID= '{0}'", ClsSql.EncodeSql(arrId[i])); sqllist.Add(sbUpdate.ToString()); } } } var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚机制!", "")); } }
/// <summary> /// 根据编码获取面积列表 /// </summary> /// <param name="PESTCODE">生物编码</param> /// <returns></returns> public static IEnumerable <PEST_LOCALTREESPECIES_Model> getListAREA(string PESTCODE) { var result = new List <PEST_LOCALTREESPECIES_Model>(); DataTable dt = BaseDT.PEST_LOCALTREESPECIES.getAREADT(PESTCODE); for (int i = 0; i < dt.Rows.Count; i++) { PEST_LOCALTREESPECIES_Model m = new PEST_LOCALTREESPECIES_Model(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString(); m.TSPAREA = dt.Rows[i]["TSPAREA"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_LOCALTREESPECIES_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_LOCALTREESPECIES.Add(m); return(new Message(msg.Success, msg.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { Message msg = BaseDT.PEST_LOCALTREESPECIES.Mdy(m); return(new Message(msg.Success, msg.Msg, m.returnUrl)); } if (m.opMethod == "Del") { Message msg = BaseDT.PEST_LOCALTREESPECIES.Del(m); return(new Message(msg.Success, msg.Msg, m.returnUrl)); } return(new Message(false, "无效操作!", "")); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_LOCALTREESPECIES_Model m) { List <string> sqllist = new List <string>(); string[] arrTSPCODE = m.TSPCODE.Split(',');; StringBuilder sbInsert = new StringBuilder(); if (arrTSPCODE.Length > 0) { sbInsert.AppendFormat("INSERT INTO PEST_LOCALTREESPECIES(BYORGNO,TSPCODE) "); for (int i = 0; i < arrTSPCODE.Length; i++) { if (!isExists(new PEST_LOCALTREESPECIES_SW { BYORGNO = m.BYORGNO, TSPCODE = arrTSPCODE[i] })) { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrTSPCODE[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_LOCALTREESPECIES_Model m) { List <string> sqllist = new List <string>(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("Delete From PEST_LOCALTREESPECIES WHERE 1=1 "); sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(" AND TSPCODE IN ({0})", ClsSql.SwitchStrToSqlIn(m.TSPCODE)); sqllist.Add(sb.ToString()); var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y > 0) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,事物回滚!", "")); } }