protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ProductID = "24";
if (Request.QueryString["ID"] != null)
{
ProductID = Request.QueryString["ID"].ToString();
}
IList <ProductModel> lpm = AddNewProductBLL.GetAllProductInfoByID(int.Parse(ProductID));
if (lpm.Count > 0)
{
foreach (ProductModel pm in lpm)
{
lblPCode.Text = pm.ProductCode.ToString();
lblPName.Text = pm.ProductName;
lblPType.Text = ProductModeBLL.GetProductNameByID(pm.PID);
lblPrice.Text = pm.PreferentialPrice.ToString("0.00");
lblPPV.Text = pm.PreferentialPV.ToString("0.00");
lblPSpec.Text = SetParametersBLL.GetProductSpecInfoByID(pm.ProductSpecID).Rows[0]["ProductSpecName"].ToString();
div_PDetails.InnerHtml = pm.Description.Length > 1?pm.Description:"无";
ProductImage.ImageUrl = "ReadImage.aspx?ProductID=" + ProductID;
}
}
}
}
private void BindDropDownList()
{
ddlProductColor.DataTextField = "ProductColorName";
ddlProductColor.DataValueField = "ProductColorID";
ddlProductColor.DataSource = AddNewProductBLL.GetProductColorInfo();
ddlProductColor.DataBind();
ViewState["isDataBind"] = "Y";
}
/// <summary>
/// 初始化国家和汇率
/// </summary>
/// <param name="countryID"></param>
private void IniteCurrency(string countryCode)
{
//通过国家编码获取国家名称
this.lblCountry.Text = AddNewProductBLL.GetCountryNameByCountryCode(countryCode);
//通过国家编码联合查询获取汇率名称
Label1.Text = AddNewProductBLL.GetMoreCurrencyNameByCountryCode(countryCode);
Label2.Text = Label1.Text;
Label3.Text = Label1.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
//获取标准币种
bzCurrency = CommonDataBLL.GetStandard();
// Permissions.ThreeRedirect(Page, "../Member/" + Permissions.redirUrl);
if (!IsPostBack)
{
if (Session["UserType"].ToString() == "2")
{
top.Visible = false;
//bottom.Visible = false;
STop1.Visible = true;
SLeft1.Visible = true;
}
else
{
top.Visible = true;
//bottom.Visible = true;
STop1.Visible = false;
SLeft1.Visible = false;
}
string ProductID = "24";
if (Request.QueryString["ID"] != null)
{
ProductID = Request.QueryString["ID"].ToString();
}
IList <ProductModel> lpm = AddNewProductBLL.GetAllProductInfoByID(int.Parse(ProductID));
if (lpm.Count > 0)
{
foreach (ProductModel pm in lpm)
{
lblPCode.Text = pm.ProductCode.ToString();
lblPName.Text = pm.ProductName;
lblPType.Text = ProductModeBLL.GetProductNameByID(pm.PID);
lblPrice.Text = pm.PreferentialPrice.ToString("0.00");// ((pm.PreferentialPrice) * (Convert.ToDecimal(AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))))).ToString("0.00");
//lblPPV.Text = pm.PreferentialPV.ToString("0.00");
DataTable dt_gg = SetParametersBLL.GetProductSpecInfoByID(pm.ProductSpecID);
if (dt_gg != null && dt_gg.Rows.Count > 0)
{
lblPSpec.Text = dt_gg.Rows[0]["ProductSpecName"].ToString();
}
div_PDetails.InnerHtml = pm.Details_TX.Length > 1 ? pm.Details_TX : "无";
ProductImage.ImageUrl = "../ReadImage.aspx?ProductID=" + ProductID;
}
}
GetCount();
Translations();
}
}
/// <summary>
/// 删除产品类
/// </summary>
/// <param name="id">产品ID</param>
private void deleteFold(int id)
{
string productList = string.Empty;
//检查某产品类是否发生了业务
bool delFlag = AddNewProductBLL.CheckProductKindWheatherHasOperation(id, out productList);
if (delFlag)
{
this.lblMessage.Text = GetTran("003256", "该产品类已有业务发生，因此不能删除！");
return;
}
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
// before delete
ChangeLogs cl = new ChangeLogs("Product", "ltrim(rtrim(ProductID))");
cl.AddRecordtran(tran, id.ToString());
///删除产品类以及该产品类所属的产品
AddNewProductBLL.DelProductKindByID(tran, productList);
cl.DeletedIntoLogstran(tran, ChangeCategory.company7, Session["Company"].ToString(), ENUM_USERTYPE.objecttype1);
///提交事务
tran.Commit();
}
catch
{
tran.Rollback();
lblMessage.Text = GetTran("003258", "产品类删除失败,请联系管理员！");
return;
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
this.lblMessage.Text = GetTran("003260", "产品类删除成功!");
}
/// <summary>
/// 绑定国家编码和名称
/// </summary>
private void DataBindCountry()
{
DataTable dt = AddNewProductBLL.GetCountryIDCodeNameOrderByID();
if (dt.Rows.Count<1)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("001959", "对不起，没有可选国家!")));
return;
}
else
{
this.ddlCountry.DataSource = dt;
this.ddlCountry.DataTextField = "Name";
this.ddlCountry.DataValueField = "CountryCode";
this.DataBind();
//默认值为第一个
this.ddlCountry.SelectedValue = "0";
}
}
/// <summary>
/// 删除指定产品
/// </summary>
/// <param name="id">产品ID</param>
private void deleteItem(int id)
{
///检查某产品是否放生了业务
if (AddNewProductBLL.CheckProductWheatherHasOperation(id))
{
lblMessage.Text = GetTran("003252", "对不起,该产品已有业务发生，因此不能删除!");
return;
}
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
// before delete
ChangeLogs cl = new ChangeLogs("Product", "ltrim(rtrim(ProductID))");
cl.AddRecordtran(tran, Convert.ToString(id));
//删除指定产品
AddNewProductBLL.DelProductByID(tran, id);
cl.DeletedIntoLogstran(tran, ChangeCategory.company7, Session["Company"].ToString(), ENUM_USERTYPE.objecttype1);
//提交事务
tran.Commit();
}
catch
{
tran.Rollback();
lblMessage.Text = GetTran("003254", "产品删除失败，请联系管理员!");
return;
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
lblMessage.Text = GetTran("003255", "产品删除成功");
}
protected void doAddButtton_Click(object sender, EventArgs e)
{
//图片大小
int upPhotoLength = 0;
byte[] ImageContent = new Byte[upPhotoLength];
int intStatus = 0;
//获取上传的文件名
string fileName = this.UpPhotos.FileName;
//获取物理路径
string strImageType = string.Empty;
Stream PhotoStream = null;
//当包含文件时(即上传有文件)
if (UpPhotos.HasFile)
{
//为0表示被上传的图片的类型不符合要求，1表示符合要求
int ImageType = 0;
HttpPostedFile upPhoto = UpPhotos.PostedFile;
upPhotoLength = upPhoto.ContentLength;
if (upPhotoLength > 1024000)
{
this.lblMessage.Text = GetTran("004073", "产品图片的大小请限制在300K之内") + "...";
return;
}
//获取上传文件的扩展名
strImageType = Path.GetExtension(fileName).ToLower();
String[] Extensions = { ".gif", ".png", ".jpeg", ".jpg", ".bmp", ".pdf" };
for (int i = 0; i < Extensions.Length; i++)
{
if (strImageType == Extensions[i])
{
//图片类型
strImageType = Extensions[i];
ImageType = 1;
}
}
if (ImageType == 1)
{
try
{
PhotoStream = upPhoto.InputStream;
ImageContent = new Byte[upPhotoLength];
intStatus = PhotoStream.Read(ImageContent, 0, upPhotoLength);
}
catch
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("004076", "上传图片失败，请联系管理员!")));
return;
}
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("004079", "请检查图片类型!")));
return;
}
}
string productType = uclProductType.SelectedValue;
string typeName = txtProductType.Text.Trim();
//添加类
bool isFold = this.addClass.Checked;
//大单位
int bignumber = 0;
///长、宽、高
decimal Length = 0, Width = 0, High = 0;
///重量
decimal Weight = 0;
///验证预警数量
int alertCount = 0;
///价格和积分
decimal costPrice = 0, commonPrice = 0, commonPV = 0, preferentialPrice = 0, preferentialPV = 0;
///验证产品信息
if (!isFold)
{
//判断产品名称是否为空
if (txtProductName.Text.Trim() == "")
{
this.lblMessage.Text = GetTran("004082", "名称不能为空！");
return;
}
///产品编码
if (this.txtProductCode.Text.Trim() == "")
{
this.lblMessage.Text = GetTran("004085", "产品编码不能为空！");
return;
}
///判断产品编码是否重复
else
{
///添加产品
if (editingID == 0)
{
//获取编码的数目
int proCodeCount = AddNewProductBLL.CheckProductCodeIsExist(this.txtProductCode.Text.Trim());
if (proCodeCount > 0)
{
lblMessage.Text = GetTran("004088", "对不起，编码重复!");
return;
}
}
///修改产品
else
{
///获取行数，判断编码是否存在
int proCodeCount = AddNewProductBLL.CheckProductCodeIsExistByID(this.txtProductCode.Text.Trim(), Convert.ToInt32(this.editingID));
if (proCodeCount > 0)
{
lblMessage.Text = GetTran("004088", "对不起，编码重复!");
return;
}
}
}
///验证产品型号
if (this.txtProductType.Text.Trim() == "")
{
this.lblMessage.Text = GetTran("004091", "产品型号不能为空！");
return;
}
if (txtCostPrice.Text.Trim() == "")
{
costPrice = 0;
}
if (txtCommonPrice.Text.Trim() == "")
{
commonPrice = 0;
}
if (txtPreferentialPrice.Text.Trim() == "")
{
preferentialPrice = 0;
}
if (txtCommonPV.Text == "")
{
commonPV = 0;
}
if (txtPreferentialPV.Text == "")
{
preferentialPV = 0;
}
if (txtCostPrice.Text.Trim() != "" || txtCommonPrice.Text.Trim() != "" || txtCommonPV.Text.Trim() != "" || txtPreferentialPV.Text.Trim() != "" || txtPreferentialPrice.Text.Trim() != "")
{
try
{
costPrice = Convert.ToDecimal(this.txtCostPrice.Text.Trim());
commonPrice = Convert.ToDecimal(this.txtCommonPrice.Text.Trim());
commonPV = Convert.ToDecimal(this.txtCommonPV.Text.Trim());
preferentialPrice = Convert.ToDecimal(this.txtPreferentialPrice.Text.Trim());
preferentialPV = Convert.ToDecimal(this.txtPreferentialPV.Text.Trim());
}
catch
{
this.lblMessage.Text = GetTran("004093", "请正确输入价格,积分!");
return;
}
if (costPrice < 0 || commonPrice < 0 || commonPV < 0 || preferentialPrice < 0 || preferentialPV < 0)
{
this.lblMessage.Text = GetTran("004094", "请注意，价格,积分不能为负数!");
return;
}
}
///验证大单位
if (uclProductBigUnit.SelectedItemText == "")
{
this.lblMessage.Text = GetTran("004095", "大单位名称不能为空！");
return;
}
///验证小单位
if (uclProductSmallUnit.SelectedItemText == "")
{
this.lblMessage.Text = GetTran("004096", "小单位名称不能为空！");
return;
}
///大小单位比例
if (txtBigSmallMultiple.Text.Trim() == "")
{
this.lblMessage.Text = GetTran("004098", "大小单位比例不能为空！");
return;
}
else
{
try
{
bignumber = Convert.ToInt32(txtBigSmallMultiple.Text);
}
catch
{
lblMessage.Text = GetTran("004100", "对不起，大小单位转换必须是整数！");
return;
}
if (bignumber <= 0)
{
lblMessage.Text = GetTran("004101", "对不起，大小单位转换必须是大于或等于1的整数！");
return;
}
}
Length = 0;
Width = 0;
High = 0;
///验证重量
if (txtWeight.Text.Trim() == "")
{
this.lblMessage.Text = GetTran("004104", "对不起，重量不能为空！");
return;
}
else
{
try
{
Weight = Convert.ToDecimal(txtWeight.Text.Trim());
}
catch
{
this.lblMessage.Text = GetTran("004106", "请正确输入重量！");
return;
}
if (Weight < 0)
{
this.lblMessage.Text = GetTran("004107", "对不起，重量必须大于或等于0！");
return;
}
}
///验证预警数量
if (txtAlertnessCount.Text.Trim() != "")
{
try
{
alertCount = Convert.ToInt32(txtAlertnessCount.Text);
}
catch
{
this.lblMessage.Text = GetTran("004108", "对不起，预警数量必须是整数！");
return;
}
if (alertCount < 0)
{
this.lblMessage.Text = GetTran("004109", "对不起，预警数量必须是大于或等于0的整数！");
return;
}
}
}
///产品说明
if (txtDescription.Text.Length > 200)
{
this.lblMessage.Text = GetTran("004110", "产品说明不能超过两百字！");
return;
}
string productName = this.txtProductName.Text.Trim();
///判断产品类名称是否为空
if (isFold && productName == "")
{
this.lblMessage.Text = GetTran("004082", "名称不能为空！");
return;
}
///为了和后面的说明区别，故命名为productDescription(2009-10-22)
string productDescription = ValidData.InputText(this.txtDescription.Text.Trim());
string productSpec = uclProductSpec.SelectedValue;
string productColor = uclProductColor.SelectedValue;
string productStatus = uclProductStatus.SelectedValue;
string productSexType = uclProductSexType.SelectedValue;
string productArea = ValidData.InputText(txtProductArea.Text.Trim());
string productSize = uclProductSize.SelectedValue;
string productBigUnit = uclProductBigUnit.SelectedValue;
string productSmallUnit = uclProductSmallUnit.SelectedValue;
string strMessage;
//On sale
int isSell = 0;
if (this.ChboxHide.Checked == true)
{
isSell = 0;
}
//No sale
if (this.ChboxHide.Checked == false)
{
isSell = 1;
}
#region 产品新增部分[详细、允许销售的团队人数] xyc
int detailsMaxLenth = 200000;
string details_TX = Request.Form["txtDetails"] == null ? "" : Request.Form["txtDetails"].ToString();
details_TX = ValidData.RemoveScript(details_TX);
//if (details_TX.Length > detailsMaxLenth)
//{
// Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("详细内容过多，请适当减少产品的详细描述内容！"));
// return;
//}
productModel.Details_TX = details_TX;
int onlyForGroup = 0;
if (this.rbtnN.Checked == true)
{
onlyForGroup = 0;
}
else if (this.rbtnY.Checked == true)
{
onlyForGroup = 1;
}
productModel.OnlyForGroup_NR = onlyForGroup;
Regex rx = new Regex(@"[；|;]", RegexOptions.IgnoreCase);
this.txt_GroupIDS_AZ_TX.Text = rx.Replace(this.txt_GroupIDS_AZ_TX.Text, ";");
this.txt_GroupIDS_TJ_TX.Text = rx.Replace(this.txt_GroupIDS_TJ_TX.Text, ";");
string GroupIDS_AZ_TX = this.txt_GroupIDS_AZ_TX.Text;
string GroupIDS_TJ_TX = this.txt_GroupIDS_TJ_TX.Text;
Regex rx0 = new Regex(@"\w|;]+", RegexOptions.IgnoreCase);
if (!string.IsNullOrEmpty(GroupIDS_AZ_TX) && !rx0.IsMatch(GroupIDS_AZ_TX))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("格式错误，多安置团队顶点编号请用分号隔开！"));
return;
}
if (!string.IsNullOrEmpty(GroupIDS_TJ_TX) && !rx0.IsMatch(GroupIDS_TJ_TX))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("多推荐团队顶点编号请用分号隔开！"));
return;
}
if (onlyForGroup == 1)
{
if (string.IsNullOrEmpty(GroupIDS_AZ_TX) && string.IsNullOrEmpty(GroupIDS_TJ_TX))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("请填写允许销售的团队顶点编号！"));
return;
}
else
{
#region 对会员编号的真实性进行验证
//验证编号是否存在
bool bhValidate = true;
string notExistID = string.Empty;
string[] bhsAZ = rx.Split(GroupIDS_AZ_TX);
string[] bhsTJ = rx.Split(GroupIDS_TJ_TX);
List <string> group_ids = new List <string>();
foreach (string s in bhsAZ)
{
if (!string.IsNullOrEmpty(s))
{
group_ids.Add(s);
}
}
foreach (string s in bhsTJ)
{
if (!group_ids.Contains(s))
{
if (!string.IsNullOrEmpty(s))
{
group_ids.Add(s);
}
}
}
MemberInfoModel member = null;
foreach (string s in group_ids)
{
member = MemberInfoModifyBll.getMemberInfo(s);
if (member == null)
{//不存在
bhValidate = false;
notExistID += s + ",";
}
}
if (notExistID != string.Empty)
{
notExistID = notExistID.Substring(0, notExistID.Length - 1);
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('会员[" + notExistID + "]不存在！');</script>", false);
return;
}
#endregion
}
}
productModel.GroupIDS_AZ_TX = GroupIDS_AZ_TX;
productModel.GroupIDS_TJ_TX = GroupIDS_TJ_TX;
#endregion
productModel.IsFold = Convert.ToInt32(isFold);
productModel.ProductName = productName;
if (!isFold)
{
productModel.ProductTypeID = Convert.ToInt32(productType);
productModel.ProductTypeName = typeName;
productModel.ProductSpecID = Convert.ToInt32(productSpec);
productModel.ProductColorID = Convert.ToInt32(productColor);
productModel.ProductSizeID = Convert.ToInt32(productSize);
productModel.ProductSexTypeID = Convert.ToInt32(productSexType);
productModel.ProductStatusID = Convert.ToInt32(productStatus);
productModel.BigProductUnitID = Convert.ToInt32(productBigUnit);
productModel.SmallProductUnitID = Convert.ToInt32(productSmallUnit);
productModel.BigSmallMultiple = bignumber;
productModel.ProductArea = productArea;
productModel.CostPrice = costPrice;
productModel.CommonPrice = commonPrice;
productModel.CommonPV = commonPV;
productModel.PreferentialPrice = preferentialPrice;
productModel.PreferentialPV = preferentialPV;
productModel.AlertnessCount = alertCount;
productModel.Description = productDescription;
productModel.Weight = Weight;
if (ImageContent.Length > 0)
{
productModel.ProductImage = ImageContent;
}
else
{
int imageSate = Convert.ToInt32(ViewState["imageState"]);
if (imageSate == 0)
{
productModel.ProductImage = ImageContent;
}
if (imageSate == 1)
{
productModel.ProductImage = (byte[])ViewState["image"];
}
}
productModel.ImageType = strImageType;
productModel.CountryCode = ViewState["CountryCode"].ToString();
productModel.Currency = Convert.ToInt32(ViewState["CurrencyID"]);
productModel.IsCombineProduct = (byte)(chbcombine.Checked ? 1 : 0);
productModel.OperateIP = CommonDataBLL.OperateIP;
productModel.OperateNum = CommonDataBLL.OperateBh;
productModel.ProductCode = this.txtProductCode.Text.Trim();
productModel.IsSell = isSell;
productModel.Length = Length;
productModel.Width = Width;
productModel.High = High;
productModel.Details_TX = Request.Form["txtDetails"].ToString();
productModel.GroupIDS_AZ_TX = txt_GroupIDS_AZ_TX.Text;
productModel.GroupIDS_TJ_TX = txt_GroupIDS_TJ_TX.Text;
productModel.OnlyForGroup_NR = rbtnN.Checked == true ? 0 : 1;
if (this.ChboxFirst.Checked && this.ChboxAgain.Checked)
{
productModel.Yongtu = 0;
}
else
{
if (this.ChboxFirst.Checked)
{
productModel.Yongtu = 1;
}
if (this.ChboxAgain.Checked)
{
productModel.Yongtu = 2;
}
}
}
else
{
productModel.ProductTypeID = 0;
productModel.ProductTypeName = "";
productModel.ProductSpecID = 0;
productModel.ProductColorID = 0;
productModel.ProductSexTypeID = 0;
productModel.ProductStatusID = 0;
productModel.BigProductUnitID = 0;
productModel.SmallProductUnitID = 0;
productModel.BigSmallMultiple = 0;
productModel.ProductArea = "";
productModel.CostPrice = costPrice;
productModel.CommonPrice = commonPrice;
productModel.CommonPV = commonPV;
productModel.PreferentialPrice = preferentialPrice;
productModel.PreferentialPV = preferentialPV;
productModel.AlertnessCount = alertCount;
productModel.Description = productDescription;
productModel.ProductImage = ImageContent;
productModel.ImageType = strImageType;
productModel.Weight = 0;
productModel.CountryCode = ViewState["CountryCode"].ToString();
productModel.Currency = Convert.ToInt32(ViewState["CurrencyID"]);
productModel.OperateIP = CommonDataBLL.OperateIP;
productModel.OperateNum = CommonDataBLL.OperateBh;
productModel.ProductCode = "";
productModel.IsSell = isSell;
}
if (editingID == 0) //添加数据
{
bool isEsist = AddNewProductBLL.ProductNameIsExist(productName);
///产品
if (!isFold)
{
if (isEsist)
{
this.lblMessage.Text = GetTran("004113", "此产品名称已经存在!");
return;
}
}
///产品类
else
{
if (isEsist)
{
this.lblMessage.Text = GetTran("004116", "此产品类名已经存在!");
return;
}
}
productModel.PID = Convert.ToInt32(this.pID);
strMessage = GetTran("000492", "添加");
string oldID = "";
string languageName = "";
string languageID = "";
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
//增加产品
AddNewProductBLL.AddProduct(tran, productModel);
//---多语言产品操作
///获取新产品信息
//DataTable dtpro = AddNewProductBLL.GetNewProductInfo();
//if(dtpro.Rows.Count>0)
//{
// oldID=dtpro.Rows[0]["productid"].ToString();
// languageName=dtpro.Rows[0]["productname"].ToString();
// string description=dtpro.Rows[0]["Description"].ToString().Trim();
// //获取语言种类(ID>1)
// DataTable dtlang = AddNewProductBLL.GetLanguageIDByID();
// for(int i=0;i<dtlang.Rows.Count;i++)
// {
// languageID=dtlang.Rows[i][0].ToString();
// //获取----获取(产品目录)是否插入
// int count = AddNewProductBLL.GetLanguageTransCountByID(Convert.ToInt32(languageID));
// if(count==0)
// {
// ///向产品名称等翻译表插入相关记录
// languageTrans.TableName="Product";
// languageTrans.OldID=1;
// languageTrans.ColumnsName = productName;
// languageTrans.LanguageName = GetTran("004117","产品目录");
// languageTrans.LanguageID =Convert.ToInt32(languageID);
// AddNewProductBLL.AddLanguageTrans(tran, languageTrans);
// }
// if(description!="")
// {
// /// 向产品名称等翻译表插入相关记录
// languageTrans.TableName = "Product";
// languageTrans.OldID =Convert.ToInt32(oldID);
// languageTrans.ColumnsName ="Description";
// languageTrans.LanguageName=description;
// languageTrans.LanguageID=Convert.ToInt32(languageID);
// AddNewProductBLL.AddLanguageTrans(tran, languageTrans);
// }
// ///向产品名称等翻译表插入相关记录
// languageTrans.TableName = "Product";
// languageTrans.OldID =Convert.ToInt32(oldID);
// languageTrans.ColumnsName = productName;
// languageTrans.LanguageName= languageName;
// languageTrans.LanguageID =Convert.ToInt32(languageID);
// AddNewProductBLL.AddLanguageTrans(tran, languageTrans);
// }
//}
tran.Commit();
}
catch (System.Exception ee)
{
tran.Rollback();
System.Diagnostics.Trace.WriteLine(ee.Message);
throw;
}
}
}
}
else //修改数据
{
strMessage = GetTran("000259", "修改");
// before delete
ChangeLogs cl = new ChangeLogs("Product", "ProductID");
cl.AddRecord(this.editingID);
//--多语言产品操作(只更新产品说明)
//获取产品说明
//string Description = AddNewProductBLL.GetDescriptionByID(Convert.ToInt32(this.editingID)).Trim();
//string langID="";
//if(Description=="" && productDescription.Trim()!="")
//{
// //查找ID>1的所有ID
// DataTable dtlang = AddNewProductBLL.GetLanguageIDByID();
// for(int i=0;i<dtlang.Rows.Count;i++)
// {
// langID=dtlang.Rows[i][0].ToString();
// ///插入相关记录
// languageTrans.TableName = "Product";
// languageTrans.OldID = Convert.ToInt32(this.editingID);
// languageTrans.ColumnsName = Description;
// languageTrans.LanguageName = productDescription;
// languageTrans.LanguageID =Convert.ToInt32(langID);
// AddNewProductBLL.AddLanguageTrans(languageTrans);
// }
//}
///注意传参产品ID
productModel.ProductID = this.editingID;
int updCount = AddNewProductBLL.UpdProduct(productModel);
if (updCount > 0)
{
cl.AddRecord(this.editingID);
cl.ModifiedIntoLogs(ChangeCategory.company7, Session["Company"].ToString(), ENUM_USERTYPE.objecttype1);
this.lblMessage.Text = strMessage + GetTran("004124", "成功！");
}
else
{
this.lblMessage.Text = strMessage + GetTran("004128", "失败,请联系管理员!");
}
}
if (this.editingID == 0)
{
this.lblMessage.Text += GetTran("004132", "您可以继续添加此类下的产品");
}
this.lblMessage.Text += "(" + GetTran("004140", "按 关闭 后可查看新数据") + ")";
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("001401", "操作成功!") + "');reloadopener();</script>");
SetValue();
}
/// <summary>
/// 编辑时获取原来数据
/// </summary>
/// <param name="itemID">产品ID</param>
/// <param name="isFold">是否是产品类</param>
private void getItem(int itemID, bool isFold)
{
this.lblMessage.Text = GetTran("004069", "修改产品数据") + "...";
//根据产品ID获取指定的产品信息
IList <ProductModel> product = AddNewProductBLL.GetAllProductInfoByID(itemID);
int isSell = product[0].IsSell;
//1 stand for no sale
if (isSell == 1)
{
this.ChboxHide.Checked = false;
}
//0 stand for on sale
else
{
this.ChboxHide.Checked = true;
}
//当编辑为“类”时，隐藏掉不需要修改的字段，只留下“名称”和“说明”输入框
if (isFold)
{
this.addClass.Checked = true;
this.txtProductName.Text = product[0].ProductName;
this.txtDescription.Text = product[0].Description;
panel1.Visible = false;
}
//如果修改的是“产品”
else
{
panel1.Visible = false;
this.txtProductName.Text = product[0].ProductName;
txtProductType.Text = product[0].ProductTypeName;
uclProductSpec.SelectedValue = product[0].ProductSpecID.ToString();
uclProductSexType.SelectedValue = product[0].ProductSexTypeID.ToString();
this.txtCostPrice.Text = product[0].CostPrice.ToString();
this.txtCommonPrice.Text = product[0].CommonPrice.ToString();
this.txtPreferentialPrice.Text = product[0].PreferentialPrice.ToString();
this.txtDescription.Text = product[0].Description;
this.txtCommonPV.Text = product[0].CommonPV.ToString();
this.txtPreferentialPV.Text = product[0].PreferentialPV.ToString();
this.txtProductCode.Text = product[0].ProductCode;
uclProductColor.SelectedValue = product[0].ProductColorID.ToString();
txtProductArea.Text = product[0].ProductArea;
txtWeight.Text = product[0].Weight.ToString();
uclProductSize.SelectedValue = product[0].ProductSizeID.ToString();
uclProductBigUnit.SelectedValue = product[0].BigProductUnitID.ToString();
uclProductSmallUnit.SelectedValue = product[0].SmallProductUnitID.ToString();
uclProductStatus.SelectedValue = product[0].ProductStatusID.ToString();
txtAlertnessCount.Text = product[0].AlertnessCount.ToString();
txtBigSmallMultiple.Text = product[0].BigSmallMultiple.ToString();
//---------组合产品
bool b = Convert.ToBoolean(product[0].IsCombineProduct);
chbcombine.Checked = Convert.ToBoolean(product[0].IsCombineProduct);
#region //xyc新增2011-12-6
txtDetails.Value = product[0].Details_TX;
int onlyForGroup = product[0].OnlyForGroup_NR;
if (onlyForGroup == 0)
{
this.rbtnN.Checked = true;
}
else if (onlyForGroup == 1)
{
this.rbtnY.Checked = true;
}
this.txt_GroupIDS_AZ_TX.Text = product[0].GroupIDS_AZ_TX == null ? "" : product[0].GroupIDS_AZ_TX.ToString();
this.txt_GroupIDS_TJ_TX.Text = product[0].GroupIDS_TJ_TX == null ? "" : product[0].GroupIDS_TJ_TX.ToString();
#endregion
if (product[0].ProductImage.Length > 1)
{
imgProduct.ImageUrl = FormatURL(product[0].ProductID);
}
else
{
imgProduct.ImageUrl = @"~/images/pht.GIF";
}
this.lblMessage.Text = GetTran("004071", "编辑产品信息");
//1 stand for edit image,0 stand for add image
ViewState["imageState"] = 1;
ViewState["image"] = product[0].ProductImage;
if (product[0].Yongtu == 0)
{
this.ChboxFirst.Checked = true;
this.ChboxAgain.Checked = true;
}
else if (product[0].Yongtu == 1)
{
this.ChboxFirst.Checked = true;
this.ChboxAgain.Checked = false;
}
else if (product[0].Yongtu == 2)
{
this.ChboxAgain.Checked = true;
this.ChboxFirst.Checked = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.ComRedirect(Page, Permissions.redirUrl);
Response.Cache.SetExpires(DateTime.Now.ToUniversalTime());
Permissions.CheckManagePermission(EnumCompanyPermission.StorageProductTreeManager);
if (!IsPostBack)
{
if (Request.QueryString["action"] == null || Request.QueryString["action"] == "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("003202", "程序调用错误，请联系管理员!")));
Response.End();
}
this.action = Request.QueryString["action"].Trim();
//产品ID
this.id = Convert.ToInt32(Request.QueryString["id"].Trim().Replace("N", ""));
ViewState["ID"] = this.id;
//接收的国家编码
if (Request.QueryString["countryCode"] != null)
{
ViewState["CountryCode"] = Request.QueryString["countryCode"].Trim();
///通过联合查询获取币种ID
ViewState["CurrencyID"] = AddNewProductBLL.GetMoreCurrencyIDByCountryCode(ViewState["CountryCode"].ToString());
///初始化
IniteCurrency(ViewState["CountryCode"].ToString());
}
else
{
//通过产品ID获取币种ID
ViewState["CurrencyID"] = AddNewProductBLL.GetCurrencyIDByProductID(Convert.ToInt32(id));
//通过产品ID获取国家ID
ViewState["CountryCode"] = AddNewProductBLL.GetCountryCodeByProductID(Convert.ToInt32(id));
IniteCurrency(ViewState["CountryCode"].ToString());
}
int AdStyleCount = 0, AdProductCount = 0, EdStCount = 0, DeStCount = 0, EdPrCount = 0, DePrCount = 0;
//Check Rights
AdStyleCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManageAddStyle);
AdProductCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManagerAddProduct);
EdStCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManagerEditStyle);
DeStCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManagerDeleteStyle);
EdPrCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManagerEditProduct);
DePrCount = Permissions.GetPermissions(EnumCompanyPermission.StorageProductTreeManagerDeleteProduct);
//Add Product
if (this.action == "add")
{
imgProduct.Visible = false;
if (AdProductCount.ToString() != "2108")
{
lblMessage.Text = GetTran("003207", "对不起，你没有添加产品权限!");
//Right No Pass
AddEditRightNoPass_Visible_Enable();
return;
}
this.lblMessage.Text = GetTran("003212", "当前") + "：" + GetTran("006851", "添加新品");
lblname.Text = GetTran("002186", "产品");
this.pID = this.id;
this.editingID = 0;
this.addP.Checked = true;
//1 stand for edit image,0 stand for add image
ViewState["imageState"] = 0;
//Right Pass
AddEditRightPass_Visible_Enable();
}
//Add ProductKind
else if (action == "addFold")
{
if (AdStyleCount.ToString() != "2107")
{
lblMessage.Text = GetTran("003222", "对不起,您没有添加新类权限!");
//No Pass
AddEditFoldNoPass_Visible_Enable();
return;
}
lblname.Text = GetTran("003224", "类别");
this.lblMessage.Text = GetTran("003212", "当前") + "：" + GetTran("003228", "添加新类");
this.pID = this.id;
this.editingID = 0;
this.addClass.Checked = true;
Panel3.Visible = false;
//Pass
AddEditFoldPass_Visible_Enable();
lblclassName.Visible = true;
//CombineProduct
chbcombine.Visible = false;
}
else if (this.action == "editFold")
{
if (EdStCount.ToString() != "2109")
{
lblMessage.Text = GetTran("003232", "对不起,您没有修改产品类权限!");
//No Pass
AddEditFoldNoPass_Visible_Enable();
return;
}
lblname.Text = GetTran("003224", "类别");
this.lblMessage.Text = GetTran("003212", "当前") + "：" + GetTran("003236", "编辑产品类");
this.getItem(id, true);
this.editingID = this.id;
//Pass
AddEditFoldPass_Visible_Enable();
//CombineProduct
chbcombine.Visible = false;
Panel3.Visible = false;
}
//Edit Product
else if (this.action == "editItem")
{
imgProduct.Visible = true;
if (EdPrCount.ToString() != "2111")
{
lblMessage.Text = GetTran("003239", "对不起,您没有修改产品权限!");
//Right No Pass
AddEditRightNoPass_Visible_Enable();
return;
}
lblname.Text = GetTran("002186", "产品");
this.lblMessage.Text = GetTran("003212", "当前") + "：" + GetTran("003243", "编辑产品");
this.getItem(id, false);
this.editingID = this.id;
//Right Pass
AddEditRightPass_Visible_Enable();
}
else if (this.action == "deleteItem")
{
if (DePrCount.ToString() != "2112")
{
lblMessage.Text = GetTran("003247", "对不起,您没有删除产品权限!");
//No Pass
DeleteRightNoPass_Visible_Enable();
return;
}
Panel3.Visible = false;
Panel4.Visible = false;
//No Pass
DeleteRightNoPass_Visible_Enable();
this.deleteItem(id);
}
else if (this.action == "deleteFold")
{
if (DeStCount.ToString() != "2110")
{
lblMessage.Text = GetTran("003251", "对不起,您没有删除产品类权限!");
//No Pass
DeleteRightNoPass_Visible_Enable();
return;
}
Panel3.Visible = false;
Panel4.Visible = false;
//No Pass
DeleteRightNoPass_Visible_Enable();
this.deleteFold(id);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("003202", "程序调用错误,请联系管理员!")));
Response.End();
}
}
Translations_More();
}
