//绑定数据
public void BindData(bool start)
{
if (WX.Main.GetConfigItem("Product_ISDept") == "1")
{
WX.PDT.Product.MODEL product = WX.Request.rProduct;
liproductName.Text = product.ProductName.ToString();
BindDropList();
divdept.Visible = true;
PageInit();
if (WX.Main.GetConfigItem("Product_OneDept") == "0")
{
GridView1.Visible = true;
}
}
string sSql = "select pp.*,td.Name DeptName from PDT_ProductDept pp left join TE_Departments td on pp.DeptID=td.ID where pp.ProductID=" + WX.Request.rProductId;
if (start)
{
int count = WX.Main.GetPagedRowsCount(sSql);
AspNetPager1.RecordCount = count;
AspNetPager1.PageSize = 10;
AspNetPager1.CurrentPageIndex = 1;
}
GridView1.DataSource = WX.Main.GetPagedRows(sSql, -1, "order by ID asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
GridView1.DataBind();
if (Request["ProductDeptID"] != null && Request["ProductDeptID"] != "")
{
btnSave.Text = "编辑";
}
}
private void InitComponent()
{
string productId = NumberRule.NewDataModel(16).GetValue(16);
this.txtProductID.Text = productId;
DataTable categoryData = XSql.GetDataTable("exec [dbo].[sp_get_tree_table] 'PDT_ProductCategory','ID','Name','ParentID','ID',0,1,5");
this.ddlProductCategory.DataSource = categoryData;
this.ddlProductCategory.DataTextField = "name";
this.ddlProductCategory.DataValueField = "id";
this.ddlProductCategory.DataBind();
DataTable unitData = XSql.GetDataTable("SELECT * FROM Ass_Unit");
this.ddlUnits.DataSource = unitData;
this.ddlUnits.DataValueField = "ID";
this.ddlUnits.DataTextField = "UnitName";
this.ddlUnits.DataBind();
if (WX.Main.GetConfigItem("Product_ISDept") == "1" && WX.Main.GetConfigItem("Product_OneDept") == "1")
{
BindDropList();
}
if (Request["ProductID"] != null && Request["ProductID"] != "")
{
MenuBar1.Key = "Sale_Product_Edit";
MenuBar1.Param1 = "{Q:ProductID}";
MenuBar1.CurIndex = 2;
WX.PDT.Product.MODEL product = WX.Request.rProduct;
this.rIsEnable.SelectedValue = product.IsEnable.ToString();
this.txtProductID.Text = product.ProductID.ToString();
this.txtProductName.Text = product.ProductName.ToString();
this.ddlProductCategory.SelectedValue = product.CategoryID.ToString();
this.txtSpecification.Text = product.Specification.ToString();
this.ddlUnits.SelectedValue = product.Units.ToString();
this.txtSalesPrice.Text = product.SalesPrice.ToString();
this.txtDiscountedPrice.Text = product.DiscountedPrice.ToString();
this.txtCostPrice.Text = product.CostPrice.ToString();
this.txtRemark.Text = product.Remark.ToString();
this.txtServices.Text = product.Services.ToString();
if (WX.Main.GetConfigItem("Product_ISDept") == "1" && WX.Main.GetConfigItem("Product_OneDept") == "1")
{
WX.PDT.ProductDept.MODEL productdept = WX.PDT.ProductDept.GetModel("select top 1 * from PDT_ProductDept where ProductID=" + WX.Request.rProductId + " order by ID desc");
if (productdept != null)
{
ProductDeptID.SelectedValue = productdept.DeptID.ToString();
MonthFee.Text = productdept.MonthFee.ToString();
Fee.Text = productdept.Fee.ToString();
Feetype1.SelectedValue = productdept.MonthFeeType.ToString();
Feetype2.SelectedValue = productdept.FeeType.ToString();
txtDeptRemarks.Text = productdept.Remarks.ToString();
}
}
}
if (WX.Main.GetConfigItem("Product_ISDept") == "1" && WX.Main.GetConfigItem("Product_OneDept") == "1")
{
pdept.Visible = true;
}
}
private void InitComponent()
{
DataTable categoryData = XSql.GetDataTable("exec [dbo].[sp_get_tree_table] 'PDT_ProductCategory','ID','Name','ParentID','ID',0,1,5");
this.ddlProductCategory.DataSource = categoryData;
this.ddlProductCategory.DataTextField = "name";
this.ddlProductCategory.DataValueField = "id";
this.ddlProductCategory.DataBind();
DataTable unitData = XSql.GetDataTable("SELECT * FROM Ass_Unit");
this.ddlUnits.DataSource = unitData;
this.ddlUnits.DataValueField = "ID";
this.ddlUnits.DataTextField = "UnitName";
this.ddlUnits.DataBind();
if (Request["ProductID"] != null && Request["ProductID"] != "")
{
WX.PDT.Product.MODEL product = WX.Request.rProduct;
this.rIsEnable.SelectedValue = product.IsEnable.ToString();
this.txtProductID.Text = product.ProductID.ToString();
this.txtProductName.Text = product.ProductName.ToString();
this.ddlProductCategory.SelectedValue = product.CategoryID.ToString();
this.txtSpecification.Text = product.Specification.ToString();
this.ddlUnits.SelectedValue = product.Units.ToString();
this.txtSalesPrice.Text = product.SalesPrice.ToString();
this.txtDiscountedPrice.Text = product.DiscountedPrice.ToString();
this.txtCostPrice.Text = product.CostPrice.ToString();
this.txtRemark.Text = product.Remark.ToString();
this.txtServices.Text = product.Services.ToString();
}
if (WX.Main.GetConfigItem("Product_ISDept") == "1")
{
pdept.Visible = true;
string sSql = "select pp.*,td.Name DeptName from PDT_ProductDept pp left join TE_Departments td on pp.DeptID=td.ID where pp.ProductID=" + WX.Request.rProductId;
DataList1.DataSource = ULCode.QDA.XSql.GetDataTable(sSql);
DataList1.DataBind();
}
}
public void SetProduct(int pid, int type)
{
int count = type == 1 ? CustomerRepeater.Items.Count : Repeater2.Items.Count;
Repeater rep = type == 1 ? CustomerRepeater : Repeater2;
if (type == 2)
{
WX.Main.ExecuteDelete("CRM_CustomerDept", "AgreementID", pid.ToString());
}
for (int i = 0; i < count; i++)
{
CheckBox checkboxitem = (CheckBox)rep.Items[i].FindControl("CheckBox" + type);
if (checkboxitem.Checked)
{
WX.CRM.CustomerProducts.MODEL product = WX.CRM.CustomerProducts.NewDataModel();
product.CustomerID.value = WX.Request.rCustomerID;
product.PID.value = pid;
product.Type.value = type;
product.ProductID.value = checkboxitem.ToolTip;
product.Remarks.value = ((TextBox)rep.Items[i].FindControl("Remarks" + type)).Text;
product.ZDFee.value = ((TextBox)rep.Items[i].FindControl("zdfee" + type)).Text;
WX.PDT.Product.MODEL productmodel = WX.PDT.Product.NewDataModel(product.ProductID.value);
product.ProductName.value = productmodel.ProductName.value;
product.Specification.value = productmodel.Specification.value;
product.Units.value = productmodel.Units.value;
product.SalesPrice.value = productmodel.SalesPrice.value;
product.DiscountedPrice.value = productmodel.DiscountedPrice.value;
product.CostPrice.value = productmodel.CostPrice.value;
product.Remark.value = productmodel.Remark.value;
product.Services.value = productmodel.Services.value;
product.Insert();
if (type == 2)
{
ULCode.QDA.XSql.Execute("insert into CRM_CustomerDept select *," + pid + " from PDT_ProductDept where ProductID = " + product.ProductID.ToString());
}
}
}
}
