protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtsdType.Text)) { strErr += "sdType不是数字!\\n"; } if (!PageValidate.IsNumber(txtuserId.Text)) { strErr += "userId不是数字!\\n"; } if (this.txtTitle.Text == "") { strErr += "Title不能为空!\\n"; } if (this.txtContent.Text == "") { strErr += "Content不能为空!\\n"; } if (!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr += "InsertTime不是时间格式!\\n"; } if (!PageValidate.IsDateTime(txtModifyTime.Text)) { strErr += "ModifyTime不是时间格式!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int sdType = int.Parse(this.txtsdType.Text); int userId = int.Parse(this.txtuserId.Text); string Title = this.txtTitle.Text; string Content = this.txtContent.Text; DateTime InsertTime = DateTime.Parse(this.txtInsertTime.Text); DateTime ModifyTime = DateTime.Parse(this.txtModifyTime.Text); int Status = int.Parse(this.txtStatus.Text); NoName.NetShop.Model.SupplyDemandModel model = new NoName.NetShop.Model.SupplyDemandModel(); model.sdType = sdType; model.userId = userId; model.Title = Title; model.Content = Content; model.InsertTime = InsertTime; model.ModifyTime = ModifyTime; model.Status = Status; NoName.NetShop.BLL.SupplyDemandModelBll bll = new NoName.NetShop.BLL.SupplyDemandModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtsdType.Text)) { strErr+="sdType�������֣�\\n"; } if(!PageValidate.IsNumber(txtuserId.Text)) { strErr+="userId�������֣�\\n"; } if(this.txtTitle.Text =="") { strErr+="Title����Ϊ�գ�\\n"; } if(this.txtContent.Text =="") { strErr+="Content����Ϊ�գ�\\n"; } if(!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr+="InsertTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsDateTime(txtModifyTime.Text)) { strErr+="ModifyTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsNumber(txtStatus.Text)) { strErr+="Status�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int sdType=int.Parse(this.txtsdType.Text); int userId=int.Parse(this.txtuserId.Text); string Title=this.txtTitle.Text; string Content=this.txtContent.Text; DateTime InsertTime=DateTime.Parse(this.txtInsertTime.Text); DateTime ModifyTime=DateTime.Parse(this.txtModifyTime.Text); int Status=int.Parse(this.txtStatus.Text); NoName.NetShop.Model.SupplyDemandModel model=new NoName.NetShop.Model.SupplyDemandModel(); model.sdType=sdType; model.userId=userId; model.Title=Title; model.Content=Content; model.InsertTime=InsertTime; model.ModifyTime=ModifyTime; model.Status=Status; NoName.NetShop.BLL.SupplyDemandModelBll bll=new NoName.NetShop.BLL.SupplyDemandModelBll(); bll.Add(model); }
private void ShowInfo(int sdId) { NoName.NetShop.BLL.SupplyDemandModelBll bll = new NoName.NetShop.BLL.SupplyDemandModelBll(); NoName.NetShop.Model.SupplyDemandModel model = bll.GetModel(sdId); this.lblsdType.Text = model.sdType.ToString(); this.lbluserId.Text = model.userId.ToString(); this.lblTitle.Text = model.Title; this.lblContent.Text = model.Content; this.lblInsertTime.Text = model.InsertTime.ToString(); this.lblModifyTime.Text = model.ModifyTime.ToString(); this.lblStatus.Text = model.Status.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.SupplyDemandModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_sdSupplyDemand_Update"); db.AddInParameter(dbCommand, "sdId", DbType.Int32, model.sdId); db.AddInParameter(dbCommand, "sdType", DbType.Byte, model.sdType); db.AddInParameter(dbCommand, "userId", DbType.Int32, model.userId); db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title); db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content); db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime); db.AddInParameter(dbCommand, "ModifyTime", DbType.DateTime, model.ModifyTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.SupplyDemandModel GetModel(int sdId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_sdSupplyDemand_GetModel"); db.AddInParameter(dbCommand, "sdId", DbType.Int32, sdId); NoName.NetShop.Model.SupplyDemandModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.SupplyDemandModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.SupplyDemandModel model = new NoName.NetShop.Model.SupplyDemandModel(); object ojb; ojb = dataReader["sdId"]; if (ojb != null && ojb != DBNull.Value) { model.sdId = (int)ojb; } ojb = dataReader["sdType"]; if (ojb != null && ojb != DBNull.Value) { model.sdType = (int)ojb; } ojb = dataReader["userId"]; if (ojb != null && ojb != DBNull.Value) { model.userId = (int)ojb; } model.Title = dataReader["Title"].ToString(); model.Content = dataReader["Content"].ToString(); ojb = dataReader["InsertTime"]; if (ojb != null && ojb != DBNull.Value) { model.InsertTime = (DateTime)ojb; } ojb = dataReader["ModifyTime"]; if (ojb != null && ojb != DBNull.Value) { model.ModifyTime = (DateTime)ojb; } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = (int)ojb; } return(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.SupplyDemandModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.SupplyDemandModel model=new NoName.NetShop.Model.SupplyDemandModel(); object ojb; ojb = dataReader["sdId"]; if(ojb != null && ojb != DBNull.Value) { model.sdId=(int)ojb; } ojb = dataReader["sdType"]; if(ojb != null && ojb != DBNull.Value) { model.sdType=(int)ojb; } ojb = dataReader["userId"]; if(ojb != null && ojb != DBNull.Value) { model.userId=(int)ojb; } model.Title=dataReader["Title"].ToString(); model.Content=dataReader["Content"].ToString(); ojb = dataReader["InsertTime"]; if(ojb != null && ojb != DBNull.Value) { model.InsertTime=(DateTime)ojb; } ojb = dataReader["ModifyTime"]; if(ojb != null && ojb != DBNull.Value) { model.ModifyTime=(DateTime)ojb; } ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=(int)ojb; } return model; }