/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.JKPZ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update JKPZ set "); strSql.Append("NSRSBH=@NSRSBH,"); strSql.Append("NSRMC=@NSRMC,"); strSql.Append("NSRSWJGDM=@NSRSWJGDM,"); strSql.Append("NSRSWJGMC=@NSRSWJGMC,"); strSql.Append("ZSSWJGDM=@ZSSWJGDM,"); strSql.Append("ZSSWJGMC=@ZSSWJGMC,"); strSql.Append("PZDYFS=@PZDYFS,"); strSql.Append("DYSJ=@DYSJ,"); strSql.Append("HJJE=@HJJE,"); strSql.Append("FWM=@FWM,"); strSql.Append("DZYZDATA=@DZYZDATA"); strSql.Append(" where JKPZXH=@JKPZXH "); SQLiteParameter[] parameters = { new SQLiteParameter("@JKPZXH", DbType.String, 15), new SQLiteParameter("@NSRSBH", DbType.String, 20), new SQLiteParameter("@NSRMC", DbType.String, 80), new SQLiteParameter("@NSRSWJGDM", DbType.String, 9), new SQLiteParameter("@NSRSWJGMC", DbType.String, 80), new SQLiteParameter("@ZSSWJGDM", DbType.String, 9), new SQLiteParameter("@ZSSWJGMC", DbType.String, 80), new SQLiteParameter("@PZDYFS", DbType.String, 20), new SQLiteParameter("@DYSJ", DbType.String, 20), new SQLiteParameter("@HJJE", DbType.Decimal, 9), new SQLiteParameter("@FWM", DbType.String, 35), new SQLiteParameter("@DZYZDATA", DbType.String, 80) }; parameters[0].Value = model.JKPZXH; parameters[1].Value = model.NSRSBH; parameters[2].Value = model.NSRMC; parameters[3].Value = model.NSRSWJGDM; parameters[4].Value = model.NSRSWJGMC; parameters[5].Value = model.ZSSWJGDM; parameters[6].Value = model.ZSSWJGMC; parameters[7].Value = model.PZDYFS; parameters[8].Value = model.DYSJ; parameters[9].Value = model.HJJE; parameters[10].Value = model.FWM; parameters[11].Value = model.DZYZDATA; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public tdps.Model.JKPZ GetModel(string JKPZXH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select JKPZXH,NSRSBH,NSRMC,NSRSWJGDM,NSRSWJGMC,ZSSWJGDM,ZSSWJGMC,PZDYFS,DYSJ,HJJE,FWM,DZYZDATA from JKPZ "); strSql.Append(" where JKPZXH=@JKPZXH "); SQLiteParameter[] parameters = { new SQLiteParameter("@JKPZXH", DbType.String, 50) }; parameters[0].Value = JKPZXH; tdps.Model.JKPZ model = new tdps.Model.JKPZ(); DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.JKPZXH = ds.Tables[0].Rows[0]["JKPZXH"].ToString(); model.NSRSBH = ds.Tables[0].Rows[0]["NSRSBH"].ToString(); model.NSRMC = ds.Tables[0].Rows[0]["NSRMC"].ToString(); model.NSRSWJGDM = ds.Tables[0].Rows[0]["NSRSWJGDM"].ToString(); model.NSRSWJGMC = ds.Tables[0].Rows[0]["NSRSWJGMC"].ToString(); model.ZSSWJGDM = ds.Tables[0].Rows[0]["ZSSWJGDM"].ToString(); model.ZSSWJGMC = ds.Tables[0].Rows[0]["ZSSWJGMC"].ToString(); model.PZDYFS = ds.Tables[0].Rows[0]["PZDYFS"].ToString(); model.DYSJ = ds.Tables[0].Rows[0]["DYSJ"].ToString(); if (ds.Tables[0].Rows[0]["HJJE"].ToString() != "") { model.HJJE = decimal.Parse(ds.Tables[0].Rows[0]["HJJE"].ToString()); } model.FWM = ds.Tables[0].Rows[0]["FWM"].ToString(); model.DZYZDATA = ds.Tables[0].Rows[0]["DZYZDATA"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.JKPZ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into JKPZ("); strSql.Append("JKPZXH,NSRSBH,NSRMC,NSRSWJGDM,NSRSWJGMC,ZSSWJGDM,ZSSWJGMC,PZDYFS,DYSJ,HJJE,FWM,DZYZDATA)"); strSql.Append(" values ("); strSql.Append("@JKPZXH,@NSRSBH,@NSRMC,@NSRSWJGDM,@NSRSWJGMC,@ZSSWJGDM,@ZSSWJGMC,@PZDYFS,@DYSJ,@HJJE,@FWM,@DZYZDATA)"); SQLiteParameter[] parameters = { new SQLiteParameter("@JKPZXH", DbType.String, 15), new SQLiteParameter("@NSRSBH", DbType.String, 20), new SQLiteParameter("@NSRMC", DbType.String, 80), new SQLiteParameter("@NSRSWJGDM", DbType.String, 9), new SQLiteParameter("@NSRSWJGMC", DbType.String, 80), new SQLiteParameter("@ZSSWJGDM", DbType.String, 9), new SQLiteParameter("@ZSSWJGMC", DbType.String, 80), new SQLiteParameter("@PZDYFS", DbType.String, 20), new SQLiteParameter("@DYSJ", DbType.String, 20), new SQLiteParameter("@HJJE", DbType.Decimal, 9), new SQLiteParameter("@FWM", DbType.String, 35), new SQLiteParameter("@DZYZDATA", DbType.String, 80) }; parameters[0].Value = model.JKPZXH; parameters[1].Value = model.NSRSBH; parameters[2].Value = model.NSRMC; parameters[3].Value = model.NSRSWJGDM; parameters[4].Value = model.NSRSWJGMC; parameters[5].Value = model.ZSSWJGDM; parameters[6].Value = model.ZSSWJGMC; parameters[7].Value = model.PZDYFS; parameters[8].Value = model.DYSJ; parameters[9].Value = model.HJJE; parameters[10].Value = model.FWM; parameters[11].Value = model.DZYZDATA; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }