/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.NSRZJG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NSRZJG("); strSql.Append("nsrsbh,zjgNsrsbh,zjgMc,kjzg,LXDH,ND,SRZE,GZZE,ZCZE,HJ,QDZT)"); strSql.Append(" values ("); strSql.Append("@nsrsbh,@zjgNsrsbh,@zjgMc,@kjzg,@LXDH,@ND,@SRZE,@GZZE,@ZCZE,@HJ,@QDZT)"); 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), new SQLiteParameter("@QDZT", DbType.String, 1) }; 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; parameters[10].Value = model.QDZT; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public tdps.Model.NSRZJG GetModel(string nsrsbh) { StringBuilder strSql = new StringBuilder(); strSql.Append("select nsrsbh,zjgNsrsbh,zjgMc,kjzg,LXDH,ND,SRZE,GZZE,ZCZE,HJ,QDZT from NSRZJG "); strSql.Append(" where nsrsbh=@nsrsbh "); SQLiteParameter[] parameters = { new SQLiteParameter("@nsrsbh", DbType.String, 50) }; parameters[0].Value = nsrsbh; tdps.Model.NSRZJG model = new tdps.Model.NSRZJG(); DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.nsrsbh = ds.Tables[0].Rows[0]["nsrsbh"].ToString(); model.zjgNsrsbh = ds.Tables[0].Rows[0]["zjgNsrsbh"].ToString(); model.zjgMc = ds.Tables[0].Rows[0]["zjgMc"].ToString(); model.kjzg = ds.Tables[0].Rows[0]["kjzg"].ToString(); model.LXDH = ds.Tables[0].Rows[0]["LXDH"].ToString(); model.ND = ds.Tables[0].Rows[0]["ND"].ToString(); if (ds.Tables[0].Rows[0]["SRZE"].ToString() != "") { model.SRZE = decimal.Parse(ds.Tables[0].Rows[0]["SRZE"].ToString()); } if (ds.Tables[0].Rows[0]["GZZE"].ToString() != "") { model.GZZE = decimal.Parse(ds.Tables[0].Rows[0]["GZZE"].ToString()); } if (ds.Tables[0].Rows[0]["ZCZE"].ToString() != "") { model.ZCZE = decimal.Parse(ds.Tables[0].Rows[0]["ZCZE"].ToString()); } if (ds.Tables[0].Rows[0]["HJ"].ToString() != "") { model.HJ = decimal.Parse(ds.Tables[0].Rows[0]["HJ"].ToString()); } model.QDZT = ds.Tables[0].Rows[0]["QDZT"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.NSRZJG model) { 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("QDZT=@QDZT"); strSql.Append(" where nsrsbh=@nsrsbh "); 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), new SQLiteParameter("@QDZT", DbType.String, 1) }; 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; parameters[10].Value = model.QDZT; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }