/// <summary>
/// 保存收款单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_save_Click(object sender, EventArgs e)
{
if (new ValidateClear().inputVlidate(tableLayoutPanel1))
{
using (var db = new ScrapSettleContext())
{
Income income = new Income();
income.CustormerID = Convert.ToInt32(cmb_custName.SelectedValue);
income.MakeDte = dtp_make.Value;
income.Money = Convert.ToDouble(txt_money.Text);
income.VoucherNo = lbl_vouchNoValue.Text;
income.IncomeDate = dtp_income.Value.Date;
try
{
db.Incomes.Add(income);
db.SaveChanges();
tsb_save.Enabled = false;
new ValidateClear().clearDate(tableLayoutPanel1);
}
catch (Exception ex)
{
MessageBox.Show("数据保存错误:" + ex.Message + ex.InnerException, "数据保存提示");
return;
}
}
}
}
/// <summary>
/// 单据批审
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_batchAudit_Click(object sender, EventArgs e)
{
if (JudgeDataGridViewCheckBoxState().Count > 0)
{
try
{
using (var db = new ScrapSettleContext())
{
foreach (var item in JudgeDataGridViewCheckBoxState())
{
WeighingSettlementModel w = db.WeighingSettlement.Where(s => s.vocherNO == item).FirstOrDefault();
w.auditFlag = (int)EnumModle.voucherStatus.审核;
}
db.SaveChanges();
MessageBox.Show("单据审核成功", "审核提示");
tsb_query.PerformClick();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.InnerException, "审核错误提示");
}
}
else
{
MessageBox.Show("请选择需要审核的单据", "批审提醒");
}
}
public List <VehicleBrand> vehicleBrands()
{
using (var db = new ScrapSettleContext())
{
return(db.VehicleBrands.ToList());
}
}
public List <Scrap> scrapList()
{
using (var db = new ScrapSettleContext())
{
return(db.Scraps.ToList <Scrap>());
}
}
/// <summary>
/// 删除选择定行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_delete_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
string selected = this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
if (DialogResult.Yes == MessageBox.Show("是否确定删除", "删除提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
ScrapSettleContext db = new ScrapSettleContext();
List <Coefficient> del = (from d in db.Coefficients
where d.VoucherNO == selected
select d).ToList <Coefficient>();
//移除数据库的数据
db.Coefficients.Remove(del[0]);
db.SaveChanges();
clearDate();
//如果是在新增界面状态使用删除功能，则同时删除内存中的集合数据
//数据库中的条件实体delCustomer不能成为内存中的待删除实体
//即：customerList.Remove(delCustomer[0])返回false,故无法实现
//内存当中的数据集记录删除;
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
List <Coefficient> coefficients = archivesList.Where(c => c.VoucherNO == selected).ToList <Coefficient>();
archivesList.Remove(coefficients[0]);
}
bind_gv_dateSource();
}
}
return;
}
/// <summary>
/// 返回用户列表
/// </summary>
/// <returns></returns>
public List <Person> people()
{
using (var db = new ScrapSettleContext())
{
return(db.Peple.ToList());
}
}
/// <summary>
/// 删除选择定行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_delete_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
Int32 selected = (Int32)this.dataGridView1.SelectedRows[0].Cells[0].Value;
if (DialogResult.Yes == MessageBox.Show("是否确定删除", "删除提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
ScrapSettleContext db = new ScrapSettleContext();
List <Customer> delCustomer = (from del in db.Customers
where del.CusCode == selected
select del).ToList <Customer>();
//移除数据库的数据
db.Customers.Remove(delCustomer[0]);
db.SaveChanges();
clearDate();
//如果是在新增界面状态使用删除功能，则同时删除内存中的集合数据
//数据库中的条件实体delCustomer不能成为内存中的待删除实体
//即：customerList.Remove(delCustomer[0])返回false,故无法实现
//内存当中的数据集记录删除;
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
List <Customer> customer = customerList.Where(c => c.CusCode == System.Convert.ToInt32(selected)).ToList <Customer>();
customerList.Remove(customer[0]);
}
bind_gv_dateSource();
}
}
return;
}
/// <summary>
/// 查询收款单列表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_query_Click(object sender, EventArgs e)
{
using (var db = new ScrapSettleContext())
{
try
{
var query = from q in db.Incomes
join c in db.Customers
on q.CustormerID equals c.CusCode
where q.IncomeDate >= dtp_incomeDateStart.Value.Date
where q.IncomeDate <= dtp_incomeDateEnd.Value.Date
where q.CustormerID.ToString() == cmb_custName.SelectedValue.ToString()
select new { c.CusName, q.IncomeDate, q.VoucherNo, q.Money };
dataGridView1.DataSource = query.ToList();
//处理数据为空示和时的数据转换错误，可先转成泛型再求和
lbl_money.Text = query.ToList().Sum(s => s.Money).ToString();
}
catch (Exception ex)
{
MessageBox.Show("数据查询错误:" + ex.Message + ex.InnerException, "数据查询提示");
return;
}
}
}
public List <WeighingSettlementModel> weighingSettlements()
{
using (var db = new ScrapSettleContext())
{
return(db.WeighingSettlement.ToList());
}
}
public List <Coefficient> coefficients()
{
using (var db = new ScrapSettleContext())
{
return(db.Coefficients.ToList());
}
}
public List <Income> incomes()
{
using (var db = new ScrapSettleContext())
{
return(db.Incomes.ToList());
}
}
private void tsb_delete_Click(object sender, EventArgs e)
{
if (dgv_content.Rows.Count > 0)
{
var selected = dgv_content.SelectedRows[0].Cells[2].Value;
ScrapSettleContext db = new ScrapSettleContext();
List <WeighingSettlementModel> del = (from d in db.WeighingSettlement
where d.vocherNO == selected.ToString()
select d).ToList <WeighingSettlementModel>();
foreach (var item in del)
{
if (item.auditFlag != 2)
{
if (DialogResult.Yes == MessageBox.Show("是否确定删除", "删除提醒",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
//移除数据库的数据
db.WeighingSettlement.Remove(del[0]);
db.SaveChanges();
tsb_query.PerformClick();
}
}
else
{
MessageBox.Show("单据已经审核，不能删除", "删除提示");
}
}
}
return;
}
/// <summary>
/// 单据作废
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbInvalid_Click(object sender, EventArgs e)
{
if (lbl_vouchNoValue.Text != "")
{
try
{
using (var db = new ScrapSettleContext())
{
WeighingSettlementModel w = db.WeighingSettlement.Where(s => s.vocherNO == lbl_vouchNoValue.Text).FirstOrDefault();
if (true)
{
}
w.auditFlag = (int)EnumModle.voucherStatus.作废;
db.SaveChanges();
MessageBox.Show("单据作废成功", "作废提示");
lbl_voucherStateValue.Text = EnumModle.voucherStatus.作废.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.InnerException, "错误提示");
}
}
else
{
MessageBox.Show("当前无可作废单据！");
}
}
/// <summary>
/// 数据保存与修改
/// </summary>
private void saveOrChang()
{
if (inputVlidate())
{
//新增后保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
using (var db = new ScrapSettleContext())
{
Customer customer = new Customer();
customer.CusCode = Convert.ToInt32(txt_cusCode.Text);
customer.CusName = this.txt_cusName.Text;
customer.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
customer.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
}
db.Customers.Add(customer);
try
{
db.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
customerList.Add(customer);
//this.dataGridView1.DataSource = null;
//this.dataGridView1.DataSource = customerList;
//MessageBox.Show("数据保存成功", "保存提示");
this.bind_gv_dateSource();
//清空填制记录
//this.txt_cusCode.Text = null;
//this.txt_cusName.Text = null;
clearDate();
//再次调用新增事件
this.tsb_add.PerformClick();
}
}
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.query.ToString())
{
updateDate();
}
}
;
}
public List <WeighingViewModel> GetWeighingList(Expression <Func <WeighingSettlementModel, bool> > expr)
{
List <WeighingViewModel> list = new List <WeighingViewModel>();
using (var db = new ScrapSettleContext())
{
var query = from d in new EnumService().GetVoucherState()
join q in db.WeighingSettlement.Where(expr.Compile()) on d.Key equals q.auditFlag
join c in db.Customers
on q.CustmerCode equals c.CusCode.ToString()
join p in db.Peple on q.personCode equals p.Code.ToString()
join s in db.Scraps on q.scrapCode equals s.ScrapCode.ToString()
select new
{
q.WeighingDate,
q.vocherNO,
c.CusName,
s.ScrapName,
q.proportion,
q.webUnitPrice,
q.settleUnitPrice,
q.netWeight,
q.settleAmount,
voucherState = d.Value,
note = q.note
};
foreach (var item in query)
{
WeighingViewModel m = new WeighingViewModel();
m.WeighingDate = item.WeighingDate.ToString();
m.vocherNO = item.vocherNO;
m.CusName = item.CusName;
m.ScrapName = item.ScrapName;
m.proportion = item.proportion;
m.webUnitPrice = item.webUnitPrice;
m.settleUnitPrice = item.settleUnitPrice;
m.netWeight = item.netWeight;
m.settleAmount = item.settleAmount;
m.voucherState = item.voucherState;
m.note = item.note;
list.Add(m);
}
return(list);
}
}
/// <summary>
/// 新增档案并自动生成客户编号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Tsb_add_Click(object sender, EventArgs e)
{
lbl_voucherStatus.Text = "档案状态：新增";
lbl_voucherStatus.Visible = true;
//先清空查询时绑定的数据
clearDate();
//故增加数据源判定,否则连续增加时就无法在DataGridView中显示增加的记录
if (saveOrModifQueryFlag != saveOrChangeOrQueryMolde.save.ToString())
{
saveOrModifQueryFlag = saveOrChangeOrQueryMolde.save.ToString();
this.dataGridView1.DataSource = null;
}
this.tsb_save.Enabled = true;
tsb_abandon.Enabled = true;
//新增与查询功能中的dataGridView数据源不同，且该数据源标记通过功能键触发选择
//tsb_query.Enabled = false;
tsb_modify.Enabled = false;
this.tableLayoutPanel1.Enabled = true;
//给自定义日期控件赋值，其中的textBox控件为显示值
//日期控件的文本为将需要存储的值
this.tbd_effect.Controls[2].Text = DateTime.Now.ToString().Substring(0, 10);
tbd_effect.Text = DateTime.Now.ToString().Substring(0, 10);
//取最大编号时速度太慢，三秒左右，同时最大号算法有误，取到第10号则不向上递增了???。
using (var db = new ScrapSettleContext())
{
Customer customer = new Customer();
var custQuery = from cust in db.Customers.AsNoTracking()
select cust.CusCode;
if (custQuery.Count() == 0)
{
maxCusCode = 1;
}
else
{
maxCusCode = Convert.ToInt32(custQuery.Max()) + 1;
}
}
this.txt_cusCode.Text = maxCusCode.ToString();
this.txt_cusCode.Focus();
//表明当前dataGridView的数据源是内存集合数据
}
private void btn_query_Click(object sender, EventArgs e)
{
using (var db = new ScrapSettleContext())
{
var v = from i in db.Incomes
join c in db.Customers on i.CustormerID equals c.CusCode
where i.VoucherNo == rtxt_voucherNO.Text
select new { i.VoucherNo, c.CusName, i.Money };
foreach (var item in v)
{
lbl_vouchNoValue.Text = item.VoucherNo;
cmb_custName.Text = item.CusName;
txt_money.Text = item.Money.ToString();
}
}
}
/// <summary>
/// 单据查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_query_Click(object sender, EventArgs e)
{
pnl_query.Visible = true;
using (var db = new ScrapSettleContext())
{
var q = from w in db.WeighingSettlement
//where (w.vocherNO.Max())
select new { w.vocherNO };
//赋值时注意对类型q进行转换， 不能直接写成rtxt_voucherNO.Text = q
rtxt_voucherNO.Text = (q.Select(s => s.vocherNO)).Max().ToString();
btn_query.PerformClick();
tsb_previewPrint.Enabled = true;
tsb_print.Enabled = true;
tsb_audit.Enabled = true;
}
}
/// <summary>
/// 保存单据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsb_save_Click(object sender, EventArgs e)
{
if (addOrChangeFlag == addOrChangeMolde.add.ToString())
{
using (var db = new ScrapSettleContext())
{
WeighingSettlementModel w = new WeighingSettlementModel();
saveData(db, w);
}
}
if (addOrChangeFlag == addOrChangeMolde.change.ToString())
{
using (var db = new ScrapSettleContext())
{
WeighingSettlementModel w = db.WeighingSettlement.Where(s => s.vocherNO == lbl_vouchNoValue.Text).FirstOrDefault();
saveData(db, w);
}
}
}
/// <summary>
/// 单据删除方法
/// </summary>
/// <param name="sender"></param>
/// <param name="authorizationEventArgs"></param>
private void deleteVoucher(Object sender, AuthorizationEventArgs authorizationEventArgs)
{
if (lbl_vouchNoValue.Text != "" & lbl_vouchNoValue.Text != null
& lbl_voucherStateValue.Text != EnumModle.voucherStatus.审核.ToString())
{
if (DialogResult.Yes == MessageBox.Show("是否确定删除", "删除提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
try
{
using (var db = new ScrapSettleContext())
{
var del = (from d in db.WeighingSettlement
where (d.vocherNO == lbl_vouchNoValue.Text)
select d).ToList();;
//移除数据库的数据
db.WeighingSettlement.Remove(del[0]);
db.SaveChanges();
clearDate();
lbl_vouchNoValue.Text = "";
dtp_makeDate.Text = "";
rtxt_voucherNO.Text = "";
//修改单据功能状态
tsb_delete.Enabled = false;
tsb_modify.Enabled = false;
tsb_previewPrint.Enabled = false;
tsb_print.Enabled = false;
lbl_voucherStateValue.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show("数据删除出错" + ex.Message + ex.InnerException, "数据删除提示");
}
}
}
else
{
MessageBox.Show("你所删除的单据不存在或单据已经审核", "删除提示");
}
}
/// <summary>
/// 恢复作废单据
/// </summary>
/// <param name="sender"></param>
/// <param name="authorizationEventArgs"></param>
private void restoreVoucher(Object sender, AuthorizationEventArgs authorizationEventArgs)
{
if (lbl_vouchNoValue.Text != "")
{
try
{
using (var db = new ScrapSettleContext())
{
WeighingSettlementModel w = db.WeighingSettlement.Where(s => s.vocherNO == lbl_vouchNoValue.Text).FirstOrDefault();
w.auditFlag = (int)EnumModle.voucherStatus.开立;
db.SaveChanges();
MessageBox.Show("单据恢复成功", "恢复提示");
lbl_voucherStateValue.Text = EnumModle.voucherStatus.开立.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.InnerException, "单据恢复错误提示");
}
}
}
private void tsb_delete_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
var selected = dataGridView1.SelectedRows[0].Cells[1].Value;
if (DialogResult.Yes == MessageBox.Show("是否确定删除", "删除提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
ScrapSettleContext db = new ScrapSettleContext();
List <Income> del = (from d in db.Incomes
where d.VoucherNo == selected.ToString()
select d).ToList <Income>();
//移除数据库的数据
db.Incomes.Remove(del[0]);
db.SaveChanges();
tsb_query.PerformClick();
}
}
return;
}
/// <summary>
/// 密码修改方法
/// </summary>
/// <param name="sender"></param>
/// <param name="authorizationEventArgs"></param>
private void modifyPwdResult(Object sender, ModifyPwdEventArgs auth)
{
if (txt_cusCode.Text != "")
{
try
{
using (var db = new ScrapSettleContext())
{
int code = Convert.ToInt32(txt_cusCode.Text);
Person w = db.Peple.Where(s => s.Code == code).FirstOrDefault();
w.pwd = Encrypt.Encode(auth.pwd);
db.SaveChanges();
MessageBox.Show("密码修改成功", "密码修改提示");
txt_pwd.Text = Encrypt.Encode(auth.pwd);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.InnerException, "修改密码错误提示");
}
}
}
private void updateDate()
{
//查询之后修改并保存
using (var db = new ScrapSettleContext())
{
Customer customer = db.Customers.Where(c => c.CusCode.ToString() == txt_cusCode.Text).FirstOrDefault();
customer.CusCode = System.Convert.ToInt32(txt_cusCode.Text);
customer.CusName = this.txt_cusName.Text;
customer.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
//if (this.tbd_failure.Text != null & this.tbd_failure.Text != "")
//{
// customer.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
//}
if (this.stop)
{
customer.disable = true;
customer.FailuerDate = DateTime.Now;
}
if (stop == false)
{
customer.disable = false;
customer.FailuerDate = null;
}
db.SaveChanges();
MessageBox.Show("数据修改成功！");
this.bind_gv_dateSource();
//清空修改记录
clearDate();
}
}
/// <summary>
/// 绑定dataGridView的数据源
/// </summary>
private void bind_gv_dateSource()
{
this.dataGridView1.DataSource = null;
//查询状态的数据源
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.query.ToString())
{
using (var db = new ScrapSettleContext())
{
var query = from q in db.Coefficients
join c in db.Customers
on q.CustomerID equals c.CusCode
join s in db.Scraps
on q.ScrapID equals s.ScrapCode
select new { q.VoucherNO, c.CusName, s.ScrapName, q.Data, q.EffectDate, q.FailureDate };
dataGridView1.DataSource = query.ToList();
}
}
//新增状态的数据源
else
{
this.dataGridView1.DataSource = archivesList;
}
}
/// <summary>
/// 数据保存算法
/// </summary>
/// <param name="db"></param>
/// <param name="w"></param>
private void saveData(ScrapSettleContext db, WeighingSettlementModel w)
{
//查询时的过滤条件是日期，所以存储值若含时间信息则条件值与存储值比较产生的
//结果非目标数据，如查询当时的数据，因为按日期存储时其默认的时间信息是0时0分0秒
//而查询条年是>=当日与<=当时，其查询结果则会为无匹配数据
//故只按日期存储
//修改数据保存准备
if (addOrChangeFlag == addOrChangeMolde.change.ToString())
{
w.webUnitPrice = String.IsNullOrEmpty(txt_webUnitPrice.Text) is true ? 0 : Convert.ToDouble(txt_webUnitPrice.Text);
w.settleUnitPrice = String.IsNullOrEmpty(txt_settleUnitPrice.Text) is true ? 0 : Convert.ToDouble(txt_settleUnitPrice.Text);
w.settleAmount = String.IsNullOrEmpty(txt_money.Text) is true ? 0 : Convert.ToDouble(txt_money.Text);
w.note = txtNote.Text;
}
//新增数据保存准备
if (addOrChangeFlag == addOrChangeMolde.add.ToString())
{
w.MakeDate = DateTime.Now;
w.WeighingDate = dtp_makeDate.Value.Date;
w.WeightingTime = dtp_makeDate.Value.ToLongTimeString();
w.CustmerCode = cmb_custName.SelectedValue.ToString();
w.GrossWeght = Convert.ToDouble(txt_grossWeight.Text);
w.Tare = Convert.ToDouble(txt_tare.Text);
w.netWeight = txt_netWeight.Text == "" ? w.GrossWeght - w.Tare : Convert.ToDouble(txt_netWeight.Text);
w.VehicleBrand = cmb_vehicleBrand.Text;
w.personCode = cmb_person.SelectedValue.ToString();
w.proportion = Convert.ToDouble(txt_coefficient.Text);
w.scrapCode = cmb_scrapName.SelectedValue.ToString();
w.vocherNO = lbl_vouchNoValue.Text;
w.auditFlag = (int)EnumModle.voucherStatus.开立;
w.note = txtNote.Text;
//考虑到价格信息由业务经办人填写，而非由过磅人填写，故可为空
//w.webUnitPrice = Convert.ToDouble(txt_webUnitPrice.Text);
//w.settleUnitPrice = Convert.ToDouble(txt_settleUnitPrice.Text);
//w.settleAmount = Convert.ToDouble(txt_money.Text);
w.webUnitPrice = txt_webUnitPrice.Text == "" ? 0 : Convert.ToDouble(txt_webUnitPrice.Text);
w.settleUnitPrice = txt_settleUnitPrice.Text == "" ? 0 : Convert.ToDouble(txt_settleUnitPrice.Text);
w.settleAmount = txt_money.Text == "" ? 0 : Convert.ToDouble(txt_money.Text);
db.WeighingSettlement.Add(w);
}
//数据保存
try
{
db.SaveChanges();
tsb_save.Enabled = false;
tsb_print.Enabled = true;
tsb_previewPrint.Enabled = true;
tableLayoutPanel1.Enabled = false;
if (addOrChangeFlag == addOrChangeMolde.change.ToString())
{
tsb_new.Enabled = true;
tsb_audit.Enabled = true;
}
if (addOrChangeFlag == addOrChangeMolde.add.ToString())
{
tsb_modify.Enabled = true;
tsb_delete.Enabled = true;
tsb_audit.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.InnerException, "保存错误提示");
}
}
/// <summary>
/// 一张单据查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_query_Click(object sender, EventArgs e)
{
//因为结算金额文本框定义了textChanged事件，所以定义查询时也触发该事件
//而去计算余额，虽然禁止了tableLayoutPanel,但无法禁止该事件，所以需要对
//事件委托解绑
//实践表明，不初始化combox控件的数据源，则无法对SelectedValue进行赋值
//因为赋值后赋值等式右边虽然有值，但SelectedValue确仍为空，具体什么原因不明？
initializeDatasource();
cmb_custName.SelectedValueChanged -= cmb_custName_SelectedValueChanged;
txt_money.TextChanged -= this.txt_money_TextChanged;
addOrChangeFlag = addOrChangeMolde.query.ToString();
tableLayoutPanel1.Enabled = false;
lbl_balance.Text = "";
using (var db = new ScrapSettleContext())
{
var query = from q in db.WeighingSettlement
join c in db.Customers
on q.CustmerCode equals c.CusCode.ToString()
join p in db.Peple on q.personCode equals p.Code.ToString()
join s in db.Scraps on q.scrapCode equals s.ScrapCode.ToString()
where q.vocherNO == rtxt_voucherNO.Text
select new
{
q.WeighingDate,
q.WeightingTime,
q.vocherNO,
c.CusCode,
c.CusName,
s.ScrapID,
s.ScrapName,
p.Code,
p.Name,
q.VehicleBrand,
q.proportion,
q.webUnitPrice,
q.settleUnitPrice,
q.GrossWeght,
q.Tare,
q.netWeight,
q.settleAmount,
q.auditFlag,
q.note
};
foreach (var item in query)
{
lbl_vouchNoValue.Text = item.vocherNO;
//如果查询有结果，则启用修改菜单与删除菜单
if (lbl_vouchNoValue.Text != "" & lbl_vouchNoValue.Text != null)
{
tsb_modify.Enabled = Enabled;
tsb_delete.Enabled = Enabled;
}
dtp_makeDate.Text = item.WeighingDate.ToString();
txt_weighingTime.Text = item.WeightingTime;
cmb_custName.SelectedValue = item.CusCode.ToString();
cmb_custName.Text = item.CusName;
cmb_scrapName.SelectedValue = item.ScrapID;
cmb_scrapName.Text = item.ScrapName;
cmb_person.SelectedValue = item.Code;
cmb_person.Text = item.Name;
cmb_vehicleBrand.Text = item.VehicleBrand;
txt_coefficient.Text = item.proportion.ToString();
txt_grossWeight.Text = item.GrossWeght.ToString();
txt_tare.Text = item.Tare.ToString();
txt_netWeight.Text = item.netWeight.ToString();
txt_webUnitPrice.Text = item.webUnitPrice.ToString();
txt_settleUnitPrice.Text = item.settleUnitPrice.ToString();
txt_money.Text = item.settleAmount.ToString();
txtNote.Text = item.note;
switch (item.auditFlag)
{
case 0:
lbl_voucherStateValue.Text = EnumModle.voucherStatus.开立.ToString();
break;
case 1: lbl_voucherStateValue.Text = EnumModle.voucherStatus.处理.ToString();
break;
case 2:
lbl_voucherStateValue.Text = EnumModle.voucherStatus.审核.ToString();
tsb_audit.Enabled = false;
break;
case 3:
lbl_voucherStateValue.Text = EnumModle.voucherStatus.作废.ToString();
break;
}
}
}
}
/// <summary>
/// 数据保存与修改
/// </summary>
private void saveOrChang()
{
if (inputVlidate())
{
//新增后保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
using (var db = new ScrapSettleContext())
{
VehicleBrand v = new VehicleBrand();
//注意组合框中的取值不是text属性，而是selectedValue
v.CustomerID = Convert.ToInt32(cmb_cusName.SelectedValue);
v.VehicleBrandValue = txt_vehicleBrandValue.Text;
v.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
v.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
}
try
{
db.VehicleBrands.Add(v);
db.SaveChanges();
//内存数据源
archivesList.Add(v);
var query = from q in archivesList
join c in db.Customers
on q.CustomerID equals c.CusCode
select new { c.CusName, q.VehicleBrandValue, q.EffectDate, q.FailuerDate };
dataGridView1.DataSource = query.ToList();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
clearDate();
//再次调用新增事件
this.tsb_add.PerformClick();
}
}
//查询之后修改并保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.query.ToString())
{
using (var db = new ScrapSettleContext())
{
VehicleBrand v = db.VehicleBrands.Where(c => c.VehicleBrandValue == txt_vehicleBrandValue.Text).FirstOrDefault();
v.CustomerID = Convert.ToInt32(cmb_cusName.SelectedValue);
v.VehicleBrandValue = txt_vehicleBrandValue.Text;
v.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
v.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
}
try
{
db.SaveChanges();
this.bind_gv_dateSource();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
//清空修改记录
clearDate();
}
}
}
;
}
/// <summary>
/// 数据保存与修改
/// </summary>
private void saveOrChang()
{
if (inputVlidate())
{
//新增后保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
using (var db = new ScrapSettleContext())
{
Person person = new Person();
person.Code = Convert.ToInt32(txt_cusCode.Text);
person.Name = this.txt_cusName.Text;
person.pwd = Encrypt.Encode(txt_pwd.Text);
person.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
person.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
}
db.Peple.Add(person);
try
{
db.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
archivesList.Add(person);
this.bind_gv_dateSource();
//清空填制记录
clearDate();
//再次调用新增事件
this.tsb_add.PerformClick();
}
}
//查询之后修改并保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.query.ToString())
{
using (var db = new ScrapSettleContext())
{
Person person = db.Peple.Where(c => c.Code.ToString() == txt_cusCode.Text).FirstOrDefault();
person.Code = System.Convert.ToInt32(txt_cusCode.Text);
person.Name = this.txt_cusName.Text;
person.pwd = Encrypt.Encode(txt_pwd.Text);
person.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & this.tbd_failure.Text != "")
{
person.FailuerDate = Convert.ToDateTime(this.tbd_failure.Text);
}
db.SaveChanges();
this.bind_gv_dateSource();
//清空修改记录
clearDate();
}
}
}
;
}
/// <summary>
/// 数据保存与修改
/// </summary>
private void saveOrChang()
{
if (inputVlidate())
{
//新增后保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.save.ToString())
{
using (var db = new ScrapSettleContext())
{
Coefficient coefficient = new Coefficient();
coefficient.VoucherNO = lbl_vouchNoValue.Text;
//注意组合框中的取值不是text属性，而是selectedValue
coefficient.CustomerID = Convert.ToInt32(cmb_cusName.SelectedValue);
coefficient.ScrapID = Convert.ToInt32(cmb_scrapName.SelectedValue);
coefficient.Data = Convert.ToDouble(txt_data.Text);
coefficient.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
coefficient.FailureDate = Convert.ToDateTime(this.tbd_failure.Text);
}
try
{
db.Coefficients.Add(coefficient);
db.SaveChanges();
//内存数据源
archivesList.Add(coefficient);
var query = from q in archivesList
join c in db.Customers
on q.CustomerID equals c.CusCode
join s in db.Scraps
on q.ScrapID equals s.ScrapCode
select new { q.VoucherNO, c.CusName, s.ScrapName, q.Data, q.EffectDate, q.FailureDate };
dataGridView1.DataSource = query.ToList();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
clearDate();
//再次调用新增事件
this.tsb_add.PerformClick();
}
}
//查询之后修改并保存
if (saveOrModifQueryFlag == saveOrChangeOrQueryMolde.query.ToString())
{
using (var db = new ScrapSettleContext())
{
Coefficient coefficient = db.Coefficients.Where(c => c.VoucherNO.ToString() == lbl_vouchNoValue.Text).FirstOrDefault();
coefficient.CustomerID = Convert.ToInt32(cmb_cusName.SelectedValue);
coefficient.ScrapID = Convert.ToInt32(cmb_scrapName.SelectedValue);
coefficient.Data = Convert.ToDouble(txt_data.Text);
coefficient.EffectDate = Convert.ToDateTime(this.tbd_effect.Text);
if (this.tbd_failure.Text != null & tbd_failure.Text != "")
{
coefficient.FailureDate = Convert.ToDateTime(this.tbd_failure.Text);
}
try
{
db.SaveChanges();
this.bind_gv_dateSource();
}
catch (Exception e)
{
MessageBox.Show("数据保存错误:" + e.Message + e.InnerException, "数据保存提示");
return;
}
//清空修改记录
clearDate();
}
}
}
;
}
