/// <summary> /// 得到一个对象实体 /// </summary> public tdps.Model.DM_PZZL GetModel(string pzzl_dm) { StringBuilder strSql = new StringBuilder(); strSql.Append("select pzzl_dm,pzzl_mc,swws_dm,yspz_dm from DM_PZZL "); strSql.Append(" where pzzl_dm=@pzzl_dm "); SQLiteParameter[] parameters = { new SQLiteParameter("@pzzl_dm", DbType.String, 10) }; parameters[0].Value = pzzl_dm; tdps.Model.DM_PZZL model = new tdps.Model.DM_PZZL(); DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.pzzl_dm = ds.Tables[0].Rows[0]["pzzl_dm"].ToString(); model.pzzl_mc = ds.Tables[0].Rows[0]["pzzl_mc"].ToString(); model.swws_dm = ds.Tables[0].Rows[0]["swws_dm"].ToString(); model.yspz_dm = ds.Tables[0].Rows[0]["yspz_dm"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.DM_PZZL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DM_PZZL("); strSql.Append("pzzl_dm,pzzl_mc,swws_dm,yspz_dm)"); strSql.Append(" values ("); strSql.Append("@pzzl_dm,@pzzl_mc,@swws_dm,@yspz_dm)"); SQLiteParameter[] parameters = { new SQLiteParameter("@pzzl_dm", DbType.String, 5), new SQLiteParameter("@pzzl_mc", DbType.String, 50), new SQLiteParameter("@swws_dm", DbType.String, 6), new SQLiteParameter("@yspz_dm", DbType.String, 3) }; parameters[0].Value = model.pzzl_dm; parameters[1].Value = model.pzzl_mc; parameters[2].Value = model.swws_dm; parameters[3].Value = model.yspz_dm; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.DM_PZZL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DM_PZZL set "); strSql.Append("pzzl_mc=@pzzl_mc,"); strSql.Append("swws_dm=@swws_dm,"); strSql.Append("yspz_dm=@yspz_dm"); strSql.Append(" where pzzl_dm=@pzzl_dm "); SQLiteParameter[] parameters = { new SQLiteParameter("@pzzl_dm", DbType.String, 5), new SQLiteParameter("@pzzl_mc", DbType.String, 50), new SQLiteParameter("@swws_dm", DbType.String, 6), new SQLiteParameter("@yspz_dm", DbType.String, 3) }; parameters[0].Value = model.pzzl_dm; parameters[1].Value = model.pzzl_mc; parameters[2].Value = model.swws_dm; parameters[3].Value = model.yspz_dm; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }