public void SetProduct(销售管理.DAL.DataSetProducts.T_ProductsRow mRow) { if (mRow.Level == 1) { cmbProduct1.SelectedValue = mRow.Id; } else { var mParentTable = new T_ProductsTableAdapter().GetDataByID(mRow.ParentId); if (mParentTable.Rows.Count > 0) { SetProduct(mParentTable[0]); } if (mRow.Level == 2) { cmbProduct2.SelectedValue = mRow.Id; } if (mRow.Level == 3) { cmbProduct3.SelectedValue = mRow.Id; } } }
private void 出库单详细_Load(object sender, EventArgs e) { //获取销售名单 cmbUserName.DisplayMember = "username"; cmbUserName.ValueMember = "id"; cmbUserName.DataSource = new T_UsersTableAdapter().GetSalers(); //获取一级产品名单 var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品 cmbProduct1.DataSource = mTable; cmbProduct1.SelectedIndex = -1; //foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows) //{ // MyCmbList mCmblist = new MyCmbList(); // mCmblist.Id = mRow.Id; // mCmblist.Name = mRow.Name; // cmbProduct1.Items.Add(mCmblist); //} if (mId == -1) { } else { DataTable dt = new DataTable(); dt = new T_StockOutTableAdapter().GetDataById(mId); if (dt.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetStockOut.T_StockOutRow)dt.Rows[0]; cmbUserName.SelectedValue = mRow.UserName; //cmbCustomerName.DisplayMember = "customername"; //cmbCustomerName.DataSource = new T_CustomersTableAdapter().GetDataByUserId(mRow.UserName); if (mRow.IsCustomerNameNull() == false) { cmbCustomerName.SelectedIndex = cmbCustomerName.FindStringExact(mRow.CustomerName.ToString()); } //获取产品信息 //long pLevel, pId; var mTableProduct = new T_ProductsTableAdapter().GetDataByID(mRow.ProductName); if (mTableProduct.Rows.Count > 0) { 销售管理.DAL.DataSetProducts.T_ProductsRow mProductRow = mTableProduct[0]; // for (int i = mProductRow.Level; i > 1; i--) // { // var mParentTable = new T_ProductsTableAdapter().GetDataByID(mProductRow.ParentId); // } //设置产品 SetProduct(mProductRow); } //cmbMonth.SelectedItem = mRow.SaleMonth; dtpDate1.Value = mRow.SaleDate; //txtProductName.Text = mRow.ProductName; txtAmount.Text = mRow.Amount.ToString(); txtPrice.Text = mRow.Price.ToString(); txtSum.Text = mRow.SumMoney.ToString(); if (mRow.IsSettlementModesNull() == false) { cmbSettlementModes.SelectedText = mRow.SettlementModes; } } } }
private void 销售明细维护_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“dataSetUsers.T_Users”中。您可以根据需要移动或删除它。 //获取销售名单 cmbUserName.DisplayMember = "UserName"; cmbUserName.ValueMember = "id"; cmbUserName.DataSource = new T_UsersTableAdapter().GetSalers(); cmbUserName.SelectedIndex = -1; //获取一级产品名单 var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品 cmbProduct1.DataSource = mTable; cmbProduct1.SelectedIndex = -1; //foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows) //{ // MyCmbList mCmblist = new MyCmbList(); // mCmblist.Id = mRow.Id; // mCmblist.Name = mRow.Name; // cmbProduct1.Items.Add(mCmblist); //} if (mId == -1) { //获取出库单编号 //string m_date = DateTime.Now.ToString("yyyyMM"); //txtStockOutNo.Text = new T_SaleDetailsTableAdapter().GetNextStockOutNo(m_date).ToString(); } else { DataTable dt = new DataTable(); dt = new T_SaleDetailsTableAdapter().GetDataById(mId); if (dt.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetSaleDetails.T_SaleDetailsRow)dt.Rows[0]; cmbUserName.SelectedValue = mRow.UserName; //cmbCustomerName.DisplayMember = "customername"; //cmbCustomerName.DataSource = new T_CustomersTableAdapter().GetDataByUserId(mRow.UserName); cmbUserName_SelectionChangeCommitted(sender, e); if (mRow.IsCustomerNameNull() == false) { long mCustomerId; if (Int64.TryParse(mRow.CustomerName, out mCustomerId) == true) { cmbCustomerName.SelectedValue = Convert.ToInt64(mRow.CustomerName); } else { cmbCustomerName.SelectedIndex = cmbCustomerName.FindStringExact(mRow.CustomerName); } } cmbCustomerName_SelectionChangeCommitted(sender, e); //设置客户所在城市ID //获取产品信息 //long pLevel, pId; var mTableProduct = new T_ProductsTableAdapter().GetDataByID(mRow.ProductName); if (mTableProduct.Rows.Count > 0) { 销售管理.DAL.DataSetProducts.T_ProductsRow mProductRow = mTableProduct[0]; // for (int i = mProductRow.Level; i > 1; i--) // { // var mParentTable = new T_ProductsTableAdapter().GetDataByID(mProductRow.ParentId); // } //设置产品 SetProduct(mProductRow); } //cmbMonth.SelectedItem = mRow.SaleMonth; dtpDate1.Value = mRow.SaleDate; //txtProductName.Text = mRow.ProductName; txtAmount.Text = mRow.Amount.ToString(); txtPrice.Text = mRow.Price.ToString(); txtSum.Text = mRow.SumMoney.ToString(); txtStockOutNo.Text = mRow.StockOutNo.ToString(); cmbUnit.Text = mRow.Unit.ToString(); if (mRow.IsSettlementModesNull() == false) { cmbSettlementModes.SelectedText = mRow.SettlementModes; } //if (mRow.IsMakeInvoiceNull() == false) //{ // if (mRow.MakeInvoice.ToString() == "是") // { // cbInvoice.Checked = true; // } // else // { // cbInvoice.Checked = false; // } //} //if (mRow.IsInvoiceContentNull() == false) txtInvoiceContent.Text = mRow.InvoiceContent; ////cmbInvoiceMonth.SelectedItem = mRow.InvoiceMonth; //if (mRow.IsInvoiceDateNull() == false) dtpInvioceDate.Value = mRow.InvoiceDate; //if (mRow.IsInvoiceTypeNull() == false) cmbInvoiceType.SelectedItem = mRow.InvoiceType; //if (mRow.IsInvoiceNoNull() == false) txtInvoiceNo.Text = mRow.InvoiceNo; } } }
private void 销售明细维护_Load(object sender, EventArgs e) { cmbUserName.DisplayMember = "UserName"; cmbUserName.ValueMember = "id"; cmbUserName.DataSource = new T_UsersTableAdapter().GetSalers(); cmbUserName.SelectedIndex = -1; //获取一级产品名单 var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品 cmbProduct1.DataSource = mTable; cmbProduct1.SelectedIndex = -1; if (mId == -1) { //获取出库单编号 //string m_date = DateTime.Now.ToString("yyyyMM"); //txtStockOutNo.Text = new T_SaleDetailsTableAdapter().GetNextStockOutNo(m_date).ToString(); } else { DataTable dt = new DataTable(); dt = new T_ProductSendTableAdapter().GetDataById(mId); if (dt.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetProductSend.T_ProductSendRow)dt.Rows[0]; cmbUserName.SelectedValue = mRow.UserName; cmbUserName_SelectionChangeCommitted(sender, e); if (mRow.IsCustomerNameNull() == false) { long mCustomerId; if (Int64.TryParse(mRow.CustomerName, out mCustomerId) == true) { cmbCustomerName.SelectedValue = Convert.ToInt64(mRow.CustomerName); } else { cmbCustomerName.SelectedIndex = cmbCustomerName.FindStringExact(mRow.CustomerName); } } //获取产品信息 //long pLevel, pId; var mTableProduct = new T_ProductsTableAdapter().GetDataByID(mRow.ProductName); if (mTableProduct.Rows.Count > 0) { 销售管理.DAL.DataSetProducts.T_ProductsRow mProductRow = mTableProduct[0]; //设置产品 SetProduct(mProductRow); } dtpDate1.Value = mRow.SaleDate; txtAmount.Text = mRow.Amount.ToString(); txtPrice.Text = mRow.Price.ToString(); txtSum.Text = mRow.SumMoney.ToString(); txtStockOutNo.Text = mRow.StockOutNo.ToString(); cmbUnit.Text = mRow.Unit.ToString(); } } }