/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WalleProject.Model.t_tradingrecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_tradingrecord set ");
strSql.Append("tra_U_ID=@tra_U_ID,");
strSql.Append("tra_transactionAmount=@tra_transactionAmount,");
strSql.Append("tra_transactionDate=@tra_transactionDate,");
strSql.Append("tra_accomplish=@tra_accomplish,");
strSql.Append("tra_staff_id=@tra_staff_id,");
strSql.Append("sta_comwas_id=@sta_comwas_id,");
strSql.Append("tra_number=@tra_number,");
strSql.Append("tra_addressID=@tra_addressID,");
strSql.Append("tra_type=@tra_type,");
strSql.Append("tra_vaild=@tra_vaild,");
strSql.Append("tra_sort=@tra_sort");
strSql.Append(" where tra_ID=@tra_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@tra_U_ID", MySqlDbType.Int32, 10),
new MySqlParameter("@tra_transactionAmount", MySqlDbType.Decimal, 10),
new MySqlParameter("@tra_transactionDate", MySqlDbType.DateTime),
new MySqlParameter("@tra_accomplish", MySqlDbType.VarChar, 10),
new MySqlParameter("@tra_staff_id", MySqlDbType.Int32, 10),
new MySqlParameter("@sta_comwas_id", MySqlDbType.Int32, 10),
new MySqlParameter("@tra_number", MySqlDbType.Int32, 10),
new MySqlParameter("@tra_addressID", MySqlDbType.Int32, 10),
new MySqlParameter("@tra_type", MySqlDbType.VarChar, 10),
new MySqlParameter("@tra_vaild", MySqlDbType.VarChar, 10),
new MySqlParameter("@tra_sort", MySqlDbType.Int32, 10),
new MySqlParameter("@tra_ID", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.tra_U_ID;
parameters[1].Value = model.tra_transactionAmount;
parameters[2].Value = model.tra_transactionDate;
parameters[3].Value = model.tra_accomplish;
parameters[4].Value = model.tra_staff_id;
parameters[5].Value = model.sta_comwas_id;
parameters[6].Value = model.tra_number;
parameters[7].Value = model.tra_addressID;
parameters[8].Value = model.tra_type;
parameters[9].Value = model.tra_vaild;
parameters[10].Value = model.tra_sort;
parameters[11].Value = model.tra_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_tradingrecord DataRowToModel(DataRow row)
{
WalleProject.Model.t_tradingrecord model = new WalleProject.Model.t_tradingrecord();
if (row != null)
{
if (row["tra_U_ID"] != null && row["tra_U_ID"].ToString() != "")
{
model.tra_U_ID = int.Parse(row["tra_U_ID"].ToString());
}
if (row["tra_transactionAmount"] != null && row["tra_transactionAmount"].ToString() != "")
{
model.tra_transactionAmount = decimal.Parse(row["tra_transactionAmount"].ToString());
}
if (row["tra_transactionDate"] != null && row["tra_transactionDate"].ToString() != "")
{
model.tra_transactionDate = DateTime.Parse(row["tra_transactionDate"].ToString());
}
if (row["tra_accomplish"] != null)
{
model.tra_accomplish = row["tra_accomplish"].ToString();
}
if (row["tra_staff_id"] != null && row["tra_staff_id"].ToString() != "")
{
model.tra_staff_id = int.Parse(row["tra_staff_id"].ToString());
}
if (row["sta_comwas_id"] != null && row["sta_comwas_id"].ToString() != "")
{
model.sta_comwas_id = int.Parse(row["sta_comwas_id"].ToString());
}
if (row["tra_number"] != null && row["tra_number"].ToString() != "")
{
model.tra_number = int.Parse(row["tra_number"].ToString());
}
if (row["tra_ID"] != null && row["tra_ID"].ToString() != "")
{
model.tra_ID = int.Parse(row["tra_ID"].ToString());
}
if (row["tra_addressID"] != null && row["tra_addressID"].ToString() != "")
{
model.tra_addressID = int.Parse(row["tra_addressID"].ToString());
}
if (row["tra_type"] != null)
{
model.tra_type = row["tra_type"].ToString();
}
if (row["tra_vaild"] != null)
{
model.tra_vaild = row["tra_vaild"].ToString();
}
if (row["tra_sort"] != null && row["tra_sort"].ToString() != "")
{
model.tra_sort = int.Parse(row["tra_sort"].ToString());
}
}
return(model);
}
private void ShowInfo(int tra_ID)
{
WalleProject.BLL.t_tradingrecord bll = new WalleProject.BLL.t_tradingrecord();
WalleProject.Model.t_tradingrecord model = bll.GetModel(tra_ID);
this.txttra_U_ID.Text = model.tra_U_ID.ToString();
this.txttra_transactionAmount.Text = model.tra_transactionAmount.ToString();
this.txttra_transactionDate.Text = model.tra_transactionDate.ToString();
this.txttra_accomplish.Text = model.tra_accomplish;
this.txttra_staff_id.Text = model.tra_staff_id.ToString();
this.txtsta_comwas_id.Text = model.sta_comwas_id.ToString();
this.txttra_number.Text = model.tra_number.ToString();
this.lbltra_ID.Text = model.tra_ID.ToString();
this.txttra_addressID.Text = model.tra_addressID.ToString();
this.txttra_type.Text = model.tra_type;
this.txttra_vaild.Text = model.tra_vaild;
this.txttra_sort.Text = model.tra_sort.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_tradingrecord GetModel(int tra_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select tra_U_ID,tra_transactionAmount,tra_transactionDate,tra_accomplish,tra_staff_id,sta_comwas_id,tra_number,tra_ID,tra_addressID,tra_type,tra_vaild,tra_sort from t_tradingrecord ");
strSql.Append(" where tra_ID=@tra_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@tra_ID", MySqlDbType.Int32)
};
parameters[0].Value = tra_ID;
WalleProject.Model.t_tradingrecord model = new WalleProject.Model.t_tradingrecord();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txttra_U_ID.Text))
{
strErr += "tra_U_ID格式错误！\\n";
}
if (!PageValidate.IsDecimal(txttra_transactionAmount.Text))
{
strErr += "tra_transactionAmount格式错误！\\n";
}
if (!PageValidate.IsDateTime(txttra_transactionDate.Text))
{
strErr += "tra_transactionDate格式错误！\\n";
}
if (this.txttra_accomplish.Text.Trim().Length == 0)
{
strErr += "tra_accomplish不能为空！\\n";
}
if (!PageValidate.IsNumber(txttra_staff_id.Text))
{
strErr += "tra_staff_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsta_comwas_id.Text))
{
strErr += "sta_comwas_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txttra_number.Text))
{
strErr += "tra_number格式错误！\\n";
}
if (!PageValidate.IsNumber(txttra_addressID.Text))
{
strErr += "tra_addressID格式错误！\\n";
}
if (this.txttra_type.Text.Trim().Length == 0)
{
strErr += "tra_type不能为空！\\n";
}
if (this.txttra_vaild.Text.Trim().Length == 0)
{
strErr += "tra_vaild不能为空！\\n";
}
if (!PageValidate.IsNumber(txttra_sort.Text))
{
strErr += "tra_sort格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int tra_U_ID = int.Parse(this.txttra_U_ID.Text);
decimal tra_transactionAmount = decimal.Parse(this.txttra_transactionAmount.Text);
DateTime tra_transactionDate = DateTime.Parse(this.txttra_transactionDate.Text);
string tra_accomplish = this.txttra_accomplish.Text;
int tra_staff_id = int.Parse(this.txttra_staff_id.Text);
int sta_comwas_id = int.Parse(this.txtsta_comwas_id.Text);
int tra_number = int.Parse(this.txttra_number.Text);
int tra_ID = int.Parse(this.lbltra_ID.Text);
int tra_addressID = int.Parse(this.txttra_addressID.Text);
string tra_type = this.txttra_type.Text;
string tra_vaild = this.txttra_vaild.Text;
int tra_sort = int.Parse(this.txttra_sort.Text);
WalleProject.Model.t_tradingrecord model = new WalleProject.Model.t_tradingrecord();
model.tra_U_ID = tra_U_ID;
model.tra_transactionAmount = tra_transactionAmount;
model.tra_transactionDate = tra_transactionDate;
model.tra_accomplish = tra_accomplish;
model.tra_staff_id = tra_staff_id;
model.sta_comwas_id = sta_comwas_id;
model.tra_number = tra_number;
model.tra_ID = tra_ID;
model.tra_addressID = tra_addressID;
model.tra_type = tra_type;
model.tra_vaild = tra_vaild;
model.tra_sort = tra_sort;
WalleProject.BLL.t_tradingrecord bll = new WalleProject.BLL.t_tradingrecord();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string strErr = "";
int number = int.Parse(txt_number.Value);
int addressID;
if (number <= 0 && number > int.Parse(lblcom_number.Text))
{
strErr = "回收的数量不符合要求";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
if (r6.Checked)
{
addressID = int.Parse(lb_address.SelectedValue);
}
else
{
Model.t_address address = new Model.t_address();
address.add_province = ddl_p.Items[ddl_p.SelectedIndex].Text;
address.add_city = ddl_c.Items[ddl_c.SelectedIndex].Text;
address.add_counties = ddl_d.Items[ddl_d.SelectedIndex].Text;
address.add_address = input_Address.Text;
address.add_date = DateTime.Now;
address.add_default = "0";
address.add_u_ID = int.Parse(userid.Text);
address.add_postcode = 000000;
address.add_contactName = input_userName.Text;
address.add_contactPhone = input_phone.Text;
address.add_ID = new BLL.t_address().GetMaxId();
bool istrue = new BLL.t_address().Add(address);
addressID = address.add_ID;
}
user = new BLL.t_user().GetModel(int.Parse(userid.Text));
int tra_U_ID = int.Parse(userid.Text);
decimal tra_transactionAmount = decimal.Parse(this.lblcom_conversionInt.Text);
DateTime tra_transactionDate = DateTime.Now;
string tra_accomplish = "发布";
int tra_staff_id = 0;
int sta_comwas_id = int.Parse(this.lblcom_id.Text);
int tra_number = int.Parse(this.txt_number.Value);
if (user.u_integral < tra_number * tra_transactionAmount)
{
strErr += "你的积分不够哦！\\n";
MessageBox.Show(this, strErr);
return;
}
user.u_integral = Convert.ToInt32(user.u_integral - tra_number * tra_transactionAmount);
bool isuser = new BLL.t_user().Update(user);
// int tra_addressID = int.Parse(this.rad_address.SelectedValue);
string tra_type = "商品";
string tra_vaild = "是";
int tra_sort = 1;
WalleProject.Model.t_tradingrecord model = new WalleProject.Model.t_tradingrecord();
model.tra_addressID = addressID;
model.tra_U_ID = tra_U_ID;
model.tra_transactionAmount = tra_transactionAmount;
model.tra_transactionDate = tra_transactionDate;
model.tra_accomplish = tra_accomplish;
model.tra_staff_id = tra_staff_id;
model.sta_comwas_id = sta_comwas_id;
model.tra_number = tra_number;
model.tra_type = tra_type;
model.tra_vaild = tra_vaild;
model.tra_sort = tra_sort;
WalleProject.BLL.t_tradingrecord bll = new WalleProject.BLL.t_tradingrecord();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "发布成功，等待回收员接单", "CommodityView.aspx?id=9");
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (int.Parse(txt_number.Value) <= 0)
{
strErr = "回收的数量不符合要求";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int number = int.Parse(txt_number.Value);
int addressID;
if (r6.Checked)
{
addressID = int.Parse(ListBox1.SelectedValue);
}
else
{
Model.t_address address = new Model.t_address();
address.add_province = ddl_p.Items[ddl_p.SelectedIndex].Text;
address.add_city = ddl_c.Items[ddl_c.SelectedIndex].Text;
address.add_counties = ddl_d.Items[ddl_d.SelectedIndex].Text;
address.add_address = input_Address.Text;
address.add_date = DateTime.Now;
address.add_default = "0";
address.add_u_ID = int.Parse(userid.Text);
address.add_postcode = 000000;
address.add_contactName = input_userName.Text;
address.add_contactPhone = input_phone.Text;
address.add_ID = new BLL.t_address().GetMaxId();
bool istrue = new BLL.t_address().Add(address);
addressID = address.add_ID;
}
int tra_U_ID = int.Parse(userid.Text);
decimal tra_transactionAmount = decimal.Parse(this.lblwas_price2.Text);
DateTime tra_transactionDate = DateTime.Now;
string tra_accomplish = "发布";
int tra_staff_id = 0;
int sta_comwas_id = int.Parse(this.lblwas_ID.Text);
int tra_number = int.Parse(txt_number.Value);
// int tra_addressID = int.Parse(this.rad_address.SelectedValue);
string tra_type = "废品";
string tra_vaild = "是";
int tra_sort = 1;
WalleProject.Model.t_tradingrecord model = new WalleProject.Model.t_tradingrecord();
model.tra_addressID = addressID;
model.tra_U_ID = tra_U_ID;
model.tra_transactionAmount = tra_transactionAmount;
model.tra_transactionDate = tra_transactionDate;
model.tra_accomplish = tra_accomplish;
model.tra_staff_id = tra_staff_id;
model.sta_comwas_id = sta_comwas_id;
model.tra_number = tra_number;
// model.tra_addressID = tra_addressID;
model.tra_type = tra_type;
model.tra_vaild = tra_vaild;
model.tra_sort = tra_sort;
WalleProject.BLL.t_tradingrecord bll = new WalleProject.BLL.t_tradingrecord();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "发布成功，等待回收员上门！", "WasteView.aspx?id=5");
}
