/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.DM_GJ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DM_GJ("); strSql.Append("gj_dm,gj_mc,gj_jc,xybz,gj_mc_yw,gj_jc_yw,gj_jc_yw2,gj_jc_yw3)"); strSql.Append(" values ("); strSql.Append("@gj_dm,@gj_mc,@gj_jc,@xybz,@gj_mc_yw,@gj_jc_yw,@gj_jc_yw2,@gj_jc_yw3)"); SQLiteParameter[] parameters = { new SQLiteParameter("@gj_dm", DbType.String, 3), new SQLiteParameter("@gj_mc", DbType.String, 40), new SQLiteParameter("@gj_jc", DbType.String, 30), new SQLiteParameter("@xybz", DbType.String, 1), new SQLiteParameter("@gj_mc_yw", DbType.String, 70), new SQLiteParameter("@gj_jc_yw", DbType.String, 70), new SQLiteParameter("@gj_jc_yw2", DbType.String, 2), new SQLiteParameter("@gj_jc_yw3", DbType.String, 3) }; parameters[0].Value = model.gj_dm; parameters[1].Value = model.gj_mc; parameters[2].Value = model.gj_jc; parameters[3].Value = model.xybz; parameters[4].Value = model.gj_mc_yw; parameters[5].Value = model.gj_jc_yw; parameters[6].Value = model.gj_jc_yw2; parameters[7].Value = model.gj_jc_yw3; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.DM_GJ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DM_GJ set "); strSql.Append("gj_mc=@gj_mc,"); strSql.Append("gj_jc=@gj_jc,"); strSql.Append("xybz=@xybz,"); strSql.Append("gj_mc_yw=@gj_mc_yw,"); strSql.Append("gj_jc_yw=@gj_jc_yw,"); strSql.Append("gj_jc_yw2=@gj_jc_yw2,"); strSql.Append("gj_jc_yw3=@gj_jc_yw3"); strSql.Append(" where gj_dm=@gj_dm "); SQLiteParameter[] parameters = { new SQLiteParameter("@gj_dm", DbType.String, 3), new SQLiteParameter("@gj_mc", DbType.String, 40), new SQLiteParameter("@gj_jc", DbType.String, 30), new SQLiteParameter("@xybz", DbType.String, 1), new SQLiteParameter("@gj_mc_yw", DbType.String, 70), new SQLiteParameter("@gj_jc_yw", DbType.String, 70), new SQLiteParameter("@gj_jc_yw2", DbType.String, 2), new SQLiteParameter("@gj_jc_yw3", DbType.String, 3) }; parameters[0].Value = model.gj_dm; parameters[1].Value = model.gj_mc; parameters[2].Value = model.gj_jc; parameters[3].Value = model.xybz; parameters[4].Value = model.gj_mc_yw; parameters[5].Value = model.gj_jc_yw; parameters[6].Value = model.gj_jc_yw2; parameters[7].Value = model.gj_jc_yw3; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public tdps.Model.DM_GJ GetModel(string gj_dm) { StringBuilder strSql = new StringBuilder(); strSql.Append("select gj_dm,gj_mc,gj_jc,xybz,gj_mc_yw,gj_jc_yw,gj_jc_yw2,gj_jc_yw3 from DM_GJ "); strSql.Append(" where gj_dm=@gj_dm "); SQLiteParameter[] parameters = { new SQLiteParameter("@gj_dm", DbType.String, 50) }; parameters[0].Value = gj_dm; tdps.Model.DM_GJ model = new tdps.Model.DM_GJ(); DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.gj_dm = ds.Tables[0].Rows[0]["gj_dm"].ToString(); model.gj_mc = ds.Tables[0].Rows[0]["gj_mc"].ToString(); model.gj_jc = ds.Tables[0].Rows[0]["gj_jc"].ToString(); model.xybz = ds.Tables[0].Rows[0]["xybz"].ToString(); model.gj_mc_yw = ds.Tables[0].Rows[0]["gj_mc_yw"].ToString(); model.gj_jc_yw = ds.Tables[0].Rows[0]["gj_jc_yw"].ToString(); model.gj_jc_yw2 = ds.Tables[0].Rows[0]["gj_jc_yw2"].ToString(); model.gj_jc_yw3 = ds.Tables[0].Rows[0]["gj_jc_yw3"].ToString(); return(model); } else { return(null); } }