/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Auction.Model.item model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update item set ");
strSql.Append("item_name=@item_name,");
strSql.Append("item_remark=@item_remark,");
strSql.Append("item_desc=@item_desc,");
strSql.Append("kind_id=@kind_id,");
strSql.Append("addtime=@addtime,");
strSql.Append("endtime=@endtime,");
strSql.Append("init_price=@init_price,");
strSql.Append("max_price=@max_price,");
strSql.Append("owner_id=@owner_id,");
strSql.Append("winer_id=@winer_id,");
strSql.Append("state_id=@state_id");
strSql.Append(" where item_id=@item_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@item_name", MySqlDbType.VarChar, 255),
new MySqlParameter("@item_remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@item_desc", MySqlDbType.VarChar, 255),
new MySqlParameter("@kind_id", MySqlDbType.Int32, 11),
new MySqlParameter("@addtime", MySqlDbType.Date),
new MySqlParameter("@endtime", MySqlDbType.Date),
new MySqlParameter("@init_price", MySqlDbType.Double),
new MySqlParameter("@max_price", MySqlDbType.Double),
new MySqlParameter("@owner_id", MySqlDbType.Int32, 11),
new MySqlParameter("@winer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@state_id", MySqlDbType.Int32, 11),
new MySqlParameter("@item_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.item_name;
parameters[1].Value = model.item_remark;
parameters[2].Value = model.item_desc;
parameters[3].Value = model.kind_id;
parameters[4].Value = model.addtime;
parameters[5].Value = model.EndTime;
parameters[6].Value = model.init_price;
parameters[7].Value = model.max_price;
parameters[8].Value = model.owner_id;
parameters[9].Value = model.winer_id;
parameters[10].Value = model.state_id;
parameters[11].Value = model.item_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Auction.Model.item DataRowToModel(DataRow row)
{
Auction.Model.item model = new Auction.Model.item();
if (row != null)
{
if (row["item_id"] != null && row["item_id"].ToString() != "")
{
model.item_id = int.Parse(row["item_id"].ToString());
}
if (row["item_name"] != null)
{
model.item_name = row["item_name"].ToString();
}
if (row["item_remark"] != null)
{
model.item_remark = row["item_remark"].ToString();
}
if (row["item_desc"] != null)
{
model.item_desc = row["item_desc"].ToString();
}
if (row["kind_id"] != null && row["kind_id"].ToString() != "")
{
model.kind_id = int.Parse(row["kind_id"].ToString());
}
if (row["addtime"] != null && row["addtime"].ToString() != "")
{
model.addtime = DateTime.Parse(row["addtime"].ToString());
}
if (row["endtime"] != null && row["endtime"].ToString() != "")
{
model.EndTime = DateTime.Parse(row["endtime"].ToString());
}
model.init_price = row["init_price"] == null || "".Equals(row["init_price"].ToString()) ? 0 : (double)row["init_price"];
model.max_price = row["max_price"] == null || "".Equals(row["max_price"].ToString()) ? 0 : (double)row["max_price"];
if (row["owner_id"] != null && row["owner_id"].ToString() != "")
{
model.owner_id = int.Parse(row["owner_id"].ToString());
}
if (row["winer_id"] != null && row["winer_id"].ToString() != "")
{
model.winer_id = int.Parse(row["winer_id"].ToString());
}
if (row["state_id"] != null && row["state_id"].ToString() != "")
{
model.state_id = int.Parse(row["state_id"].ToString());
}
}
return(model);
}
private void ShowInfo(int item_id)
{
Auction.BLL.item bll = new Auction.BLL.item();
Auction.Model.item model = bll.GetModel(item_id);
this.lblitem_id.Text = model.item_id.ToString();
this.txtitem_name.Text = model.item_name;
this.txtitem_remark.Text = model.item_remark;
this.txtitem_desc.Text = model.item_desc;
this.txtkind_id.Text = model.kind_id.ToString();
this.txtaddtime.Text = model.addtime.ToString();
this.txtendtime.Text = model.endtime.ToString();
this.txtinit_price.Text = model.init_price;
this.txtmax_price.Text = model.max_price;
this.txtowner_id.Text = model.owner_id.ToString();
this.txtwiner_id.Text = model.winer_id.ToString();
this.txtstate_id.Text = model.state_id.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Auction.Model.item model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into item(");
strSql.Append("item_name,item_remark,item_desc,kind_id,addtime,endtime,init_price,max_price,owner_id,winer_id,state_id)");
strSql.Append(" values (");
strSql.Append("@item_name,@item_remark,@item_desc,@kind_id,@addtime,@endtime,@init_price,@max_price,@owner_id,@winer_id,@state_id)");
MySqlParameter[] parameters =
{
new MySqlParameter("@item_name", MySqlDbType.VarChar, 255),
new MySqlParameter("@item_remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@item_desc", MySqlDbType.VarChar, 255),
new MySqlParameter("@kind_id", MySqlDbType.Int32, 11),
new MySqlParameter("@addtime", MySqlDbType.Date),
new MySqlParameter("@endtime", MySqlDbType.Date),
new MySqlParameter("@init_price", MySqlDbType.Double),
new MySqlParameter("@max_price", MySqlDbType.Double),
new MySqlParameter("@owner_id", MySqlDbType.Int32, 11),
new MySqlParameter("@winer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@state_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.item_name;
parameters[1].Value = model.item_remark;
parameters[2].Value = model.item_desc;
parameters[3].Value = model.kind_id;
parameters[4].Value = model.addtime;
parameters[5].Value = model.EndTime;
parameters[6].Value = model.init_price;
parameters[7].Value = model.max_price;
parameters[8].Value = model.owner_id;
parameters[9].Value = model.winer_id == 0 ? null : model.winer_id;
parameters[10].Value = model.state_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Auction.Model.item GetModel(int item_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select item_id,item_name,item_remark,item_desc,kind_id,addtime,endtime,init_price,max_price,owner_id,winer_id,state_id from item ");
strSql.Append(" where item_id=@item_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@item_id", MySqlDbType.Int32)
};
parameters[0].Value = item_id;
Auction.Model.item model = new Auction.Model.item();
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.txtitem_name.Text.Trim().Length == 0)
{
strErr += "item_name不能为空！\\n";
}
if (this.txtitem_remark.Text.Trim().Length == 0)
{
strErr += "item_remark不能为空！\\n";
}
if (this.txtitem_desc.Text.Trim().Length == 0)
{
strErr += "item_desc不能为空！\\n";
}
if (!PageValidate.IsNumber(txtkind_id.Text))
{
strErr += "kind_id格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtaddtime.Text))
{
strErr += "addtime格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtendtime.Text))
{
strErr += "endtime格式错误！\\n";
}
if (this.txtinit_price.Text.Trim().Length == 0)
{
strErr += "init_price不能为空！\\n";
}
if (this.txtmax_price.Text.Trim().Length == 0)
{
strErr += "max_price不能为空！\\n";
}
if (!PageValidate.IsNumber(txtowner_id.Text))
{
strErr += "owner_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txtwiner_id.Text))
{
strErr += "winer_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txtstate_id.Text))
{
strErr += "state_id格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string item_name = this.txtitem_name.Text;
string item_remark = this.txtitem_remark.Text;
string item_desc = this.txtitem_desc.Text;
int kind_id = int.Parse(this.txtkind_id.Text);
DateTime addtime = DateTime.Parse(this.txtaddtime.Text);
DateTime endtime = DateTime.Parse(this.txtendtime.Text);
string init_price = this.txtinit_price.Text;
string max_price = this.txtmax_price.Text;
int owner_id = int.Parse(this.txtowner_id.Text);
int winer_id = int.Parse(this.txtwiner_id.Text);
int state_id = int.Parse(this.txtstate_id.Text);
Auction.Model.item model = new Auction.Model.item();
model.item_name = item_name;
model.item_remark = item_remark;
model.item_desc = item_desc;
model.kind_id = kind_id;
model.addtime = addtime;
model.endtime = endtime;
model.init_price = init_price;
model.max_price = max_price;
model.owner_id = owner_id;
model.winer_id = winer_id;
model.state_id = state_id;
Auction.BLL.item bll = new Auction.BLL.item();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
