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();
}
}
}
