/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型PEST_REPORT_HAPPEN_SW</param> /// <returns>参见模型PEST_REPORT_HAPPEN_Model</returns> public static IEnumerable <PEST_REPORT_RCW_Model> getListModel(PEST_REPORT_RCW_SW sw) { var result = new List <PEST_REPORT_RCW_Model>(); DataTable dt = BaseDT.PEST_REPORT_RCW.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { PEST_REPORT_RCW_Model m = new PEST_REPORT_RCW_Model(); m.PEST_REPORT_RCWID = dt.Rows[i]["PEST_REPORT_RCWID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.RCWYEAR = dt.Rows[i]["RCWYEAR"].ToString(); m.RCWCODE = dt.Rows[i]["RCWCODE"].ToString(); m.RCWVALUE = dt.Rows[i]["RCWVALUE"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_REPORT_RCW_Model getModel(PEST_REPORT_RCW_SW sw) { DataTable dt = BaseDT.PEST_REPORT_RCW.getDT(sw); PEST_REPORT_RCW_Model m = new PEST_REPORT_RCW_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.PEST_REPORT_RCWID = dt.Rows[i]["PEST_REPORT_RCWID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.RCWYEAR = dt.Rows[i]["RCWYEAR"].ToString(); m.RCWCODE = dt.Rows[i]["RCWCODE"].ToString(); m.RCWVALUE = dt.Rows[i]["RCWVALUE"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Save(PEST_REPORT_RCW_Model m) { List <string> sqllist = new List <string>(); string[] arrRCWCODE = m.RCWCODE.Split(','); string[] arrRCWVALUE = m.RCWVALUE.Split(','); if (arrRCWCODE.Length - 1 > 0) { #region 先删除 string sql = "delete from PEST_REPORT_RCW where BYORGNO='" + m.BYORGNO + "' and RCWYEAR='" + m.RCWYEAR + "'"; DataBaseClass.ExeSql(sql); #endregion #region 再更新 StringBuilder sbInsert = new StringBuilder(); sbInsert.AppendFormat("INSERT INTO PEST_REPORT_RCW(BYORGNO, RCWYEAR, RCWCODE, RCWVALUE)"); for (int i = 0; i < arrRCWCODE.Length - 1; i++) { #region 更新 if (isExists(new PEST_REPORT_RCW_SW { BYORGNO = m.BYORGNO, RCWYEAR = m.RCWYEAR })) { StringBuilder sbUpdate = new StringBuilder(); sbUpdate.AppendFormat("UPDATE PEST_REPORT_RCW SET "); sbUpdate.AppendFormat(" RCWVALUE='{0}',", ClsSql.saveNullField(arrRCWVALUE[i])); sbUpdate.AppendFormat(" where BYORGNO= '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sbUpdate.AppendFormat(" and RCWYEAR= '{0}'", ClsSql.EncodeSql(m.RCWYEAR)); sbUpdate.AppendFormat(" and RCWCODE= '{0}'", ClsSql.EncodeSql(arrRCWCODE[i])); sqllist.Add(sbUpdate.ToString()); } #endregion #region 添加 else { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(m.BYORGNO)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.RCWYEAR));; sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrRCWCODE[i])); sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrRCWVALUE[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, "保存失败,事物回滚机制!", "")); } }
/// <summary> /// 保存 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_REPORT_RCW_Model m) { return(BaseDT.PEST_REPORT_RCW.Save(m)); }