/// <summary> /// 更新三维库危害等级 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHarmClass(PEST_HARMCLASS_Model m) { List <string> sqllist = new List <string>(); var arrBYORGNO = m.BYORGNO.Split(','); var arrHARMCLASS = m.HARMCLASS.Split(','); var arrDCDATE = m.DCDATE.Split(','); for (int i = 0; i < arrBYORGNO.Length - 1; i++) { if (ClsSql.EncodeSql(arrHARMCLASS[i]) != "") { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" UPDATE PESTHARMCLASS SET "); sb.AppendFormat(" HARMCLASS='{0}'", ClsSql.EncodeSql(arrHARMCLASS[i])); sb.AppendFormat(",DCDATE={0}", ClsSql.saveNullField(arrDCDATE[i])); sb.AppendFormat(" WHERE BYORGNO='{0}'", ClsSql.EncodeSql(arrBYORGNO[i])); sqllist.Add(sb.ToString()); } } var j = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (j >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚!", "")); } }
/// <summary> /// 危害等级导入 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message AddImport(PEST_HARMCLASS_Model m) { Message ms = null; StringBuilder sb = new StringBuilder(); sb.AppendFormat(" INSERT INTO PEST_HARMCLASS(DCDATE, BYORGNO, TOWNNAME, JD, WD, HARMCLASS)"); sb.AppendFormat(" VALUES("); sb.AppendFormat(" '{0}'", ClsSql.EncodeSql(m.DCDATE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.TOWNNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.WD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.HARMCLASS)); sb.AppendFormat(")"); List <string> sqllist = new List <string>(); sqllist.Add(sb.ToString()); var i = DataBaseClass.ExecuteSqlTran(sqllist); if (i > 0) { ms = new Message(true, "导入成功!", ""); } else { ms = new Message(false, "导入失败,事物回滚机制!", ""); } return(ms); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Manager(PEST_HARMCLASS_Model m) { Message msg = BaseDT.PEST_HARMCLASS.Save(m);//保存更新二维 if (msg.Success) { Message msgAce = BaseDT.PEST_HARMCLASS.UpdateAceHarmClass(m);//更新三维库 } return(new Message(msg.Success, msg.Msg, msg.Url)); }
/// <summary> /// 根据时间删除 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message DeleteByDCDATE(PEST_HARMCLASS_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" DELETE FROM PEST_HARMCLASS WHERE DCDATE='" + m.DCDATE + "'"); 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_HARMCLASS_Model getModel(PEST_HARMCLASS_SW sw) { PEST_HARMCLASS_Model m = new PEST_HARMCLASS_Model(); DataTable dt = BaseDT.PEST_HARMCLASS.getDT(sw); if (dt.Rows.Count > 0) { int i = 0; m.PEST_HARMCLASSID = dt.Rows[i]["PEST_HARMCLASSID"].ToString(); m.DCDATE = ClsSwitch.SwitDate(dt.Rows[i]["DCDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.HARMCLASS = dt.Rows[i]["HARMCLASS"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <PEST_HARMCLASS_Model> getListModel(PEST_HARMCLASS_SW sw) { var result = new List <PEST_HARMCLASS_Model>(); DataTable dt = BaseDT.PEST_HARMCLASS.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { PEST_HARMCLASS_Model m = new PEST_HARMCLASS_Model(); m.PEST_HARMCLASSID = dt.Rows[i]["PEST_HARMCLASSID"].ToString(); m.DCDATE = ClsSwitch.SwitDate(dt.Rows[i]["DCDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.HARMCLASS = dt.Rows[i]["HARMCLASS"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 更新三维库危害等级 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHarmClass_XZ(PEST_HARMCLASS_Model m) { Message ms = null; StringBuilder sb1 = new StringBuilder(); sb1.AppendFormat(" Update PESTHARMCLASS_XZ Set DValue={0}", ClsSql.EncodeSql(m.DValue)); sb1.AppendFormat(" Where NAME='{0}'", ClsSql.EncodeSql(m.Name)); List <string> sqllist = new List <string>(); sqllist.Add(sb1.ToString()); var i = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (i > 0) { ms = new Message(true, "更新成功!", ""); } else { ms = new Message(false, "更新失败,事物回滚机制!", ""); } return(ms); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Save(PEST_HARMCLASS_Model m) { List <string> sqllist = new List <string>(); string[] arrBYORGNO = m.BYORGNO.Split(','); string[] arrTOWNNAME = m.TOWNNAME.Split(','); string[] arrDCDATE = m.DCDATE.Split(','); string[] arrJD = m.JD.Split(','); string[] arrWD = m.WD.Split(','); string[] arrHARMCLASS = m.HARMCLASS.Split(','); if (arrBYORGNO.Length - 1 > 0) { #region 再更新 StringBuilder sbInsert = new StringBuilder(); sbInsert.AppendFormat(" INSERT INTO PEST_HARMCLASS(DCDATE, BYORGNO, TOWNNAME, JD, WD, HARMCLASS) "); for (int i = 0; i < arrBYORGNO.Length - 1; i++) { #region 更新 if (isExists(new PEST_HARMCLASS_SW { BYORGNO = arrBYORGNO[i], DCDATE = arrDCDATE[i] })) { StringBuilder sbUpdate = new StringBuilder(); sbUpdate.AppendFormat(" UPDATE PEST_HARMCLASS SET "); sbUpdate.AppendFormat(" JD={0}", ClsSql.saveNullField(arrJD[i])); sbUpdate.AppendFormat(",WD={0}", ClsSql.saveNullField(arrWD[i])); sbUpdate.AppendFormat(",HARMCLASS={0}", ClsSql.saveNullField(arrHARMCLASS[i])); sbUpdate.AppendFormat(" WHERE BYORGNO= '{0}'", ClsSql.EncodeSql(arrBYORGNO[i])); sbUpdate.AppendFormat(" AND DCDATE= '{0}'", ClsSql.EncodeSql(arrDCDATE[i])); sqllist.Add(sbUpdate.ToString()); } #endregion #region 添加 else { sbInsert.AppendFormat(" SELECT '{0}'", ClsSql.EncodeSql(arrDCDATE[i])); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrBYORGNO[i])); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrTOWNNAME[i])); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrJD[i])); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrWD[i])); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrHARMCLASS[i])); sbInsert.AppendFormat(" UNION ALL "); } #endregion } string insertStr = sbInsert.ToString(); if (insertStr.Contains(" UNION ALL ")) { insertStr = insertStr.Substring(0, insertStr.Length - 10); sqllist.Add(insertStr); } #endregion } var y = DataBaseClass.ExecuteSqlTran(sqllist); if (y >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚!", "")); } }
public static Message UpdateAceHarmClass(PEST_HARMCLASS_Model m) { return(BaseDT.PEST_HARMCLASS.UpdateAceHarmClass_XZ(m)); }
/// <summary> /// 导入数据 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message ImportData(PEST_HARMCLASS_Model m) { return(BaseDT.PEST_HARMCLASS.AddImport(m)); }
/// <summary> /// 删除火险等级 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message DeleteHarmClassData(PEST_HARMCLASS_Model m) { return(BaseDT.PEST_HARMCLASS.DeleteByDCDATE(m)); }