public void Update(PawnProductModel model)
{
DbCommand command = dbw.GetStoredProcCommand("UP_mwPawnProduct_Update");
dbw.AddInParameter(command, "@pawnproductid", DbType.Int32, model.PawnProductID);
dbw.AddInParameter(command, "@pawnproductname", DbType.String, model.PawnProductName);
dbw.AddInParameter(command, "@pawnprice", DbType.Decimal, model.PawnPrice);
dbw.AddInParameter(command, "@sellingprice", DbType.Decimal, model.SellingPrice);
dbw.AddInParameter(command, "@cateid", DbType.Int32, model.CateID);
dbw.AddInParameter(command, "@catepath", DbType.String, model.CatePath);
dbw.AddInParameter(command, "@stock", DbType.Int32, model.Stock);
dbw.AddInParameter(command, "@smallimage", DbType.String, model.SmallImage);
dbw.AddInParameter(command, "@mediumimage", DbType.String, model.MediumImage);
dbw.AddInParameter(command, "@brief", DbType.String, model.Brief);
dbw.AddInParameter(command, "@inserttime", DbType.DateTime, model.InsertTime);
dbw.AddInParameter(command, "@changetime", DbType.DateTime, model.ChangeTime);
dbw.AddInParameter(command, "@status", DbType.Int32, model.Status);
dbw.AddInParameter(command, "@sortvalue", DbType.Int32, model.SortValue);
dbw.AddInParameter(command, "@userid", DbType.String, model.UserID);
dbw.AddInParameter(command, "@deadtime", DbType.DateTime, model.DeadTime);
dbw.AddInParameter(command, "@truename", DbType.String, model.TrueName);
dbw.AddInParameter(command, "@phone", DbType.String, model.Phone);
dbw.AddInParameter(command, "@cellphone", DbType.String, model.CellPhone);
dbw.AddInParameter(command, "@postcode", DbType.String, model.PostCode);
dbw.AddInParameter(command, "@region", DbType.String, model.Region);
dbw.AddInParameter(command, "@address", DbType.String, model.Address);
dbw.ExecuteNonQuery(command);
}
private void BindData()
{
PawnProductModel model = bll.GetModel(PawnProductID);
MagicCategoryBll cateBll = new MagicCategoryBll();
if (model.Status != (int)PawnProductStatus.尚未收当)
{
MessageBox.Show(this, "该商品已被审核，禁止编辑！");
Response.Redirect("List.aspx");
return;
}
CategoryID = model.CateID;
if (!String.IsNullOrEmpty(Request.QueryString["categoryid"]))
{
CategoryID = Convert.ToInt32(Request.QueryString["categoryid"]);
}
TextBox_Category.Text = new MagicCategoryBll().GetModel(CategoryID).CategoryName;
TextBox_ProductName.Text = model.PawnProductName;
TextBox_EndTime.Text = model.DeadTime.ToString("yyyy-MM-dd");
TextBox_Price.Text = model.PawnPrice.ToString("0.00");
TextBox_Brief.Text = model.Brief;
TextBox_TrueName.Text = model.TrueName;
TextBox_Phone.Text = model.Phone;
TextBox_CellPhone.Text = model.CellPhone;
TextBox_PostCode.Text = model.PostCode;
TextBox_Address.Text = model.Address;
ucRegion.PresetRegionInfo(RegionInfo.GetRegionPathByName(model.Region.Split(' ')[model.Region.Split(' ').Length - 1]));
}
private void BindData()
{
PawnProductModel model = bll.GetModel(PawnProductID);
MemberInfo user = MemberInfo.GetFullInfo(model.UserID);
if (model.Status != (int)PawnProductStatus.冻结)
{
Image_Medium.ImageUrl = MagicWorldImageRule.GetMainImageUrl(model.MediumImage);
Image_Small.ImageUrl = MagicWorldImageRule.GetMainImageUrl(model.SmallImage);
Literal_ProductName.Text = model.PawnProductName;
Literal_Price.Text = model.SellingPrice.ToString("0.00");
Literal_UserID.Text = model.UserID;
Literal_Brief.Text = model.Brief;
Literal_UserID2.Text = user.UserId;
string UserPhone = String.Empty, Address = String.Empty;
switch (user.UserType)
{
case MemberType.Personal:
PersonMemberInfo puser = (PersonMemberInfo)user;
UserPhone = puser.Mobile == String.Empty ? puser.Telephone : puser.Mobile;
Address = String.Empty;
break;
case MemberType.Famly:
FamlyMemberInfo fuser = (FamlyMemberInfo)user;
UserPhone = fuser.Mobile == String.Empty ? fuser.Telephone : fuser.Mobile;
Address = fuser.Address;
break;
case MemberType.Company:
CompanyMemberInfo cuser = (CompanyMemberInfo)user;
UserPhone = cuser.Mobile == String.Empty ? cuser.Telephone : cuser.Mobile;
Address = cuser.Address;
break;
case MemberType.School:
SchoolMemberInfo suser = (SchoolMemberInfo)user;
UserPhone = suser.Mobile == String.Empty ? suser.Telephone : suser.Mobile;
Address = suser.Address;
break;
default:
UserPhone = String.Empty;
Address = String.Empty;
break;
}
Literal_Phone.Text = UserPhone;
Literal_Address.Text = Address;
Repeater_Comment.DataSource = CmtBll.GetList(AppType.MagicWorld, PawnProductID);
Repeater_Comment.DataBind();
}
else
{
Response.End();
}
}
private PawnProductModel BindModel(DataRow row)
{
PawnProductModel model = new PawnProductModel()
{
Address = Convert.ToString(row["address"]),
Brief = Convert.ToString(row["brief"]),
CateID = Convert.ToInt32(row["cateid"]),
CatePath = Convert.ToString(row["catepath"]),
CellPhone = Convert.ToString(row["cellphone"]),
ChangeTime = Convert.ToDateTime(row["changetime"]),
DeadTime = Convert.ToDateTime(row["deadtime"]),
InsertTime = Convert.ToDateTime(row["inserttime"]),
MediumImage = Convert.ToString(row["mediumimage"]),
PawnPrice = Convert.ToDecimal(row["pawnprice"]),
PawnProductID = Convert.ToInt32(row["pawnproductid"]),
PawnProductName = Convert.ToString(row["pawnproductname"]),
Phone = Convert.ToString(row["phone"]),
PostCode = Convert.ToString(row["postcode"]),
Region = Convert.ToString(row["region"]),
SellingPrice = Convert.ToInt32(row["sellingprice"]),
SmallImage = Convert.ToString(row["smallimage"]),
SortValue = Convert.ToInt32(row["sortvalue"]),
Status = Convert.ToInt16(row["status"]),
Stock = Convert.ToInt32(row["stock"]),
TrueName = Convert.ToString(row["truename"]),
UserID = Convert.ToString(row["userid"])
};
return(model);
}
private void BindData()
{
PawnProductModel model = bll.GetModel(PawnProductID);
TextBox_ProductName.Text = model.PawnProductName;
TextBox_PawnPrice.Text = model.PawnPrice.ToString();
TextBox_SellingPrice.Text = model.SellingPrice.ToString();
TextBox_Brief.Text = model.Brief;
TextBox_Count.Text = model.Stock.ToString();
//TextBox_Keyword.Text = model.Keywords;
Image_ProductImage.ImageUrl = MagicWorldImageRule.GetMainImageUrl(model.MediumImage);
}
public PawnProductModel GetModel(int PawnProductID)
{
DbCommand command = dbr.GetStoredProcCommand("UP_mwPawnProduct_Get");
dbr.AddInParameter(command, "@pawnproductid", DbType.Int32, PawnProductID);
DataTable dt = dbr.ExecuteDataSet(command).Tables[0];
PawnProductModel model = null;
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
model = BindModel(dt.Rows[0]);
}
return(model);
}
protected void Button_OK_Click(object sender, EventArgs e)
{
string strErr = "";
if (TextBox_ProductName.Text == "")
{
strErr += "拍品名称为空！\\n";
}
if (TextBox_Count.Text == "" || !PageValidate.IsNumber(TextBox_Count.Text))
{
strErr += "拍品数量为空或者不是数字！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
PawnProductModel model = bll.GetModel(PawnProductID);
if (FileUpload_ProductImage.FileName != "")
{
string[] ProductImages;
if (MagicWorldImageRule.SaveProductMainImage(PawnProductID, FileUpload_ProductImage.PostedFile, out ProductImages))
{
model.SmallImage = ProductImages[0];
model.MediumImage = ProductImages[1];
//model.LargeImage = ProductImages[2];
}
else
{
MessageBox.Show(this, "图片上传失败");
return;
}
}
model.PawnProductName = TextBox_ProductName.Text;
model.PawnPrice = Convert.ToDecimal(TextBox_PawnPrice.Text);
model.SellingPrice = Convert.ToDecimal(TextBox_SellingPrice.Text);
model.Brief = TextBox_Brief.Text;
//model.Keywords = TextBox_Keyword.Text;
model.Stock = Convert.ToInt32(TextBox_Count.Text);
model.ChangeTime = DateTime.Now;
model.Status = (int)PawnProductStatus.已收当;
bll.Update(model);
Response.Redirect("List.aspx");
}
public void Update(PawnProductModel model)
{
dal.Update(model);
}
public void Add(PawnProductModel model)
{
dal.Add(model);
}
