private void 数据比较查询_Load(object sender, EventArgs e)
{
cmbProducts1.Items.Add("查询所有");
var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品
foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
{
cmbProducts1.Items.Add(new Classes.PubClass.MyCmbList(mRow.Id, mRow.Name));
}
cmbProducts1.SelectedIndex = 0;
var mTable1 = new T_UsersTableAdapter().GetSalers(); //获取销售
foreach (销售管理.DAL.DataSetUsers.T_UsersRow mRow in mTable1.Rows)
{
cmbUsername.Items.Add(new Classes.PubClass.MyCmbList(mRow.id, mRow.UserName));
}
cmbUsername.Items.Insert(0, "查询所有");
cmbUsername.SelectedIndex = 0;
cmbUsername.DisplayMember = "Name";
cmbUsername.ValueMember = "Id";
rbSaler.Checked = true;
cmbCompareType.SelectedIndex = 0;
dtpStart.Value = dtpStart.Value.AddMonths(-1);
if (!Common.AuthenticateRight.AuthOperation(140301) && !CommonClass.SttUser.blSuperUser)
{
cmbUsername.SelectedIndex = cmbUsername.FindStringExact(Classes.PubClass.UserName.ToString());
cmbUsername.Enabled = false;
}
}
private void cmbProduct2_SelectedIndexChanged(object sender, EventArgs e)
{
//cmbProduct3.Items.Clear();
//var mTable = new T_ProductsTableAdapter().GetDataByParentId(((MyCmbList)cmbProduct2.SelectedItem).Id); //获取level3的产品
cmbProduct3.DataSource = null;
if (cmbProduct2.SelectedIndex == -1)
{
return;
}
var mTable = new T_ProductsTableAdapter().GetDataByParentId((long)cmbProduct2.SelectedValue); //获取level3的产品
if (mTable.Rows.Count > 0)
{
cmbProduct3.Visible = true;
//ProductId = -1;
//foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
//{
// MyCmbList mCmblist = new MyCmbList();
// mCmblist.Id = mRow.Id;
// mCmblist.Name = mRow.Name;
// cmbProduct3.Items.Add(mCmblist);
//}
cmbProduct3.DisplayMember = "Name";
cmbProduct3.ValueMember = "Id";
cmbProduct3.DataSource = mTable;
cmbProduct3.SelectedIndex = -1;
ProductId = (long)cmbProduct2.SelectedValue;
}
else
{
cmbProduct3.Visible = false;
//ProductId = ((MyCmbList)cmbProduct2.SelectedItem).Id;
ProductId = (long)cmbProduct2.SelectedValue;
}
}
private void cmbProducts2_SelectedIndexChanged(object sender, EventArgs e)
{
mProductId = ((Classes.PubClass.MyCmbList)cmbProducts2.SelectedItem).Id;
cmbProducts3.Items.Clear();
var mTable = new T_ProductsTableAdapter().GetDataByParentId(mProductId); //获取level1的产品
foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
{
cmbProducts3.Items.Add(new Classes.PubClass.MyCmbList(mRow.Id, mRow.Name));
}
}
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;
}
private void 销售记录查询_Load(object sender, EventArgs e)
{
cmbProducts1.Items.Add("查询所有");
var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品
foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
{
cmbProducts1.Items.Add(new Classes.PubClass.MyCmbList(mRow.Id, mRow.Name));
}
cmbProducts1.SelectedIndex = 0;
//获取销售列表
var mTable1 = new T_UsersTableAdapter().GetSalers();
foreach (销售管理.DAL.DataSetUsers.T_UsersRow mRow in mTable1.Rows)
{
cmbUsername.Items.Add(new Classes.PubClass.MyCmbList(mRow.id, mRow.UserName));
}
cmbUsername.Items.Insert(0, "查询所有");
cmbUsername.SelectedIndex = 0;
//获取省 不用数据绑定是因为要添加 查询所有
cmbPromary.Items.Add("查询所有");
var mTable2 = new T_PromaryTableAdapter().GetData();
foreach (销售管理.DAL.DataSetPromary.T_PromaryRow mRow in mTable2.Rows)
{
cmbPromary.Items.Add(new Classes.PubClass.MyCmbList(mRow.proID, mRow.proName));
}
cmbPromary.SelectedIndex = 0;
rbDetails.Checked = true;
//是否开票选项
lbInvoiceFlag.Visible = true;
CmbInvoiceFlag.Visible = true;
//MakeLineChart();
if (!Common.AuthenticateRight.AuthOperation(140101) && !CommonClass.SttUser.blSuperUser)
{
cmbUsername.SelectedIndex = cmbUsername.FindStringExact(Classes.PubClass.UserName);
cmbUsername.Enabled = false;
rbSalerSum.Visible = false;
}
//是否开票
CmbInvoiceFlag.SelectedIndex = 0;
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
//MessageBox.Show("删除本级"+ treeView1.SelectedNode.Name);
if (DialogResult.Yes == MessageBox.Show("确认是否删除", "警告", MessageBoxButtons.YesNo))
{
int ret = new T_ProductsTableAdapter().DeleteById(Convert.ToInt64(treeView1.SelectedNode.Name));
if (ret > 0)
{
MessageBox.Show("删除成功");
AddTree();
}
else
{
MessageBox.Show("删除失败");
}
}
}
private void cmbProducts1_SelectedIndexChanged(object sender, EventArgs e)
{
rbProduct.Checked = true;
if (cmbProducts1.SelectedItem.ToString() == "查询所有")
{
mProductId = -1;
}
else
{
mProductId = ((Classes.PubClass.MyCmbList)cmbProducts1.SelectedItem).Id;
cmbProducts2.Items.Clear();
cmbProducts3.Items.Clear();
var mTable = new T_ProductsTableAdapter().GetDataByParentId(mProductId); //获取level1的产品
foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
{
cmbProducts2.Items.Add(new Classes.PubClass.MyCmbList(mRow.Id, mRow.Name));
}
}
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
//MessageBox.Show("添加下级");
using (添加下级产品 mForm = new 添加下级产品())
{
if (DialogResult.Yes == mForm.ShowDialog())
{
int ret = new T_ProductsTableAdapter().Insert(mForm.txtProductName.Text.Trim(), treeView1.SelectedNode.Level + 1, Convert.ToInt64(treeView1.SelectedNode.Name));
if (ret > 0)
{
MessageBox.Show("加入成功");
AddTree();
}
else
{
MessageBox.Show("加入失败");
}
}
}
}
private void 修改名称ToolStripMenuItem_Click(object sender, EventArgs e)
{
using (添加下级产品 mForm = new 添加下级产品())
{
mForm.Text = "修改产品名称";
mForm.txtProductName.Text = treeView1.SelectedNode.Text;
if (DialogResult.Yes == mForm.ShowDialog())
{
int ret = new T_ProductsTableAdapter().UpdateNameById(mForm.txtProductName.Text.Trim(), Convert.ToInt64(treeView1.SelectedNode.Name));
if (ret > 0)
{
MessageBox.Show("修改成功");
AddTree();
}
else
{
MessageBox.Show("修改失败");
}
}
}
}
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 AddTree()
{
treeView1.Nodes[0].Nodes.Clear();
var mTable = new T_ProductsTableAdapter().GetData();
if (mTable.Rows.Count > 0)
{
foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows)
{
if (mRow.Level == 1)
{
treeView1.Nodes[0].Nodes.Add(mRow.Id.ToString(), mRow.Name).ForeColor = Color.Red;
}
else
{
TreeNode[] mNode = treeView1.Nodes.Find(mRow.ParentId.ToString(), true);
if (mNode.Length > 0)
{
if (mRow.Level == 2)
{
mNode[0].Nodes.Add(mRow.Id.ToString(), mRow.Name).ForeColor = Color.Blue;
}
else
{
mNode[0].Nodes.Add(mRow.Id.ToString(), mRow.Name);
}
}
}
}
}
//treeView1.ExpandAll();
treeView1.Nodes[0].Expand();
foreach (TreeNode mNode in treeView1.Nodes[0].Nodes)
{
mNode.Expand();
}
}
public DateTime DeliverDate; //发货日期
private void 申请费用分配_Load(object sender, EventArgs e)
{
rbPersonal.Checked = true;
isLoading = true;
if (ExId > -1) //如果费用分配ID大于-1,查看费用分配信息
{
DataTable mTable1 = new T_ExpenseAllocationTableAdapter().GetDataById(ExId);
if (mTable1.Rows.Count > 0)
{
var mDataRow = (销售管理.DAL.DataSetExpenseAllocation.T_ExpenseAllocationRow)mTable1.Rows[0];
//cmbMonth.SelectedItem = mDataRow.Month;
//txtTableNo.Text = mDataRow.TableNo;
//txtCustomerName.Text = mDataRow.CustomerName;
txtProjectName.Text = mDataRow.ProjectName;
var mProductTable = new T_ProductsTableAdapter().GetDataByID(mDataRow.ProductName);
if (mProductTable.Rows.Count > 0)
{
txtProductName.Text = mProductTable[0].Name;
}
var mCustomerTable = new T_CustomersTableAdapter().GetDataById(Convert.ToInt64(mDataRow.CustomerName));
if (mProductTable.Rows.Count > 0)
{
txtCustomerName.Text = mCustomerTable[0].CompanyName;
}
var mSaleDetailsTable = new T_SaleDetailsTableAdapter().GetDataByExId(ExId);
if (mSaleDetailsTable.Rows.Count > 0)
{
DeliverDate = mSaleDetailsTable[0].SaleDate;
}
txtProductName.Tag = mDataRow.ProductName;
txtCustomerName.Tag = mDataRow.CustomerName;
txtType.Text = mDataRow.ProductType;
txtAmount.Text = mDataRow.Amount.ToString();
txtDeliverPrice.Text = mDataRow.DeliverPrice.ToString();
txtDeliverSum.Text = mDataRow.DeliverSum.ToString();
txtSalePrice.Text = mDataRow.SalePrice.ToString();
txtSaleSum.Text = mDataRow.SaleSum.ToString();
txtSaleWages.Text = mDataRow.SaleWages.ToString();
txtCommissionPrice.Text = mDataRow.CommissionPrice.ToString();
txtCommissionSum.Text = mDataRow.CommissionSum.ToString();
txtSaleCommission.Text = mDataRow.SaleComission.ToString();
txtAgentPrice.Text = mDataRow.AgentPrice.ToString();
txtAgentSum.Text = mDataRow.AgentSum.ToString();
txtAgentCommission.Text = mDataRow.AgentCommission.ToString();
SalerId = mDataRow.UserName;
DataTable mTable = new T_UsersTableAdapter().GetDataById(SalerId);
if (mTable.Rows.Count > 0)
{
var mDataRow1 = (销售管理.DAL.DataSetUsers.T_UsersRow)mTable.Rows[0];
txtUserName.Text = mDataRow1.UserName;
}
if (mDataRow.type == "个人订单")
{
rbPersonal.Checked = true;
}
else if (mDataRow.type == "部门订单")
{
rbDepart.Checked = true;
}
else if (mDataRow.type == "公司跟单")
{
rbCompany.Checked = true;
}
else
{
rbCity.Checked = true;
}
if (mDataRow.IsCitySalerNull() == false)
{
if (mDataRow.CitySaler != "0")
{
cmbUserName.SelectedValue = Convert.ToInt64(mDataRow.CitySaler);
}
}
txtCitySum.Text = mDataRow.CitySum;
txtCityWages.Text = mDataRow.CityWages;
if (mDataRow.IsCitySalePriceNull() == false)
{
txtCitySalePrice.Text = mDataRow.CitySalePrice.ToString();
}
if (mDataRow.IsCitySaleSumNull() == false)
{
txtCitySaleSum.Text = mDataRow.CitySaleSum.ToString();
}
if (mDataRow.IsCitySaleCommissionNull() == false)
{
txtCitySaleCommission.Text = mDataRow.CitySaleCommission.ToString();
}
oldType = mDataRow.type;
FailTableNo = mDataRow.TableNo;
txtTableNo.Text = mDataRow.TableNo;
if (mDataRow.IsPaid == "已付款")
{
cbIsPaid.Checked = true;
if (mDataRow.IsPaidDateNull() == false)
{
dtpPaidDate.Value = mDataRow.PaidDate;
}
}
else
{
cbIsPaid.Checked = false;
}
if (mDataRow.IsHasTaxNull() == false)
{
if (mDataRow.HasTax == "含税")
{
cbTax.Checked = true;
}
else
{
cbTax.Checked = false;
}
}
else
{
cbTax.Checked = false;
}
txtStatus.Text = mDataRow.Status;//+"。" + mDataRow.BusinessRemark;
labStatus.Visible = true;
txtStatus.Visible = true;
btnApply.Enabled = false;
//label12.Visible = true;
//dtpPaidDate.Visible = true;
cbIsPaid.Visible = true;
if (mDataRow.Status.Contains("不通过") == true && isModify == true)
{
btnApply.Enabled = true;
btnApply.Text = "重新申请";
cbIsPaid.Visible = false;
}
else
{
btnApply.Enabled = false;
}
//groupBox1.Enabled = false;
}
else
{
MessageBox.Show("该费用分配表号不存在");
this.Close();
return;
}
if (Classes.PubClass.UserRight == "领导" || Classes.PubClass.UserRight == "超级管理员" || Classes.PubClass.UserRight == "商务经理")
{
btnModifyPaid.Visible = true;
}
else
{
btnModifyPaid.Visible = false;
}
}
else //申请费用分配
if (mRow != null)
{
DeliverDate = Convert.ToDateTime(mRow.Cells["saleDateDataGridViewTextBoxColumn"].Value);
txtCustomerName.Text = mRow.Cells["customerNameDataGridViewTextBoxColumn"].Value.ToString();
txtProductName.Text = mRow.Cells["productNameDataGridViewTextBoxColumn"].Value.ToString();
txtAmount.Text = mRow.Cells["amountDataGridViewTextBoxColumn"].Value.ToString();
//cmbMonth.SelectedItem = mRow.Cells["saleMonthDataGridViewTextBoxColumn"].Value.ToString();
txtDeliverPrice.Text = mRow.Cells["priceDataGridViewTextBoxColumn"].Value.ToString();
long SaleDetailsId = Convert.ToInt64(mRow.Cells["idDataGridViewTextBoxColumn"].Value);
var SaleDetailsTable = new T_SaleDetailsTableAdapter().GetDataById(SaleDetailsId);
if (SaleDetailsTable.Rows.Count > 0)
{
txtProductName.Tag = SaleDetailsTable[0].ProductName;
txtCustomerName.Tag = SaleDetailsTable[0].CustomerName;
SalerId = SaleDetailsTable[0].UserName;
var mUserTable = new T_UsersTableAdapter().GetDataById(SalerId);
if (mUserTable.Rows.Count > 0)
{
txtUserName.Text = mUserTable[0].UserName;
}
SetTableNo();
}
btnModifyPaid.Visible = false;
}
isLoading = false;
}
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;
//添加是否开票
CmbInvoiceFlag.SelectedIndex = 0;
//获取一级产品名单
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();
// 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;
// }
//}
}
public string oldType; //原订单类型
private void Form1_Load(object sender, EventArgs e)
{
DataTable mTable1 = new T_ExpenseAllocationTableAdapter().GetDataById(ExId);
var mDataRow = (销售管理.DAL.DataSetExpenseAllocation.T_ExpenseAllocationRow)mTable1.Rows[0];
//cmbMonth.SelectedItem = mDataRow.Month;
//txtTableNo.Text = mDataRow.TableNo;
//txtCustomerName.Text = mDataRow.CustomerName;
txtProjectName.Text = mDataRow.ProjectName;
var mProductTable = new T_ProductsTableAdapter().GetDataByID(mDataRow.ProductName);
if (mProductTable.Rows.Count > 0)
{
txtProductName.Text = mProductTable[0].Name;
}
var mCustomerTable = new T_CustomersTableAdapter().GetDataById(Convert.ToInt64(mDataRow.CustomerName));
if (mProductTable.Rows.Count > 0)
{
txtCustomerName.Text = mCustomerTable[0].CompanyName;
}
txtProductName.Tag = mDataRow.ProductName;
txtCustomerName.Tag = mDataRow.CustomerName;
txtType.Text = mDataRow.ProductType;
txtAmount.Text = mDataRow.Amount.ToString();
txtDeliverPrice.Text = mDataRow.DeliverPrice.ToString();
txtDeliverSum.Text = mDataRow.DeliverSum.ToString();
txtSalePrice.Text = mDataRow.SalePrice.ToString();
txtSaleSum.Text = mDataRow.SaleSum.ToString();
txtSaleWages.Text = mDataRow.SaleWages.ToString();
txtCommissionPrice.Text = mDataRow.CommissionPrice.ToString();
txtCommissionSum.Text = mDataRow.CommissionSum.ToString();
txtSaleCommission.Text = mDataRow.SaleComission.ToString();
txtAgentPrice.Text = mDataRow.AgentPrice.ToString();
txtAgentSum.Text = mDataRow.AgentSum.ToString();
txtAgentCommission.Text = mDataRow.AgentCommission.ToString();
SalerId = mDataRow.UserName;
DataTable mTable = new T_UsersTableAdapter().GetDataById(SalerId);
if (mTable.Rows.Count > 0)
{
var mDataRow1 = (销售管理.DAL.DataSetUsers.T_UsersRow)mTable.Rows[0];
txtUserName.Text = mDataRow1.UserName;
}
if (mDataRow.type == "个人订单")
{
rbPersonal.Checked = true;
}
else if (mDataRow.type == "部门订单")
{
rbDepart.Checked = true;
}
else if (mDataRow.type == "公司跟单")
{
rbCompany.Checked = true;
}
else
{
rbCity.Checked = true;
}
if (mDataRow.IsCitySalerNull() == false)
{
if (mDataRow.CitySaler != "0")
{
cmbUserName.SelectedValue = Convert.ToInt64(mDataRow.CitySaler);
}
}
oldType = mDataRow.type;
FailTableNo = mDataRow.TableNo;
txtTableNo.Text = mDataRow.TableNo;
if (mDataRow.IsPaid == "已付款")
{
cbIsPaid.Checked = true;
}
else
{
cbIsPaid.Checked = false;
}
if (mDataRow.IsPaidDateNull() == false)
{
dtpPaidDate.Value = mDataRow.PaidDate;
}
txtStatus.Text = mDataRow.Status; //+"。" + mDataRow.BusinessRemark;
labStatus.Visible = true;
txtStatus.Visible = true;
btnApply.Enabled = true;
if (mDataRow.Status.Contains("不通过") == true && isModify == true)
{
btnApply.Enabled = true;
btnApply.Text = "重新申请";
}
else
{
btnApply.Enabled = true;
}
//groupBox1.Enabled = false;
}
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)
{
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();
}
}
}
