/// <summary>
/// 更新产品参数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMSPPara(MSProductPara model)
{
string safeslq = "";
safeslq = "UPDATE MS_ProductPara SET ";
if (model.PID != null && model.PID != "")
{
safeslq += "PID='" + model.PID + "',";
}
if (model.ParName != null && model.ParName != "")
{
safeslq += "ParName='" + model.ParName + "',";
}
if (model.Price != null && model.Price.ToString() != "")
{
safeslq += "Price='" + model.Price + "',";
}
safeslq += " Stock=" + (model.Stock > 0?model.Stock:0) + ", ";
safeslq += " ParState=" + (model.ParState == 1 ? 1 : 0) + " ";
safeslq += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加产品参数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMSPPara(MSProductPara model)
{
string sql = @"INSERT INTO [MS_ProductPara]
([ID],[PID],[ParName],[Price],[Stock],[ParState],[AddTime])
VALUES
(@ID,@PID,@ParName,@Price,@Stock,@ParState,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@PID", model.PID),
new System.Data.SqlClient.SqlParameter("@ParName", model.ParName),
new System.Data.SqlClient.SqlParameter("@Price", model.Price),
new System.Data.SqlClient.SqlParameter("@Stock", model.Stock > 0?model.Stock:0),
new System.Data.SqlClient.SqlParameter("@ParState", (model.ParState == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "")
{
if (paraname.Text.Trim() != null && paraname.Text.Trim() != "" &&
paravalue.Text.Trim() != null && paravalue.Text.Trim() != "")
{
MSProductParaDAL ParaDal = new MSProductParaDAL();
MSProductPara paraModel = new MSProductPara();
paraModel.ParName = paraname.Text;
paraModel.ParState = 0;
paraModel.ID = strID;
//paraModel.ParValue = paravalue.Text;
if (ParaDal.UpdateMSPPara(paraModel))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "请输入相应名称或参数值！");
}
}
else
{
return;
}
}
void showdetailinfo()
{
MSProductParaDAL ParaDal = new MSProductParaDAL();
DataSet ParaDs = ParaDal.GetParaDetail(strID);
MSProductPara ParaModel = DataConvert.DataRowToModel <MSProductPara>(ParaDs.Tables[0].Rows[0]);
paraname.Text = ParaModel.ParName;
//paravalue.Text = ParaModel.ParValue;
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "")
{
if (paraname.Text.Trim() != null && paraname.Text.Trim() != "" &&
paravalue.Text.Trim() != null && paravalue.Text.Trim() != "" &&
setpvalue.Value.Trim() != null && setpvalue.Value.Trim() != "")
{
MSProductParaDAL ParaDal = new MSProductParaDAL();
if (ParaDal.ExistMSPPara(paraname.Text, setpvalue.Value))
{
MessageBox.Show(this, "该参数已经存在！");
}
else
{
MSProductPara paraModel = new MSProductPara();
paraModel.PID = setpvalue.Value;
paraModel.ParName = paraname.Text;
//paraModel.ParValue = paravalue.Text;
paraModel.ParState = 0;
paraModel.ID = Guid.NewGuid().ToString("N").ToUpper();
if (ParaDal.AddMSPPara(paraModel))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
}
else
{
MessageBox.Show(this, "请选择相应产品或参数值！");
}
}
else
{
return;
}
}
/// <summary>
/// 添加属性列表
/// </summary>
bool AddProductModel()
{
string isnull = ""; bool result = false;
if (Request["m"] != null && Request["m"] != "")
{
try
{
mcount = Convert.ToInt32(Common.Common.NoHtml(Request["m"]));
}
catch (Exception)
{
}
}
if (mcount > 0)
{
MSProductParaDAL paraDal = new MSProductParaDAL();
for (int i = 0; i < mcount; i++)
{
string m_model = string.Empty;
string m_price = string.Empty;
string m_stock = string.Empty; int stock = 0;
#region --------------------获取model值---------------------
try
{
m_model = HttpContext.Current.Request.Form.Get("model" + i).ToString();
}
catch (Exception)
{
m_model = isnull;
}
try
{
m_price = HttpContext.Current.Request.Form.Get("mprice" + i).ToString();
}
catch (Exception)
{
m_price = isnull;
}
try
{
m_stock = HttpContext.Current.Request.Form.Get("mstock" + i).ToString();
}
catch (Exception)
{
m_stock = isnull;
}
if (m_stock != null && m_stock != "")
{
try
{
stock = Convert.ToInt32(m_stock);
}
catch (Exception)
{
}
}
#endregion
MSProductPara paraModel = new MSProductPara();
paraModel.ParName = m_model;
paraModel.Price = Convert.ToDecimal(m_price);
paraModel.Stock = Convert.ToInt32(stock);
paraModel.ID = Guid.NewGuid().ToString("N").ToUpper();
paraModel.PID = pid;
if (paraDal.AddMSPPara(paraModel))
{
result = true;
}
}
}
return(result);
}
void GetProductDetail()
{
string ptitle = string.Empty;
string shopID = string.Empty;
string puid = string.Empty;
int paracount = 0;
#region 产品详细
MSProductDAL productDal = new MSProductDAL();
MSProduct productModel = new MSProduct();
DataSet productds = productDal.GetProductDetail(strpid);
if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0)
{
productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]);
ptitle = productModel.Ptitle;
puid = productModel.CustomerID;
if (productModel.SID != null && productModel.SID != "")
{
shopID = productModel.SID;
}
}
#endregion
#region 店铺详细
MSShop shopModel = new MSShop();
if (shopID != null && shopID != "")
{
MSShopDAL shopDal = new MSShopDAL();
DataSet shopds = shopDal.GetMSShopDetail(shopID);
if (shopds != null && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0)
{
shopModel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]);
}
}
#endregion
#region 图集列表
MSProductAtlasDAL atlasDal = new MSProductAtlasDAL();
List <MSProductAtlas> AtlasListModel = new List <MSProductAtlas>();
DataSet atlasds = atlasDal.GetProductAtlasByPID(strpid);
if (null != atlasds && atlasds.Tables.Count > 0 && atlasds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in atlasds.Tables[0].Rows)
{
MSProductAtlas atlasModel = DataConvert.DataRowToModel <MSProductAtlas>(row);
AtlasListModel.Add(atlasModel);
}
}
#endregion
#region 产品参数列表
//MSProductParaDAL paraDal = new MSProductParaDAL();
//DataSet paramds = paraDal.GetProductParamByPID(strpid);
//string paramlist = string.Empty;
//if (null != paramds && paramds.Tables.Count > 0 && paramds.Tables[0].Rows.Count > 0)
//{
// for (int i = 0; i < paramds.Tables[0].Rows.Count; i++)
// {
// paramlist += "<tr>\r\n";
// string paraname = paramds.Tables[0].Rows[i]["ParName"].ToString();
// string paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString();
// paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n";
// try
// {
// i = i + 1;
// paraname = paramds.Tables[0].Rows[i]["ParName"].ToString();
// paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString();
// paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n";
// }
// catch (Exception)
// {
// paramlist += "<td class=\"td_title\"> </td><td> </td>\r\n";
// }
// paramlist += "</tr>\r\n";
// }
//}
#endregion
#region -------获取产品型号及价格------------
ProductPara ParaModel = new ProductPara();
List <MSProductPara> paralistmodel = new List <MSProductPara>();
MSProductParaDAL paraDal = new MSProductParaDAL();
DataSet parads = paraDal.GetMaxMinPrice(strpid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
paracount = parads.Tables[0].Rows.Count;
ParaModel = DataConvert.DataRowToModel <ProductPara>(parads.Tables[0].Rows[0]);
}
parads = null;
parads = paraDal.GetProductParamByPID(strpid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in parads.Tables[0].Rows)
{
MSProductPara paramodel = DataConvert.DataRowToModel <MSProductPara>(item);
paralistmodel.Add(paramodel);
}
}
#endregion
#region ----------------根据产品编号获取联系方式--------------------
MSShopContactsDAL contactDal = new MSShopContactsDAL();
MSShopContacts contactModel = new MSShopContacts();
DataSet contactDs = contactDal.GetContactDetailByPID(strpid);
MSCustomersDAL CustomerDal = new MSCustomersDAL();
MSCustomers CustomerModel = new MSCustomers();
DataSet PuidDs = null; int contactcount = 0;
if (contactDs != null && contactDs.Tables.Count > 0 && contactDs.Tables[0].Rows.Count > 0)
{
contactModel = DataConvert.DataRowToModel <MSShopContacts>(contactDs.Tables[0].Rows[0]);
contactcount = 1;
}
else
{
if (puid != null && puid != "")
{
PuidDs = CustomerDal.GetCustomerDetail(puid);
}
if (PuidDs != null && PuidDs.Tables.Count > 0 && PuidDs.Tables[0].Rows.Count > 0)
{
CustomerModel = DataConvert.DataRowToModel <MSCustomers>(PuidDs.Tables[0].Rows[0]);
}
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/Product_detail.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = ptitle;
if (shopModel != null)
{
context.TempData["shopdetail"] = shopModel;
}
context.TempData["productdetail"] = productModel;
context.TempData["atlaslist"] = AtlasListModel;
if (contactcount > 0)
{
context.TempData["contactdetail"] = contactModel;
}
else
{
context.TempData["contactdetail"] = CustomerModel;
}
context.TempData["customid"] = customid;
//context.TempData["paramlist"] = paramlist;
context.TempData["paracount"] = paracount;
context.TempData["paramodel"] = ParaModel;
context.TempData["paralist"] = paralistmodel;
context.TempData["footer"] = "奥琦微商易";
context.TempData["errorscript"] = errorscript;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 获取购物信息
/// </summary>
void GetInfo()
{
#region 产品详细
MSProductDAL productDal = new MSProductDAL();
MSProduct productModel = new MSProduct();
DataSet productds = productDal.GetProductDetail(strpid);
MSProductAtlasDAL atlasDal = new MSProductAtlasDAL();
MSProductAtlas atlasdetailmodel = null;
DataSet atlasDs = null;
if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0)
{
productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]);
}
#endregion
#region 获取产品默认展示图
atlasDs = atlasDal.GetDefaultAtlasByPid(strpid);
foreach (DataRow atlasrow in atlasDs.Tables[0].Rows)
{
atlasdetailmodel = DataConvert.DataRowToModel <MSProductAtlas>(atlasrow);
}
#endregion
#region -----------获取型号尺码----------------
MSProductPara paraModel = new MSProductPara();
MSProductParaDAL paraDal = new MSProductParaDAL();
DataSet parads = paraDal.GetParaDetail(mid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
paraModel = DataConvert.DataRowToModel <MSProductPara>(parads.Tables[0].Rows[0]);
}
#endregion
#region 获取收货地址
MSDeliveryAddressDAL addressDal = new MSDeliveryAddressDAL();
MSDeliveryAddress defaultadModel = new MSDeliveryAddress();
List <MSDeliveryAddress> damodellist = new List <MSDeliveryAddress>();
string stradwhere = string.Empty;
stradwhere = "and [UID]='" + customid + "' ";
DataSet addressds = addressDal.GetDAList(3, stradwhere);
if (null != addressds && addressds.Tables.Count > 0 && addressds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in addressds.Tables[0].Rows)
{
MSDeliveryAddress damodel = DataConvert.DataRowToModel <MSDeliveryAddress>(row);
damodellist.Add(damodel);
}
}
#endregion
string customerphone = string.Empty;
MSCustomers customerModel = new MSCustomers();
if (customid != null && customid != "")
{
MSCustomersDAL CustomerDal = new MSCustomersDAL();
DataSet customerds = CustomerDal.GetCustomerDetail(customid);
if (customerds != null && customerds.Tables.Count > 0 && customerds.Tables[0].Rows.Count > 0)
{
customerModel = DataConvert.DataRowToModel <MSCustomers>(customerds.Tables[0].Rows[0]);
}
}
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/setOrder.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["productdetail"] = productModel;
context.TempData["atlas"] = atlasdetailmodel;
context.TempData["paramodel"] = paraModel;
context.TempData["errorscript"] = errorscript;
context.TempData["dalist"] = damodellist;
context.TempData["customer"] = customerModel;
context.TempData["openid"] = openid;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 输出到页面
/// </summary>
void GetHtmlInfo()
{
MSProduct ProductModel = new MSProduct();
MSProductDAL ProductDal = new MSProductDAL();
MSProductCategory categoryModel = new MSProductCategory();
MSProductCategoryDAL categoryDal = new MSProductCategoryDAL();
DataSet detailds = null; string cid = string.Empty; string bigcid = string.Empty;
#region ------------------产品详细-------------------------
if (pid.Trim() != null && pid.Trim() != "")
{
detailds = ProductDal.GetProductDetail(pid);
if (detailds != null && detailds.Tables.Count > 0 && detailds.Tables[0].Rows.Count > 0)
{
ProductModel = DataConvert.DataRowToModel <MSProduct>(detailds.Tables[0].Rows[0]);
cid = ProductModel.Cid;
}
}
#endregion
#region -----------类别绑定---------------
if (cid != null && cid != "")
{
string upid = string.Empty;
try
{
upid = categoryDal.GetMSPCategoryValueByID("UpID", cid).ToString();
}
catch (Exception)
{
}
if (upid != null && upid != "")
{
bigcid = upid;
}
else
{
bigcid = cid;
}
}
#endregion
#region -------------获取图集---------------
MSProductAtlasDAL atlasDal = new MSProductAtlasDAL();
DataSet atlasDs = atlasDal.GetProductAtlasByPID(pid);
int rowcount = 0; atlaslist = "";
if (atlasDs != null && atlasDs.Tables.Count > 0 && atlasDs.Tables[0].Rows.Count > 0)
{
rowcount = atlasDs.Tables[0].Rows.Count;
for (int i = 0; i < rowcount; i++)
{
string imgurl = atlasDs.Tables[0].Rows[i]["PimgUrl"].ToString();
string imgid = atlasDs.Tables[0].Rows[i]["ID"].ToString();
string datarow = string.Empty;
atlaslist += "\r\n<dd type=\"image\">\r\n" +
"<input type=\"file\" accept=\"image/jpg, image/jpeg, image/png\" " +
"onchange=\"form_pics.addImg(this);\" name=\"pics" + i + "\"><img dataid=\"" + imgid +
"\" src=\"" + imgurl + "\">" +
"\r\n<span onclick=\"form_pics.removeImg(this);\"> </span>\r\n" +
"</dd>";
}
}
if (rowcount < 8)
{
atlaslist += "\r\n<dd>\r\n" +
"<input type=\"file\" accept=\"image/jpg, image/jpeg, image/png\" " +
"onchange=\"form_pics.addImg(this);\" name=\"pics" + rowcount + "\"><img src=\"images/upload.png\">" +
"\r\n<span onclick=\"form_pics.removeImg(this);\"> </span>\r\n" +
"</dd>";
}
altascount = rowcount;
#endregion
#region ------------------绑定型号------------------
List <MSProductPara> paralistmodel = new List <MSProductPara>();
MSProductParaDAL paraDal = new MSProductParaDAL();
DataSet parads = paraDal.GetProductParamByPID(pid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in parads.Tables[0].Rows)
{
MSProductPara paramodel = DataConvert.DataRowToModel <MSProductPara>(row);
paralistmodel.Add(paramodel);
}
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/EditeProduct.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["customid"] = customerid;
context.TempData["atlaslist"] = atlaslist;
context.TempData["altascount"] = altascount;
context.TempData["cid"] = cid;
context.TempData["bigcid"] = bigcid;
context.TempData["pdetail"] = ProductModel;
context.TempData["paralist"] = paralistmodel;
context.TempData["footer"] = "奥琦微商易";
context.TempData["errorscript"] = errorscript;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
