/// <summary>
/// 增加一条数据
/// </summary>
public void Add(AuctionProductModel model)
{
DbCommand dbCommand = dbw.GetStoredProcCommand("UP_mwAuctionProduct_ADD");
dbw.AddInParameter(dbCommand, "@AuctionId", DbType.Int32, model.AuctionID);
dbw.AddInParameter(dbCommand, "@ProductName", DbType.AnsiString, model.ProductName);
dbw.AddInParameter(dbCommand, "@SmallImage", DbType.AnsiString, model.SmallImage);
dbw.AddInParameter(dbCommand, "@MediumImage", DbType.AnsiString, model.MediumImage);
dbw.AddInParameter(dbCommand, "@OutLinkUrl", DbType.AnsiString, model.OutLinkUrl);
dbw.AddInParameter(dbCommand, "@StartPrice", DbType.Decimal, model.StartPrice);
dbw.AddInParameter(dbCommand, "@AddPrices", DbType.String, model.AddPrices);
dbw.AddInParameter(dbCommand, "@CurPrice", DbType.Decimal, model.CurPrice);
dbw.AddInParameter(dbCommand, "@Brief", DbType.AnsiString, model.Brief);
dbw.AddInParameter(dbCommand, "@StartTime", DbType.DateTime, model.StartTime);
dbw.AddInParameter(dbCommand, "@EndTime", DbType.DateTime, model.EndTime);
dbw.AddInParameter(dbCommand, "@Status", DbType.Byte, model.Status);
dbw.AddInParameter(dbCommand, "@CateID", DbType.Int32, model.CategoryID);
dbw.AddInParameter(dbCommand, "@CatePath", DbType.String, model.CategoryPath);
dbw.AddInParameter(dbCommand, "@userid", DbType.String, model.UserID);
dbw.AddInParameter(dbCommand, "@truename", DbType.String, model.TrueName);
dbw.AddInParameter(dbCommand, "@phone", DbType.String, model.Phone);
dbw.AddInParameter(dbCommand, "@cellphone", DbType.String, model.CellPhone);
dbw.AddInParameter(dbCommand, "@postcode", DbType.String, model.PostCode);
dbw.AddInParameter(dbCommand, "@region", DbType.String, model.Region);
dbw.AddInParameter(dbCommand, "@address", DbType.String, model.Address);
dbw.AddInParameter(dbCommand, "@inserttime", DbType.String, model.InsertTime);
dbw.AddInParameter(dbCommand, "@updatetime", DbType.String, model.UpdateTime);
dbw.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public AuctionProductModel ReaderBind(IDataReader dataReader)
{
AuctionProductModel model=new AuctionProductModel();
object ojb;
ojb = dataReader["AuctionId"];
if(ojb != null && ojb != DBNull.Value)
{
model.AuctionID=(int)ojb;
}
model.ProductName=dataReader["ProductName"].ToString();
model.SmallImage=dataReader["SmallImage"].ToString();
model.MediumImage=dataReader["MediumImage"].ToString();
model.OutLinkUrl=dataReader["OutLinkUrl"].ToString();
ojb = dataReader["StartPrice"];
if(ojb != null && ojb != DBNull.Value)
{
model.StartPrice=(decimal)ojb;
}
ojb = dataReader["AddPrices"];
if(ojb != null && ojb != DBNull.Value)
{
model.AddPrices=ojb.ToString();
}
ojb = dataReader["CurPrice"];
if(ojb != null && ojb != DBNull.Value)
{
model.CurPrice=(decimal)ojb;
}
model.Brief=dataReader["Brief"].ToString();
ojb = dataReader["StartTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.StartTime=(DateTime)ojb;
}
ojb = dataReader["EndTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.EndTime=(DateTime)ojb;
}
ojb = dataReader["Status"];
if(ojb != null && ojb != DBNull.Value)
{
model.Status=Convert.ToInt32(ojb);
}
ojb = dataReader["cateid"];
if (ojb != null && ojb != DBNull.Value)
{
model.CategoryID = Convert.ToInt32(ojb);
}
ojb = dataReader["catepath"];
if (ojb != null && ojb != DBNull.Value)
{
model.CategoryPath = Convert.ToString(ojb);
}
model.UserID = Convert.ToString(dataReader["userid"]);
model.TrueName = Convert.ToString(dataReader["truename"]);
model.Phone = Convert.ToString(dataReader["phone"]);
model.CellPhone = Convert.ToString(dataReader["cellphone"]);
model.PostCode = Convert.ToString(dataReader["postcode"]);
model.Region = Convert.ToString(dataReader["region"]);
model.Address = Convert.ToString(dataReader["address"]);
model.InsertTime = Convert.ToDateTime(dataReader["inserttime"]);
model.UpdateTime = Convert.ToDateTime(dataReader["updatetime"]);
return model;
}
protected void Button_Add_Click(object sender, EventArgs e)
{
string ErrorMessage = String.Empty;
if (String.IsNullOrEmpty(TextBox_ProductName.Text)) { ErrorMessage += "产品名称不能为空\\n"; }
if (String.IsNullOrEmpty(FileUpload_ProductImage.FileName)) { ErrorMessage += "产品图片不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_StartPrice.Text) || !PageValidate.IsDecimal(TextBox_StartPrice.Text)) { ErrorMessage += "起始价格不正确\\n"; }
if (String.IsNullOrEmpty(TextBox_AddPrices.Text))
{
ErrorMessage += "每次加价不能为空\\n";
}
else
{
if (TextBox_AddPrices.Text.Replace('，', ',').Split(',').Length > 7)
{
ErrorMessage += "最多只能输入7个加价\\n";
}
}
if (String.IsNullOrEmpty(TextBox_StartTime.Text)/* validate */) { ErrorMessage += "开始时间不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_EndTime.Text)/* validate */) { ErrorMessage += "结束时间不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_Brief.Text)) { ErrorMessage += "简要介绍不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_TrueName.Text)) { ErrorMessage += "姓名不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_Phone.Text) && String.IsNullOrEmpty(TextBox_CellPhone.Text)) { ErrorMessage += "请输入您的电话号码或者手机号码\\n"; }
else { /* validate */}
if (String.IsNullOrEmpty(TextBox_PostCode.Text) || !PageValidate.IsNumber(TextBox_PostCode.Text)) { ErrorMessage += "邮政编码不能为空\\n"; }
if (String.IsNullOrEmpty(TextBox_Address.Text)) { ErrorMessage += "地址不能为空\\n"; }
RegionInfo regionInfo = ucRegion.GetSelectedRegionInfo();
if (String.IsNullOrEmpty(regionInfo.Province) || String.IsNullOrEmpty(regionInfo.City))
{
ErrorMessage += "所在地选择不完整\\n";
}
if (!String.IsNullOrEmpty(ErrorMessage))
{
MessageBox.Show(this, ErrorMessage);
return;
}
int AuctionID = CommDataHelper.GetNewSerialNum(AppType.MagicWorld);
string[] ProductImages;
if (MagicWorldImageRule.SaveProductMainImage(AuctionID, FileUpload_ProductImage.PostedFile, out ProductImages))
{
AuctionProductModel model = new AuctionProductModel();
MagicCategoryModel cate = new MagicCategoryBll().GetModel(CategoryID);
model.AuctionID = AuctionID;
model.ProductName = StringUtility.RemoveHtmlTags(TextBox_ProductName.Text);
model.CategoryID = CategoryID;
model.CategoryPath = cate.CategoryPath;
model.SmallImage = ProductImages[0];
model.MediumImage = ProductImages[1];
model.StartPrice = Convert.ToDecimal(TextBox_StartPrice.Text);
model.CurPrice = model.StartPrice;
model.AddPrices = TextBox_AddPrices.Text.Replace('，', ',').EndsWith(",") ? TextBox_AddPrices.Text.Replace('，', ',').Substring(0, TextBox_AddPrices.Text.Length - 1) : TextBox_AddPrices.Text.Replace('，', ',');
model.StartTime = Convert.ToDateTime(TextBox_StartTime.Text);
model.EndTime = Convert.ToDateTime(TextBox_EndTime.Text);
model.Brief = TextBox_Brief.Text;
model.InsertTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
model.UserID = GetUserID();
model.TrueName = TextBox_TrueName.Text;
model.Phone = TextBox_Phone.Text;
model.CellPhone = TextBox_CellPhone.Text;
model.PostCode = TextBox_PostCode.Text;
model.Region = String.Format("{0} {1} {2}", regionInfo.Province, regionInfo.City, regionInfo.County);
model.Address = TextBox_Address.Text;
model.Status = (int)AuctionProductStatus.尚未审核;
model.OutLinkUrl = "";
bll.Add(model);
Response.Redirect("../SubmitSucc.aspx");
}
else
{
MessageBox.Show(this, "图片上传失败");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(AuctionProductModel model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(AuctionProductModel model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<AuctionProductModel> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List<AuctionProductModel> modelList = new List<AuctionProductModel>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
AuctionProductModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new AuctionProductModel();
if(ds.Tables[0].Rows[n]["AuctionId"].ToString()!="")
{
model.AuctionID=int.Parse(ds.Tables[0].Rows[n]["AuctionId"].ToString());
}
model.ProductName=ds.Tables[0].Rows[n]["ProductName"].ToString();
model.SmallImage=ds.Tables[0].Rows[n]["SmallImage"].ToString();
model.MediumImage=ds.Tables[0].Rows[n]["MediumImage"].ToString();
model.OutLinkUrl=ds.Tables[0].Rows[n]["OutLinkUrl"].ToString();
if(ds.Tables[0].Rows[n]["StartPrice"].ToString()!="")
{
model.StartPrice=decimal.Parse(ds.Tables[0].Rows[n]["StartPrice"].ToString());
}
if(ds.Tables[0].Rows[n]["AddPrices"].ToString()!="")
{
model.AddPrices= ds.Tables[0].Rows[n]["AddPrices"].ToString();
}
if(ds.Tables[0].Rows[n]["CurPrice"].ToString()!="")
{
model.CurPrice=decimal.Parse(ds.Tables[0].Rows[n]["CurPrice"].ToString());
}
model.Brief=ds.Tables[0].Rows[n]["Brief"].ToString();
if(ds.Tables[0].Rows[n]["StartTime"].ToString()!="")
{
model.StartTime=DateTime.Parse(ds.Tables[0].Rows[n]["StartTime"].ToString());
}
if(ds.Tables[0].Rows[n]["EndTime"].ToString()!="")
{
model.EndTime=DateTime.Parse(ds.Tables[0].Rows[n]["EndTime"].ToString());
}
if(ds.Tables[0].Rows[n]["Status"].ToString()!="")
{
model.Status=int.Parse(ds.Tables[0].Rows[n]["Status"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
