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);
}
}
