private void cmbCustomerName_SelectionChangeCommitted(object sender, EventArgs e)
{
if (cmbCustomerName.SelectedIndex > -1)
{
var table = new T_CustomersTableAdapter().GetDataById((long)cmbCustomerName.SelectedValue);
}
}
private void cmbUsername_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable mTable = null;
if (cmbUsername.SelectedIndex > 0)
{
long saleId = ((销售管理.Classes.PubClass.MyCmbList)cmbUsername.SelectedItem).Id;
mTable = new T_CustomersTableAdapter().GetDataByUserId(saleId);
}
else
{
mTable = new T_CustomersTableAdapter().GetData();
}
txtCustomer.DataSource = mTable;
txtCustomer.SelectedIndex = -1;
}
private void cmbUserName_SelectionChangeCommitted(object sender, EventArgs e)
{
//cmbCustomerName.DataSource = null;
//if (cmbUserName.SelectedIndex > -1)
//{
// cmbCustomerName.DisplayMember = "CompanyName";
// cmbCustomerName.ValueMember = "id";
// cmbCustomerName.DataSource = new T_CustomersTableAdapter().GetDataByUserId((long)cmbUserName.SelectedValue);
// cmbCustomerName.SelectedIndex = -1;
//}
cmbCustomerName.Text = "";
Classes.PubClass.CompanyName = "";
if (cmbUserName.SelectedIndex > -1)
{
Classes.PubClass.UserId = (long)cmbUserName.SelectedValue;
CustomerNameList mForm = new CustomerNameList();
mForm.ShowDialog();
}
if (Classes.PubClass.CompanyName != "")
{
cmbCustomerName.Text = Classes.PubClass.CompanyName;
var table = new T_CustomersTableAdapter().GetDataById((long)Classes.PubClass.CompanyId);
if (table.Rows.Count > 0)
{
if (((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).IsCityIDNull() == true)
{
MessageBox.Show("请先设置该客户所在地区");
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
CityId = ((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).IsCityIDNull() == true ? -1 : ((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).CityID;
}
else
{
CityId = -1;
}
}
}
private void cmbUsername_SelectedIndexChanged(object sender, EventArgs e)
{
cmbCompanyName.DisplayMember = "CompanyName";
cmbCompanyName.ValueMember = "Id";
DataTable mTable;
if (cmbUsername.Text != "查询所有" && cmbUsername.Text != "")
{
mTable = new T_CustomersTableAdapter().GetDataByUserId(Convert.ToInt64((cmbUsername.SelectedItem as Classes.PubClass.MyCmbList).Id));
}
else
{
mTable = new T_CustomersTableAdapter().GetData();
}
销售管理.DAL.DataSetCustomers.T_CustomersRow mDataRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.NewRow();
mDataRow.id = 0;
mDataRow.CompanyName = "全部";
mTable.Rows.InsertAt(mDataRow, 0);
cmbCompanyName.DataSource = mTable;
cmbCompanyName.SelectedIndex = -1;
}
private void cmbCustomerName_SelectionChangeCommitted(object sender, EventArgs e)
{
if (cmbCustomerName.SelectedIndex > -1)
{
var table = new T_CustomersTableAdapter().GetDataById((long)cmbCustomerName.SelectedValue);
if (table.Rows.Count > 0)
{
if (((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).IsCityIDNull() == true)
{
MessageBox.Show("请先设置该客户所在地区");
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
CityId = ((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).IsCityIDNull() == true ? -1 : ((销售管理.DAL.DataSetCustomers.T_CustomersRow)table.Rows[0]).CityID;
}
else
{
CityId = -1;
}
}
}
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;
}
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 btnSave_Click(object sender, EventArgs e)
{
if (cmbPromary.SelectedIndex < 0)
{
toolTip1.Show("请选择公司所在区域！", cmbPromary, 0, cmbPromary.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtComName.Text.Trim()) == true)
{
toolTip1.Show("请输入公司名称！", txtComName, 0, txtComName.Height, 2000);
return;
}
if (cmbCity.SelectedIndex == -1)
{
toolTip1.Show("请选择公司所在区域", cmbCity, 0, cmbCity.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtComAddr.Text.Trim()) == true)
{
toolTip1.Show("请输入公司地址！", txtComAddr, 0, txtComAddr.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtBusinessName.Text.Trim()) == true)
{
toolTip1.Show("请输入商务负责人！", txtBusinessName, 0, txtBusinessName.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtBusinessTel.Text.Trim()) == true)
{
toolTip1.Show("请输入商务负责人座机！", txtBusinessTel, 0, txtBusinessTel.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtBusinessPhone.Text.Trim()) == true)
{
toolTip1.Show("请输入商务负责人手机！", txtBusinessPhone, 0, txtBusinessPhone.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtBusinessEmail.Text.Trim()) == true)
{
toolTip1.Show("请输入商务负责人邮箱！", txtBusinessEmail, 0, txtBusinessEmail.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtDeliverName.Text.Trim()) == true)
{
toolTip1.Show("请输入收件人！", txtDeliverName, 0, txtDeliverName.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtDeliverPhone.Text.Trim()) == true)
{
toolTip1.Show("请输入收件人手机！", txtDeliverPhone, 0, txtDeliverPhone.Height, 2000);
return;
}
if (string.IsNullOrEmpty(txtDeliverAddr.Text.Trim()) == true)
{
toolTip1.Show("请输入收件人地址！", txtDeliverAddr, 0, txtDeliverAddr.Height, 2000);
return;
}
if (mId > -1)
{
T_CustomersTableAdapter adapter = new T_CustomersTableAdapter();
var mTable = adapter.GetDataByComName(txtComName.Text.Trim());
if (mTable.Rows.Count > 0)
{
var mRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.Rows[0];
if (mId != mRow.id)
{
toolTip1.Show("该公司名称已存在！", txtComName, 0, txtComName.Height, 2000);
return;
}
}
int ret = adapter.UpdateById(txtComName.Text.Trim(), txtComAddr.Text.Trim(), txtBusinessName.Text.Trim(), txtBusinessTel.Text.Trim(), txtBusinessPhone.Text.Trim(), txtBusinessEmail.Text.Trim(), txtTechName.Text.Trim(), txtTechTel.Text.Trim(), txtTechPhone.Text.Trim(), txtTechEmail.Text.Trim(), txtDeliverName.Text.Trim(), txtDeliverAddr.Text.Trim(), txtDeliverPhone.Text.Trim(), (long)cmbCity.SelectedValue, mId);
if (ret > 0)
{
MessageBox.Show("修改成功");
btnSave.Enabled = false;
return;
}
else
{
MessageBox.Show("修改失败");
return;
}
}
else
{
T_CustomersTableAdapter adapter = new T_CustomersTableAdapter();
var mTable = adapter.GetDataByComName(txtComName.Text.Trim());
if (mTable.Rows.Count > 0)
{
toolTip1.Show("该公司名称已存在！", txtComName, 0, txtComName.Height, 2000);
return;
}
else
{
int ret = adapter.Insert(txtComName.Text.Trim(), txtComAddr.Text.Trim(), txtBusinessName.Text.Trim(), txtBusinessTel.Text.Trim(), txtBusinessPhone.Text.Trim(), txtBusinessEmail.Text.Trim(), txtTechName.Text.Trim(), txtTechTel.Text.Trim(), txtTechPhone.Text.Trim(), txtTechEmail.Text.Trim(), txtDeliverName.Text.Trim(), txtDeliverAddr.Text.Trim(), txtDeliverPhone.Text.Trim(), (long)cmbCity.SelectedValue, Classes.PubClass.UserId, "正常");
if (ret > 0)
{
MessageBox.Show("添加成功");
btnSave.Enabled = false;
return;
}
else
{
MessageBox.Show("添加失败");
return;
}
}
}
}
private void 客户资料维护_Load(object sender, EventArgs e)
{
//添加省市cmb
var mTable1 = new T_PromaryTableAdapter().GetData();
cmbPromary.DisplayMember = "proName";
cmbPromary.ValueMember = "proID";
cmbPromary.DataSource = mTable1;
cmbPromary.SelectedIndex = -1;
if (mId == -1)
{
btnSave.Text = "增加";
}
else
{
var mTable = new T_CustomersTableAdapter().GetDataById(mId);
if (mTable.Rows.Count > 0)
{
var mRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.Rows[0];
txtComName.Text = mRow.CompanyName;
txtComAddr.Text = mRow.CompanyAddress;
txtBusinessName.Text = mRow.BusinessContactName;
if (mRow.IsDeliverAddressNull() == false)
{
txtDeliverAddr.Text = mRow.DeliverAddress;
}
if (mRow.IsDeliverNameNull() == false)
{
txtDeliverName.Text = mRow.DeliverName;
}
if (mRow.IsDeliverPhoneNull() == false)
{
txtDeliverPhone.Text = mRow.DeliverPhone;
}
if (mRow.IsCityIDNull() == false)
{
var mTable2 = new T_CityTableAdapter().GetDataByID(mRow.CityID);
if (mTable2.Rows.Count > 0)
{
cmbPromary.SelectedValue = mTable2[0].proID;
cmbCity.SelectedValue = mRow.CityID;
}
}
txtBusinessTel.Text = mRow.BusinessContactTel;
txtBusinessPhone.Text = mRow.BusinessContactPhone;
txtBusinessEmail.Text = mRow.BusinessContactEmail;
txtTechName.Text = mRow.TechContactName;
txtTechTel.Text = mRow.TechContactTel;
txtTechPhone.Text = mRow.TechContactPhone;
txtTechEmail.Text = mRow.TechContactEmail;
}
else
{
MessageBox.Show("获取客户资料错误");
this.Close();
return;
}
btnSave.Text = "保存";
}
}
