protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtName.Text.Trim().Length == 0) { strErr += "名字不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string Name = this.txtName.Text; string Sex = this.RBLSex.Text; string PerType = this.ddlPertype.Text; string PerNumber = this.txtPerNumber.Text; int ReadtypeID = int.Parse(this.DropDownList1.Text); YueDuLibrary.Model.Readers model = new YueDuLibrary.Model.Readers(); model.Name = Name; model.Sex = Sex; model.PerType = PerType; model.PerNumber = PerNumber; model.ReadtypeID = ReadtypeID; YueDuLibrary.BLL.Readers bll = new YueDuLibrary.BLL.Readers(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public YueDuLibrary.Model.Readers DataRowToModel(DataRow row) { YueDuLibrary.Model.Readers model = new YueDuLibrary.Model.Readers(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["PerType"] != null) { model.PerType = row["PerType"].ToString(); } if (row["PerNumber"] != null) { model.PerNumber = row["PerNumber"].ToString(); } if (row["ReadtypeID"] != null && row["ReadtypeID"].ToString() != "") { model.ReadtypeID = int.Parse(row["ReadtypeID"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(YueDuLibrary.Model.Readers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Readers("); strSql.Append("Name,Sex,PerType,PerNumber,ReadtypeID)"); strSql.Append(" values ("); strSql.Append("@Name,@Sex,@PerType,@PerNumber,@ReadtypeID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 50), new SqlParameter("@PerType", SqlDbType.NVarChar, 50), new SqlParameter("@PerNumber", SqlDbType.NVarChar, 50), new SqlParameter("@ReadtypeID", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Sex; parameters[2].Value = model.PerType; parameters[3].Value = model.PerNumber; parameters[4].Value = model.ReadtypeID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void Button1_Click(object sender, EventArgs e) { string txtReadSer = this.txtReadSer.Text.Trim(); if (!string.IsNullOrEmpty(txtReadSer)) { YueDuLibrary.Model.Readers readersModel = readers.GetModeByNumber(txtReadSer); if (readersModel != null) { labName.Text = readersModel.Name; LabPer.Text = readersModel.PerType; LabPerNumber.Text = readersModel.PerNumber; LabSex.Text = readersModel.Sex; readID.Text = readersModel.Id.ToString(); } else { MessageBox.Show(this, "无该读者信息!"); } } else { MessageBox.Show(this, "请输入读者编号!"); } }
private void ShowInfo(int Id) { YueDuLibrary.BLL.Readers bll = new YueDuLibrary.BLL.Readers(); YueDuLibrary.Model.Readers model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.txtName.Text = model.Name; this.txtPerNumber.Text = model.PerNumber; }
private void ShowInfo(int Id) { YueDuLibrary.BLL.Readers bll = new YueDuLibrary.BLL.Readers(); YueDuLibrary.Model.Readers model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblName.Text = model.Name; this.lblSex.Text = model.Sex; this.lblPerType.Text = model.PerType; this.lblPerNumber.Text = model.PerNumber; this.lblReadtypeID.Text = model.ReadtypeID.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(YueDuLibrary.Model.Readers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Readers set "); strSql.Append("Name=@Name,"); strSql.Append("Sex=@Sex,"); strSql.Append("PerType=@PerType,"); strSql.Append("PerNumber=@PerNumber,"); strSql.Append("ReadtypeID=@ReadtypeID"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 50), new SqlParameter("@PerType", SqlDbType.NVarChar, 50), new SqlParameter("@PerNumber", SqlDbType.NVarChar, 50), new SqlParameter("@ReadtypeID", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Sex; parameters[2].Value = model.PerType; parameters[3].Value = model.PerNumber; parameters[4].Value = model.ReadtypeID; parameters[5].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 通过perNumBe得到一个对象实体 /// </summary> public YueDuLibrary.Model.Readers GetModeByNumber(string number) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Name,Sex,PerType,PerNumber,ReadtypeID from Readers "); strSql.Append(" where PerNumber=@perNumber"); SqlParameter[] parameters = { new SqlParameter("@perNumber", SqlDbType.NVarChar, 50) }; parameters[0].Value = number; YueDuLibrary.Model.Readers model = new YueDuLibrary.Model.Readers(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }