protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtwas_pic_ID.Text)) { strErr += "was_pic_ID格式错误!\\n"; } if (this.txtwas_name.Text.Trim().Length == 0) { strErr += "was_name不能为空!\\n"; } if (!PageValidate.IsDecimal(txtwas_price.Text)) { strErr += "was_price格式错误!\\n"; } if (this.txtwas_recoverable.Text.Trim().Length == 0) { strErr += "was_recoverable不能为空!\\n"; } if (!PageValidate.IsNumber(txtwas_number.Text)) { strErr += "was_number格式错误!\\n"; } if (!PageValidate.IsNumber(txtwas_cate_ID.Text)) { strErr += "was_cate_ID格式错误!\\n"; } if (this.txtwas_valid.Text.Trim().Length == 0) { strErr += "was_valid不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int was_pic_ID = int.Parse(this.txtwas_pic_ID.Text); string was_name = this.txtwas_name.Text; decimal was_price = decimal.Parse(this.txtwas_price.Text); string was_recoverable = this.txtwas_recoverable.Text; int was_number = int.Parse(this.txtwas_number.Text); int was_cate_ID = int.Parse(this.txtwas_cate_ID.Text); string was_valid = this.txtwas_valid.Text; WalleProject.Model.t_waste model = new WalleProject.Model.t_waste(); model.was_pic_ID = was_pic_ID; model.was_name = was_name; model.was_price = was_price; model.was_recoverable = int.Parse(was_recoverable); model.was_number = was_number; model.was_cate_ID = was_cate_ID; model.was_valid = was_valid; WalleProject.BLL.t_waste bll = new WalleProject.BLL.t_waste(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(int was_ID) { WalleProject.BLL.t_waste bll = new WalleProject.BLL.t_waste(); WalleProject.Model.t_waste model = bll.GetModel(was_ID); this.txtwas_pic_ID.Text = model.was_pic_ID.ToString(); this.lblwas_ID.Text = model.was_ID.ToString(); this.txtwas_name.Text = model.was_name; this.txtwas_price.Text = model.was_price.ToString(); this.txtwas_recoverable.Text = model.was_recoverable.ToString(); this.txtwas_number.Text = model.was_number.ToString(); this.txtwas_cate_ID.Text = model.was_cate_ID.ToString(); this.txtwas_valid.Text = model.was_valid; }
private void ShowInfo(int was_ID) { WalleProject.BLL.t_waste bll = new WalleProject.BLL.t_waste(); WalleProject.Model.t_waste model = bll.GetModel(was_ID); this.lblwas_pic_ID.Src = new BLL.t_picture().GetModel(int.Parse(model.was_pic_ID.ToString())).pic_valid;; this.lblwas_ID.Text = model.was_ID.ToString(); this.lblwas_name.Text = model.was_name; this.lblwas_price.Text = model.was_price.ToString(); this.lblwas_price2.Text = Convert.ToString(double.Parse(model.was_price.ToString()) * 1.2); this.lblwas_recoverable.Text = model.was_recoverable.ToString(); this.lblwas_number.Text = model.was_number.ToString(); this.lblwas_cate_ID.Text = model.was_cate_ID.ToString(); this.lblwas_valid.Text = model.was_valid; this.lblwas_valid2.Text = model.was_valid; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_waste model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_waste set "); strSql.Append("was_pic_ID=@was_pic_ID,"); strSql.Append("was_name=@was_name,"); strSql.Append("was_price=@was_price,"); strSql.Append("was_recoverable=@was_recoverable,"); strSql.Append("was_number=@was_number,"); strSql.Append("was_cate_ID=@was_cate_ID,"); strSql.Append("was_valid=@was_valid"); strSql.Append(" where was_ID=@was_ID"); MySqlParameter[] parameters = { new MySqlParameter("@was_pic_ID", MySqlDbType.Int32, 10), new MySqlParameter("@was_name", MySqlDbType.VarChar, 10), new MySqlParameter("@was_price", MySqlDbType.Decimal, 10), new MySqlParameter("@was_recoverable", MySqlDbType.Int32, 10), new MySqlParameter("@was_number", MySqlDbType.Int32, 10), new MySqlParameter("@was_cate_ID", MySqlDbType.Int32, 10), new MySqlParameter("@was_valid", MySqlDbType.VarChar, 2), new MySqlParameter("@was_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.was_pic_ID; parameters[1].Value = model.was_name; parameters[2].Value = model.was_price; parameters[3].Value = model.was_recoverable; parameters[4].Value = model.was_number; parameters[5].Value = model.was_cate_ID; parameters[6].Value = model.was_valid; parameters[7].Value = model.was_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_waste DataRowToModel(DataRow row) { WalleProject.Model.t_waste model = new WalleProject.Model.t_waste(); if (row != null) { if (row["was_pic_ID"] != null && row["was_pic_ID"].ToString() != "") { model.was_pic_ID = int.Parse(row["was_pic_ID"].ToString()); } if (row["was_ID"] != null && row["was_ID"].ToString() != "") { model.was_ID = int.Parse(row["was_ID"].ToString()); } if (row["was_name"] != null) { model.was_name = row["was_name"].ToString(); } if (row["was_price"] != null && row["was_price"].ToString() != "") { model.was_price = decimal.Parse(row["was_price"].ToString()); } if (row["was_recoverable"] != null) { model.was_recoverable = int.Parse(row["was_recoverable"].ToString()); } if (row["was_number"] != null && row["was_number"].ToString() != "") { model.was_number = int.Parse(row["was_number"].ToString()); } if (row["was_cate_ID"] != null && row["was_cate_ID"].ToString() != "") { model.was_cate_ID = int.Parse(row["was_cate_ID"].ToString()); } if (row["was_valid"] != null) { model.was_valid = row["was_valid"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_waste model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_waste("); strSql.Append("was_pic_ID,was_name,was_price,was_recoverable,was_number,was_cate_ID,was_valid)"); strSql.Append(" values ("); strSql.Append("@was_pic_ID,@was_name,@was_price,@was_recoverable,@was_number,@was_cate_ID,@was_valid)"); MySqlParameter[] parameters = { new MySqlParameter("@was_pic_ID", MySqlDbType.Int32, 10), new MySqlParameter("@was_name", MySqlDbType.VarChar, 10), new MySqlParameter("@was_price", MySqlDbType.Decimal, 10), new MySqlParameter("@was_recoverable", MySqlDbType.Int32, 10), new MySqlParameter("@was_number", MySqlDbType.Int32, 10), new MySqlParameter("@was_cate_ID", MySqlDbType.Int32, 10), new MySqlParameter("@was_valid", MySqlDbType.VarChar, 2) }; parameters[0].Value = model.was_pic_ID; parameters[1].Value = model.was_name; parameters[2].Value = model.was_price; parameters[3].Value = model.was_recoverable; parameters[4].Value = model.was_number; parameters[5].Value = model.was_cate_ID; parameters[6].Value = model.was_valid; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_waste GetModel(int was_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select was_pic_ID,was_ID,was_name,was_price,was_recoverable,was_number,was_cate_ID,was_valid from t_waste "); strSql.Append(" where was_ID=@was_ID"); MySqlParameter[] parameters = { new MySqlParameter("@was_ID", MySqlDbType.Int32) }; parameters[0].Value = was_ID; WalleProject.Model.t_waste model = new WalleProject.Model.t_waste(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体(两个表连接) /// </summary> public WalleProject.Model.t_waste GetWasteModel(int was_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * from t_waste inner join t_wastecategory on t_waste.was_cate_ID=t_wastecategory.wasc_ID "); strSql.Append(" where was_ID=@was_ID"); MySqlParameter[] parameters = { new MySqlParameter("@was_ID", MySqlDbType.Int32) }; parameters[0].Value = was_ID; WalleProject.Model.t_waste model = new WalleProject.Model.t_waste(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row != null) { if (row["was_pic_ID"] != null && row["was_pic_ID"].ToString() != "") { model.was_pic_ID = int.Parse(row["was_pic_ID"].ToString()); } if (row["was_ID"] != null && row["was_ID"].ToString() != "") { model.was_ID = int.Parse(row["was_ID"].ToString()); } if (row["was_name"] != null) { model.was_name = row["was_name"].ToString(); } if (row["was_price"] != null && row["was_price"].ToString() != "") { model.was_price = decimal.Parse(row["was_price"].ToString()); } if (row["was_recoverable"] != null) { model.was_recoverable = int.Parse(row["was_recoverable"].ToString()); } if (row["was_number"] != null && row["was_number"].ToString() != "") { model.was_number = int.Parse(row["was_number"].ToString()); } if (row["was_cate_ID"] != null && row["was_cate_ID"].ToString() != "") { model.was_cate_ID = int.Parse(row["was_cate_ID"].ToString()); } if (row["was_valid"] != null) { model.was_valid = row["was_valid"].ToString(); } if (row["wasc_name"] != null) { model.wastecategory.wasc_name = row["wasc_name"].ToString(); } } return(model); } else { return(null); } }