/// <summary> /// 获得数据列表 /// </summary> public List <tdps.Model.NSRZJG> DataTableToList(DataTable dt) { List <tdps.Model.NSRZJG> modelList = new List <tdps.Model.NSRZJG>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { tdps.Model.NSRZJG model; for (int n = 0; n < rowsCount; n++) { model = new tdps.Model.NSRZJG(); model.nsrsbh = dt.Rows[n]["nsrsbh"].ToString(); model.zjgNsrsbh = dt.Rows[n]["zjgNsrsbh"].ToString(); model.zjgMc = dt.Rows[n]["zjgMc"].ToString(); model.kjzg = dt.Rows[n]["kjzg"].ToString(); model.LXDH = dt.Rows[n]["LXDH"].ToString(); model.ND = dt.Rows[n]["ND"].ToString(); if (dt.Rows[n]["SRZE"].ToString() != "") { model.SRZE = decimal.Parse(dt.Rows[n]["SRZE"].ToString()); } if (dt.Rows[n]["GZZE"].ToString() != "") { model.GZZE = decimal.Parse(dt.Rows[n]["GZZE"].ToString()); } if (dt.Rows[n]["ZCZE"].ToString() != "") { model.ZCZE = decimal.Parse(dt.Rows[n]["ZCZE"].ToString()); } if (dt.Rows[n]["HJ"].ToString() != "") { model.HJ = decimal.Parse(dt.Rows[n]["HJ"].ToString()); } if (dt.Rows[n]["QDZT"].ToString() != "") { model.QDZT = dt.Rows[n]["QDZT"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(tdps.Model.NSRZJG model, object trans) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NSRZJG set "); strSql.Append("zjgNsrsbh=@zjgNsrsbh,"); strSql.Append("zjgMc=@zjgMc,"); strSql.Append("kjzg=@kjzg,"); strSql.Append("LXDH=@LXDH,"); strSql.Append("ND=@ND,"); strSql.Append("SRZE=@SRZE,"); strSql.Append("GZZE=@GZZE,"); strSql.Append("ZCZE=@ZCZE,"); strSql.Append("HJ=@HJ"); strSql.Append(" where zjgnsrsbh=@nsrsbh and ND=@ND"); SQLiteParameter[] parameters = { new SQLiteParameter("@nsrsbh", DbType.String, 20), new SQLiteParameter("@zjgNsrsbh", DbType.String, 20), new SQLiteParameter("@zjgMc", DbType.String, 80), new SQLiteParameter("@kjzg", DbType.String, 20), new SQLiteParameter("@LXDH", DbType.String, 20), new SQLiteParameter("@ND", DbType.String, 4), new SQLiteParameter("@SRZE", DbType.Decimal, 9), new SQLiteParameter("@GZZE", DbType.Decimal, 9), new SQLiteParameter("@ZCZE", DbType.Decimal, 9), new SQLiteParameter("@HJ", DbType.Decimal, 9) }; parameters[0].Value = model.nsrsbh; parameters[1].Value = model.zjgNsrsbh; parameters[2].Value = model.zjgMc; parameters[3].Value = model.kjzg; parameters[4].Value = model.LXDH; parameters[5].Value = model.ND; parameters[6].Value = model.SRZE; parameters[7].Value = model.GZZE; parameters[8].Value = model.ZCZE; parameters[9].Value = model.HJ; return(SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.NSRZJG model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.NSRZJG model) { dal.Add(model); }