/// <summary> /// 保存数据 /// </summary> /// <param name="db"></param> /// <param name="m"></param> private void saveData(NoteBookContext db, NoteRecordModle m) { //修改数据保存准备 if (addOrChangeFlag == addOrChangeMolde.change.ToString()) { //w.recorder = Convert.ToDouble(txt_webUnitPrice.Text); } //新增数据保存准备 if (addOrChangeFlag == addOrChangeMolde.add.ToString()) { m.voucherNo = lbl_vouchNoValue.Text; m.itemName = txt_itemName.Text; m.makeTime = DateTime.Now; m.requesteDate = dtp_requestDate.Value; m.needCompletedDate = dtp_needCompletedDate.Value; m.planCompletedDate = dtp_planCompletedDate.Value; m.userID = CurrentUser.userID; m.requesteUserID = cmb_requestPerson.SelectedValue.ToString(); m.responsibleUserID = cmb_reponsiblePerson.SelectedValue.ToString(); m.memo = rtb_memo.Text; m.recorder = rtb_summary.Text; m.status = VoucherStatus.开立.ToString(); db.NoteRecords.Add(m); } //数据保存 try { db.SaveChanges(); tsb_save.Enabled = false; tsb_print.Enabled = true; tsb_previewPrint.Enabled = true; if (addOrChangeFlag == addOrChangeMolde.change.ToString()) { tsb_new.Enabled = true; } if (addOrChangeFlag == addOrChangeMolde.add.ToString()) { tsb_modify.Enabled = true; tsb_delete.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.InnerException, "保存错误提示"); } }
/// <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 NoteBookContext()) { NoteRecordModle w = new NoteRecordModle(); saveData(db, w); } } if (addOrChangeFlag == addOrChangeMolde.change.ToString()) { using (var db = new NoteBookContext()) { NoteRecordModle w = db.NoteRecords.Where(s => s.voucherNo == lbl_vouchNoValue.Text).FirstOrDefault(); saveData(db, w); } } }
/// <summary> /// 保存数据 /// </summary> /// <param name="db"></param> /// <param name="w"></param> private void saveData(NoteBookContext db, NoteRecordModle w) { //修改数据保存准备 if (addOrChangeFlag == addOrChangeMolde.change.ToString()) { //w.recorder = Convert.ToDouble(txt_webUnitPrice.Text); } //新增数据保存准备 if (addOrChangeFlag == addOrChangeMolde.add.ToString()) { w.makeTime = DateTime.Now; w.userID = lbl_personCode.Text; w.voucherNo = CurrentUser.userID; db.NoteRecords.Add(w); } //数据保存 try { db.SaveChanges(); tsb_save.Enabled = false; tsb_print.Enabled = true; tsb_previewPrint.Enabled = true; if (addOrChangeFlag == addOrChangeMolde.change.ToString()) { tsb_new.Enabled = true; } if (addOrChangeFlag == addOrChangeMolde.add.ToString()) { tsb_modify.Enabled = true; tsb_delete.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.InnerException, "保存错误提示"); } }