private void InitComponent() { string productId = NumberRule.NewDataModel(17).GetValue(17); this.txtContractID.Text = productId; DataTable contractCategoryData = XSql.GetDataTable("SELECT * FROM CTR_Category"); this.ddlCategory.DataSource = contractCategoryData; this.ddlCategory.DataValueField = "ID"; this.ddlCategory.DataTextField = "Name"; this.ddlCategory.DataBind(); this.ddlCategory.Items.Insert(0, new ListItem("--请选择--", "")); DataTable projectData = XSql.GetDataTable("SELECT * FROM Pro_Projects"); this.ddlProject.DataSource = projectData; this.ddlProject.DataValueField = "ID"; this.ddlProject.DataTextField = "ProjectName"; this.ddlProject.DataBind(); Dict.BindListCtrl_DeptList(this.ddlDepartment, null, null, null); this.ddlDepartment.Items.Insert(0, new ListItem("--请选择--", "")); this.txtSignedDate.Text = DateTime.Now.ToString("yyyy-M-dd"); this.txtStartDate.Text = DateTime.Now.ToString("yyyy-M-dd"); this.txtEndDate.Text = DateTime.Now.ToString("yyyy-M-dd"); this.txtInputDate.Text = DateTime.Now.ToString("yyyy-M-dd"); this.txtManager.Text = WX.WXUser.GetRealNameByUserID(WX.Authentication.GetUserID()); }
private void InitComponent() { string productId = NumberRule.NewDataModel(15).GetValue(15); this.txtProductID.Text = productId; DataTable unitData = XSql.GetDataTable("SELECT ID,UnitName FROM Ass_Unit"); this.ddlUnit.DataSource = unitData; this.ddlUnit.DataTextField = "UnitName"; this.ddlUnit.DataValueField = "ID"; this.ddlUnit.DataBind(); DataTable suppliersData = XSql.GetDataTable("SELECT SupplierID,CompanyName FROM Ass_Suppliers"); this.ddlSuppliers.DataSource = suppliersData; this.ddlSuppliers.DataTextField = "CompanyName"; this.ddlSuppliers.DataValueField = "SupplierID"; this.ddlSuppliers.DataBind(); DataTable categoryData = XSql.GetDataTable("exec [dbo].[sp_get_tree_table] 'Ass_Category','ID','Name','ParentID','ID',0,1,5"); this.ddlCategory.DataSource = categoryData; this.ddlCategory.DataTextField = "name"; this.ddlCategory.DataValueField = "id"; this.ddlCategory.DataBind(); }
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; } }