/// <summary>
/// 通过id查询商品对象
/// </summary>
/// <param name="gid"></param>
/// <returns></returns>
public static YC_Goods selectObjectById(int gid)
{
DataTable dt = BLL.Goods.selectOneByID(gid);
YC_Goods g = new YC_Goods();
DataRow dr = dt.Rows[0];
g.Name = dr["Name"].ToString();
g.Cxprice = Convert.ToDouble(dr["CXPrice"].ToString());
g.SCPrice = Convert.ToDouble(dr["SCPrice"].ToString());
g.DesImg1Url = dr["DesImg1Url"].ToString();
g.DesImg2Url = dr["DesImg2Url"].ToString();
g.DesImg3Url = dr["DesImg3Url"].ToString();
g.AllSize = dr["AllSize"].ToString();
g.DetailImages = dr["DetailImages"].ToString();
return(g);
}
public void getGoods()
{
if (Request.QueryString["GID"] == null)
{
Response.Write("{status:\"failure\"}");
}
else
{
int gid = Convert.ToInt32(Request.QueryString["GID"]);
YC_Goods goodobj = BLL.Goods.selectObjectById(gid);
string allsize = goodobj.AllSize;
string cxprice = goodobj.Cxprice.ToString();
string goodname = goodobj.Name;
string img1 = goodobj.DesImg1Url;
Response.Write("{status:\"success\",allsize:\"" + allsize + "\",cxprice:\"" + cxprice + "\",goodname:\"" + goodname + "\",imgurl:\"" + img1 + "\"}");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == false || FileUpload2.HasFile == false || FileUpload3.HasFile == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "fileup", "<script>warningDesPic();</script>");
}
else if (txtName.Text.Trim() == "" || txtSize.Text.Trim() == "" || txtSCPrice.Text.Trim() == "" || txtCXPrice.Text.Trim() == "")
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "fileup", "<script>warningEmpty();</script>");
}
else
{
string name = txtName.Text.Trim();
//市场价格
string scprice = txtSCPrice.Text.Trim();
//促销价格
string cxprice = txtCXPrice.Text.Trim();
//可选尺码
string selectSize = txtSize.Text.Trim();
string File1 = FileUpload1.FileName;
string File2 = FileUpload2.FileName;
string File3 = FileUpload3.FileName;
string DetailDes = FCKeditor1.Value;
//string type1, type2, type3;
//type1 = File1.Substring(File1.LastIndexOf("."));
//type2 = File2.Substring(File2.LastIndexOf("."));
//type3 = File3.Substring(File3.LastIndexOf("."));
///这里还没有判断是否是图片
//////
//随机种子
//Random rd = new Random();
//int sj1= rd.Next(10000, 99999999);
//int sj2 = rd.Next(10000, 99999999);
//int sj3 = rd.Next(10000, 99999999);
//File1 = File1 + sj1.ToString();
//File2 = File2 + sj1.ToString();
//File3 = File3 + sj1.ToString();
string a1 = getFileName(File1);
string a2 = getFileName(File2);
string a3 = getFileName(File3);
string path1 = Server.MapPath("~\\productImg\\" + a1);
string path2 = Server.MapPath("~\\productImg\\" + a2);
string path3 = Server.MapPath("~\\productImg\\" + a3);
FileUpload1.SaveAs(path1);
FileUpload2.SaveAs(path2);
FileUpload1.SaveAs(path3);
string goodtype = ddlType.SelectedValue;
///
YC_Goods goods = new YC_Goods();
goods.Gtid = Convert.ToInt32(goodtype);
goods.Name = name;
goods.SCPrice = Convert.ToDouble(scprice);
goods.Cxprice = Convert.ToDouble(cxprice);
goods.DesImg1Url = a1;
goods.DesImg2Url = a2;
goods.DesImg3Url = a3;
goods.DetailImages = DetailDes;
goods.AllSize = txtSize.Text;
BLL.AdminGoodManager.add(goods);
ClientScript.RegisterClientScriptBlock(this.GetType(), "xx", "<script>alert(\"上架成功\")</script>");
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="good"></param>
/// <returns></returns>
public static int add(YC_Goods good)
{
return(Convert.ToInt32(DAL.GoodsServer.add(good)));
}
//添加商品
public static object add(YC_Goods good)
{
sqltext = " insert into [dbo].[YC_Goods]([GTID],[Name],[SCPrice],[CXPrice],[DesImg1Url],[DesImg2Url],[DesImg3Url],[DetailImages],[AllSize])values('" + good.Gtid + "', '" + good.Name + "', '" + good.SCPrice + "', '" + good.SCPrice + "', '" + good.DesImg1Url + "', '" + good.DesImg2Url + "', '" + good.DesImg3Url + "', '" + good.DetailImages + "','" + good.AllSize + "'); ";
return(SQLHELPER.ExecuteNonQuery(sqltext));
}
