/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Auction.Model.bid model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update bid set ");
strSql.Append("user_id=@user_id,");
strSql.Append("item_id=@item_id,");
strSql.Append("bid_price=@bid_price,");
strSql.Append("bid_date=@bid_date");
strSql.Append(" where bid_id=@bid_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@item_id", MySqlDbType.Int32, 11),
new MySqlParameter("@bid_price", MySqlDbType.Double),
new MySqlParameter("@bid_date", MySqlDbType.Date),
new MySqlParameter("@bid_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.item_id;
parameters[2].Value = model.bid_price;
parameters[3].Value = model.bid_date;
parameters[4].Value = model.bid_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Auction.Model.bid model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into bid(");
strSql.Append("user_id,item_id,bid_price,bid_date)");
strSql.Append(" values (");
strSql.Append("@user_id,@item_id,@bid_price,@bid_date)");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@item_id", MySqlDbType.Int32, 11),
new MySqlParameter("@bid_price", MySqlDbType.Double),
new MySqlParameter("@bid_date", MySqlDbType.Date)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.item_id;
parameters[2].Value = model.bid_price;
parameters[3].Value = model.bid_date;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Auction.Model.bid DataRowToModel(DataRow row)
{
Auction.Model.bid model = new Auction.Model.bid();
if (row != null)
{
if (row["bid_id"] != null && row["bid_id"].ToString() != "")
{
model.bid_id = int.Parse(row["bid_id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["item_id"] != null && row["item_id"].ToString() != "")
{
model.item_id = int.Parse(row["item_id"].ToString());
}
//model.bid_price=row["bid_price"].ToString();
if (row["bid_date"] != null && row["bid_date"].ToString() != "")
{
model.bid_date = DateTime.Parse(row["bid_date"].ToString());
}
}
return(model);
}
private void ShowInfo(int bid_id)
{
Auction.BLL.bid bll = new Auction.BLL.bid();
Auction.Model.bid model = bll.GetModel(bid_id);
this.lblbid_id.Text = model.bid_id.ToString();
this.txtuser_id.Text = model.user_id.ToString();
this.txtitem_id.Text = model.item_id.ToString();
this.txtbid_price.Text = model.bid_price;
this.txtbid_date.Text = model.bid_date.ToString();
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtuser_id.Text))
{
strErr += "user_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txtitem_id.Text))
{
strErr += "item_id格式错误！\\n";
}
if (this.txtbid_price.Text.Trim().Length == 0)
{
strErr += "bid_price不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtbid_date.Text))
{
strErr += "bid_date格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int bid_id = int.Parse(this.lblbid_id.Text);
int user_id = int.Parse(this.txtuser_id.Text);
int item_id = int.Parse(this.txtitem_id.Text);
string bid_price = this.txtbid_price.Text;
DateTime bid_date = DateTime.Parse(this.txtbid_date.Text);
Auction.Model.bid model = new Auction.Model.bid();
model.bid_id = bid_id;
model.user_id = user_id;
model.item_id = item_id;
model.bid_price = bid_price;
model.bid_date = bid_date;
Auction.BLL.bid bll = new Auction.BLL.bid();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Auction.Model.bid GetModel(int bid_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select bid_id,user_id,item_id,bid_price,bid_date from bid ");
strSql.Append(" where bid_id=@bid_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@bid_id", MySqlDbType.Int32)
};
parameters[0].Value = bid_id;
Auction.Model.bid model = new Auction.Model.bid();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
