/// <summary> /// 更新一条数据 /// </summary> public void Update(ERM.MDL.PageSize model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PageSize set "); strSql.Append("IsDefault=" + model.IsDefault + ","); strSql.Append("Pages=" + model.Pages + ","); strSql.Append("Pfloat=" + model.Pfloat + ","); strSql.Append("PID=" + model.PID + ","); strSql.Append("PTYPE='" + model.PTYPE + "'"); strSql.Append(" where PID=" + model.PID + " "); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
private void frmPageSizeDetail_Load(object sender, EventArgs e) { if (pid.HasValue) { model_PageSize = new ERM.BLL.PageSize().Find((int)pid); numPages.Value = model_PageSize.Pages; numPfloat.Value = model_PageSize.Pfloat; txtptype.Text = model_PageSize.PTYPE; if (model_PageSize.IsDefault == 1) { chIsDefault.Checked = true; _IsDefault = true; } else { chIsDefault.Checked = false; } } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ERM.MDL.PageSize model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.IsDefault != null) { strSql1.Append("IsDefault,"); strSql2.Append("" + model.IsDefault + ","); } if (model.Pages != null) { strSql1.Append("Pages,"); strSql2.Append("" + model.Pages + ","); } if (model.Pfloat != null) { strSql1.Append("Pfloat,"); strSql2.Append("" + model.Pfloat + ","); } if (model.PID != null) { strSql1.Append("PID,"); strSql2.Append("" + model.PID + ","); } if (model.PTYPE != null) { strSql1.Append("PTYPE,"); strSql2.Append("'" + model.PTYPE + "',"); } strSql.Append("insert into PageSize("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERM.MDL.PageSize Find(int PID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" IsDefault,Pages,Pfloat,PID,PTYPE "); strSql.Append(" from PageSize "); strSql.Append(" where PID=" + PID + " "); ERM.MDL.PageSize model = new ERM.MDL.PageSize(); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["IsDefault"].ToString() != "") { model.IsDefault = int.Parse(ds.Tables[0].Rows[0]["IsDefault"].ToString()); } if (ds.Tables[0].Rows[0]["Pages"].ToString() != "") { model.Pages = int.Parse(ds.Tables[0].Rows[0]["Pages"].ToString()); } if (ds.Tables[0].Rows[0]["Pfloat"].ToString() != "") { model.Pfloat = int.Parse(ds.Tables[0].Rows[0]["Pfloat"].ToString()); } if (ds.Tables[0].Rows[0]["PID"].ToString() != "") { model.PID = int.Parse(ds.Tables[0].Rows[0]["PID"].ToString()); } model.PTYPE = ds.Tables[0].Rows[0]["PTYPE"].ToString(); return(model); } else { return(null); } }