private void ShowInfo() { NoName.NetShop.BLL.MessageModelBll bll = new NoName.NetShop.BLL.MessageModelBll(); NoName.NetShop.Model.MessageModel model = bll.GetModel(); this.txtUserId.Text = model.UserId.ToString(); this.txtMsgId.Text = model.MsgId.ToString(); this.txtMsgType.Text = model.MsgType.ToString(); this.txtSubject.Text = model.Subject; this.txtContent.Text = model.Content; this.txtSenderId.Text = model.SenderId.ToString(); this.txtInsertTime.Text = model.InsertTime.ToString(); this.txtReadTime.Text = model.ReadTime.ToString(); this.txtStatus.Text = model.Status.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.MessageModel GetModel() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_imMessage_GetModel"); NoName.NetShop.Model.MessageModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.MessageModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_imMessage_Update"); db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId); db.AddInParameter(dbCommand, "MsgId", DbType.Int32, model.MsgId); db.AddInParameter(dbCommand, "MsgType", DbType.Byte, model.MsgType); db.AddInParameter(dbCommand, "Subject", DbType.AnsiString, model.Subject); db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content); db.AddInParameter(dbCommand, "SenderId", DbType.Int32, model.SenderId); db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime); db.AddInParameter(dbCommand, "ReadTime", DbType.DateTime, model.ReadTime); db.AddInParameter(dbCommand, "Status", DbType.Int32, model.Status); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.MessageModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.MessageModel model = new NoName.NetShop.Model.MessageModel(); object ojb; ojb = dataReader["UserId"]; if (ojb != null && ojb != DBNull.Value) { model.UserId = (int)ojb; } ojb = dataReader["MsgId"]; if (ojb != null && ojb != DBNull.Value) { model.MsgId = (int)ojb; } ojb = dataReader["MsgType"]; if (ojb != null && ojb != DBNull.Value) { model.MsgType = (int)ojb; } model.Subject = dataReader["Subject"].ToString(); model.Content = dataReader["Content"].ToString(); ojb = dataReader["SenderId"]; if (ojb != null && ojb != DBNull.Value) { model.SenderId = (int)ojb; } ojb = dataReader["InsertTime"]; if (ojb != null && ojb != DBNull.Value) { model.InsertTime = (DateTime)ojb; } ojb = dataReader["ReadTime"]; if (ojb != null && ojb != DBNull.Value) { model.ReadTime = (DateTime)ojb; } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = (int)ojb; } return(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtUserId.Text)) { strErr+="UserId�������֣�\\n"; } if(!PageValidate.IsNumber(txtMsgId.Text)) { strErr+="MsgId�������֣�\\n"; } if(!PageValidate.IsNumber(txtMsgType.Text)) { strErr+="MsgType�������֣�\\n"; } if(this.txtSubject.Text =="") { strErr+="Subject����Ϊ�գ�\\n"; } if(this.txtContent.Text =="") { strErr+="Content����Ϊ�գ�\\n"; } if(!PageValidate.IsNumber(txtSenderId.Text)) { strErr+="SenderId�������֣�\\n"; } if(!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr+="InsertTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsDateTime(txtReadTime.Text)) { strErr+="ReadTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsNumber(txtStatus.Text)) { strErr+="Status�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int UserId=int.Parse(this.txtUserId.Text); int MsgId=int.Parse(this.txtMsgId.Text); int MsgType=int.Parse(this.txtMsgType.Text); string Subject=this.txtSubject.Text; string Content=this.txtContent.Text; int SenderId=int.Parse(this.txtSenderId.Text); DateTime InsertTime=DateTime.Parse(this.txtInsertTime.Text); DateTime ReadTime=DateTime.Parse(this.txtReadTime.Text); int Status=int.Parse(this.txtStatus.Text); NoName.NetShop.Model.MessageModel model=new NoName.NetShop.Model.MessageModel(); model.UserId=UserId; model.MsgId=MsgId; model.MsgType=MsgType; model.Subject=Subject; model.Content=Content; model.SenderId=SenderId; model.InsertTime=InsertTime; model.ReadTime=ReadTime; model.Status=Status; NoName.NetShop.BLL.MessageModelBll bll=new NoName.NetShop.BLL.MessageModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtUserId.Text)) { strErr += "UserId不是数字!\\n"; } if (!PageValidate.IsNumber(txtMsgId.Text)) { strErr += "MsgId不是数字!\\n"; } if (!PageValidate.IsNumber(txtMsgType.Text)) { strErr += "MsgType不是数字!\\n"; } if (this.txtSubject.Text == "") { strErr += "Subject不能为空!\\n"; } if (this.txtContent.Text == "") { strErr += "Content不能为空!\\n"; } if (!PageValidate.IsNumber(txtSenderId.Text)) { strErr += "SenderId不是数字!\\n"; } if (!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr += "InsertTime不是时间格式!\\n"; } if (!PageValidate.IsDateTime(txtReadTime.Text)) { strErr += "ReadTime不是时间格式!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int UserId = int.Parse(this.txtUserId.Text); int MsgId = int.Parse(this.txtMsgId.Text); int MsgType = int.Parse(this.txtMsgType.Text); string Subject = this.txtSubject.Text; string Content = this.txtContent.Text; int SenderId = int.Parse(this.txtSenderId.Text); DateTime InsertTime = DateTime.Parse(this.txtInsertTime.Text); DateTime ReadTime = DateTime.Parse(this.txtReadTime.Text); int Status = int.Parse(this.txtStatus.Text); NoName.NetShop.Model.MessageModel model = new NoName.NetShop.Model.MessageModel(); model.UserId = UserId; model.MsgId = MsgId; model.MsgType = MsgType; model.Subject = Subject; model.Content = Content; model.SenderId = SenderId; model.InsertTime = InsertTime; model.ReadTime = ReadTime; model.Status = Status; NoName.NetShop.BLL.MessageModelBll bll = new NoName.NetShop.BLL.MessageModelBll(); bll.Update(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.MessageModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.MessageModel model=new NoName.NetShop.Model.MessageModel(); object ojb; ojb = dataReader["UserId"]; if(ojb != null && ojb != DBNull.Value) { model.UserId=(int)ojb; } ojb = dataReader["MsgId"]; if(ojb != null && ojb != DBNull.Value) { model.MsgId=(int)ojb; } ojb = dataReader["MsgType"]; if(ojb != null && ojb != DBNull.Value) { model.MsgType=(int)ojb; } model.Subject=dataReader["Subject"].ToString(); model.Content=dataReader["Content"].ToString(); ojb = dataReader["SenderId"]; if(ojb != null && ojb != DBNull.Value) { model.SenderId=(int)ojb; } ojb = dataReader["InsertTime"]; if(ojb != null && ojb != DBNull.Value) { model.InsertTime=(DateTime)ojb; } ojb = dataReader["ReadTime"]; if(ojb != null && ojb != DBNull.Value) { model.ReadTime=(DateTime)ojb; } ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=(int)ojb; } return model; }