/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_commodity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_commodity set "); strSql.Append("com_name=@com_name,"); strSql.Append("com_productDate=@com_productDate,"); strSql.Append("com_number=@com_number,"); strSql.Append("com_strageID=@com_strageID,"); strSql.Append("com_alertNumber=@com_alertNumber,"); strSql.Append("com_pic_ID=@com_pic_ID,"); strSql.Append("com_date=@com_date,"); strSql.Append("com_pri_ID=@com_pri_ID,"); strSql.Append("com_conversionInt=@com_conversionInt,"); strSql.Append("com_comc_ID=@com_comc_ID,"); strSql.Append("com_valid=@com_valid"); strSql.Append(" where com_ID=@com_ID"); MySqlParameter[] parameters = { new MySqlParameter("@com_name", MySqlDbType.VarChar, 20), new MySqlParameter("@com_productDate", MySqlDbType.Date), new MySqlParameter("@com_number", MySqlDbType.Int32, 10), new MySqlParameter("@com_strageID", MySqlDbType.VarChar, 10), new MySqlParameter("@com_alertNumber", MySqlDbType.Int32, 10), new MySqlParameter("@com_pic_ID", MySqlDbType.Int32, 10), new MySqlParameter("@com_date", MySqlDbType.Date), new MySqlParameter("@com_pri_ID", MySqlDbType.Decimal, 10), new MySqlParameter("@com_conversionInt", MySqlDbType.Int32, 10), new MySqlParameter("@com_comc_ID", MySqlDbType.Int32, 10), new MySqlParameter("@com_valid", MySqlDbType.VarChar, 2), new MySqlParameter("@com_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.com_name; parameters[1].Value = model.com_productDate; parameters[2].Value = model.com_number; parameters[3].Value = model.com_strageID; parameters[4].Value = model.com_alertNumber; parameters[5].Value = model.com_pic_ID; parameters[6].Value = model.com_date; parameters[7].Value = model.com_pri_ID; parameters[8].Value = model.com_conversionInt; parameters[9].Value = model.com_comc_ID; parameters[10].Value = model.com_valid; parameters[11].Value = model.com_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_commodity DataRowToModel(DataRow row) { WalleProject.Model.t_commodity model = new WalleProject.Model.t_commodity(); if (row != null) { if (row["com_ID"] != null && row["com_ID"].ToString() != "") { model.com_ID = int.Parse(row["com_ID"].ToString()); } if (row["com_name"] != null) { model.com_name = row["com_name"].ToString(); } if (row["com_productDate"] != null && row["com_productDate"].ToString() != "") { model.com_productDate = DateTime.Parse(row["com_productDate"].ToString()); } if (row["com_number"] != null && row["com_number"].ToString() != "") { model.com_number = int.Parse(row["com_number"].ToString()); } if (row["com_strageID"] != null) { model.com_strageID = row["com_strageID"].ToString(); } if (row["com_alertNumber"] != null && row["com_alertNumber"].ToString() != "") { model.com_alertNumber = int.Parse(row["com_alertNumber"].ToString()); } if (row["com_pic_ID"] != null && row["com_pic_ID"].ToString() != "") { model.com_pic_ID = int.Parse(row["com_pic_ID"].ToString()); } if (row["com_date"] != null && row["com_date"].ToString() != "") { model.com_date = DateTime.Parse(row["com_date"].ToString()); } if (row["com_pri_ID"] != null && row["com_pri_ID"].ToString() != "") { model.com_pri_ID = Decimal.Parse(row["com_pri_ID"].ToString()); } if (row["com_conversionInt"] != null && row["com_conversionInt"].ToString() != "") { model.com_conversionInt = int.Parse(row["com_conversionInt"].ToString()); } if (row["com_comc_ID"] != null && row["com_comc_ID"].ToString() != "") { model.com_comc_ID = int.Parse(row["com_comc_ID"].ToString()); } if (row["com_valid"] != null) { model.com_valid = row["com_valid"].ToString(); } } return(model); }
private void ShowInfo(int com_ID) { WalleProject.BLL.t_commodity bll = new WalleProject.BLL.t_commodity(); WalleProject.Model.t_commodity model = bll.GetModel(com_ID); this.lblcom_id.Text = model.com_ID.ToString(); this.lblcom_name.Text = model.com_name; this.lblcom_productDate.Text = model.com_productDate.ToString(); this.lblcom_number.Text = model.com_number.ToString(); this.lblcom_strageID.Text = model.com_strageID; this.lblcom_pic_ID.Src = new BLL.t_picture().GetModel(int.Parse(model.com_pic_ID.ToString())).pic_valid; this.lblcom_date.Text = model.com_date.ToString(); this.lblcom_pri_ID.Text = model.com_pri_ID.ToString(); this.lblcom_conversionInt.Text = Convert.ToString(double.Parse(model.com_pri_ID.ToString()) * 0.8); this.lblcom_comc_ID.Text = new BLL.t_commoditycategory().GetModel(int.Parse(model.com_comc_ID.ToString())).comc_name; this.lblcom_valid.Text = model.com_valid; this.lblcom_valid2.Text = model.com_valid; }
private void ShowInfo(int com_ID) { WalleProject.BLL.t_commodity bll = new WalleProject.BLL.t_commodity(); WalleProject.Model.t_commodity model = bll.GetModel(com_ID); this.lblcom_ID.Text = model.com_ID.ToString(); this.txtcom_name.Text = model.com_name; this.txtcom_productDate.Text = model.com_productDate.ToString(); this.txtcom_number.Text = model.com_number.ToString(); this.txtcom_strageID.Text = model.com_strageID; this.txtcom_alertNumber.Text = model.com_alertNumber.ToString(); this.txtcom_pic_ID.Text = model.com_pic_ID.ToString(); this.txtcom_date.Text = model.com_date.ToString(); this.txtcom_pri_ID.Text = model.com_pri_ID.ToString(); this.txtcom_conversionInt.Text = model.com_conversionInt.ToString(); this.txtcom_comc_ID.Text = model.com_comc_ID.ToString(); this.txtcom_valid.Text = model.com_valid; }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_commodity GetModel(int com_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select com_ID,com_name,com_productDate,com_number,com_strageID,com_alertNumber,com_pic_ID,com_date,com_pri_ID,com_conversionInt,com_comc_ID,com_valid from t_commodity "); strSql.Append(" where com_ID=@com_ID"); MySqlParameter[] parameters = { new MySqlParameter("@com_ID", MySqlDbType.Int32) }; parameters[0].Value = com_ID; WalleProject.Model.t_commodity model = new WalleProject.Model.t_commodity(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtcom_name.Text.Trim().Length == 0) { strErr += "商品名不能为空!\\n"; } if (!PageValidate.IsDateTime(txtcom_productDate.Text)) { strErr += "生产日期格式错误!\\n"; } if (!PageValidate.IsNumber(txtcom_number.Text)) { strErr += "商品数量格式错误!\\n"; } if (this.txtcom_strageID.Text.Trim().Length == 0) { strErr += "货架号不能为空!\\n"; } if (!PageValidate.IsNumber(txtcom_alertNumber.Text)) { strErr += "警戒值格式错误!\\n"; } if (!PageValidate.IsNumber(txtcom_pic_ID.Text)) { strErr += "图片格式错误!\\n"; } if (!PageValidate.IsNumber(txtcom_pri_ID.Text)) { strErr += "二级类别格式错误!\\n"; } if (!PageValidate.IsNumber(txtcom_conversionInt.Text)) { strErr += "积分格式错误!\\n"; } if (!PageValidate.IsNumber(txtcom_comc_ID.Text)) { strErr += "类别格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string com_name = this.txtcom_name.Text; DateTime com_productDate = DateTime.Parse(this.txtcom_productDate.Text); int com_number = int.Parse(this.txtcom_number.Text); string com_strageID = this.txtcom_strageID.Text; int com_alertNumber = int.Parse(this.txtcom_alertNumber.Text); int com_pic_ID = int.Parse(this.txtcom_pic_ID.Text); DateTime com_date = DateTime.Parse(this.txtcom_date.Text); int com_pri_ID = int.Parse(this.txtcom_pri_ID.Text); int com_conversionInt = int.Parse(this.txtcom_conversionInt.Text); int com_comc_ID = int.Parse(this.txtcom_comc_ID.Text); string com_valid = this.txtcom_valid.Text; WalleProject.Model.t_commodity model = new WalleProject.Model.t_commodity(); model.com_name = com_name; model.com_productDate = com_productDate; model.com_number = com_number; model.com_strageID = com_strageID; model.com_alertNumber = com_alertNumber; model.com_pic_ID = com_pic_ID; model.com_date = com_date; model.com_pri_ID = com_pri_ID; model.com_conversionInt = com_conversionInt; model.com_comc_ID = com_comc_ID; model.com_valid = com_valid; WalleProject.BLL.t_commodity bll = new WalleProject.BLL.t_commodity(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体(两个表) /// </summary> public WalleProject.Model.t_commodity GetCommodityModel(int com_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from t_commodity inner join t_commoditycategory on t_commodity.com_comc_ID=t_commoditycategory.comc_ID "); strSql.Append(" where com_ID=@com_ID"); MySqlParameter[] parameters = { new MySqlParameter("@com_ID", MySqlDbType.Int32) }; parameters[0].Value = com_ID; WalleProject.Model.t_commodity model = new WalleProject.Model.t_commodity(); 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["com_ID"] != null && row["com_ID"].ToString() != "") { model.com_ID = int.Parse(row["com_ID"].ToString()); } if (row["com_name"] != null) { model.com_name = row["com_name"].ToString(); } if (row["com_productDate"] != null && row["com_productDate"].ToString() != "") { model.com_productDate = DateTime.Parse(row["com_productDate"].ToString()); } if (row["com_number"] != null && row["com_number"].ToString() != "") { model.com_number = int.Parse(row["com_number"].ToString()); } if (row["com_strageID"] != null) { model.com_strageID = row["com_strageID"].ToString(); } if (row["com_alertNumber"] != null && row["com_alertNumber"].ToString() != "") { model.com_alertNumber = int.Parse(row["com_alertNumber"].ToString()); } if (row["com_pic_ID"] != null && row["com_pic_ID"].ToString() != "") { model.com_pic_ID = int.Parse(row["com_pic_ID"].ToString()); } if (row["com_date"] != null && row["com_date"].ToString() != "") { model.com_date = DateTime.Parse(row["com_date"].ToString()); } if (row["com_pri_ID"] != null && row["com_pri_ID"].ToString() != "") { model.com_pri_ID = Decimal.Parse(row["com_pri_ID"].ToString()); } if (row["com_conversionInt"] != null && row["com_conversionInt"].ToString() != "") { model.com_conversionInt = int.Parse(row["com_conversionInt"].ToString()); } if (row["com_comc_ID"] != null && row["com_comc_ID"].ToString() != "") { model.com_comc_ID = int.Parse(row["com_comc_ID"].ToString()); } if (row["com_valid"] != null) { model.com_valid = row["com_valid"].ToString(); } if (row["comc_name"] != null) { model.commoditycategory.comc_name = row["comc_name"].ToString(); } } return(model); } else { return(null); } }