/// <summary>
/// 增加一条数据
/// </summary>
public void Add(InvoiceRegister model)
{
using (DBHelper db = DBHelper.Create())
{
db.Insert<InvoiceRegister>(model);
}
}
public ActionResult DeleteConfirmed(int id)
{
InvoiceRegister invoiceRegister = db.InvoiceRegisters.Find(id);
db.InvoiceRegisters.Remove(invoiceRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "KeyId,CustomerFK,PhoneNumberFK,CostRegister")] InvoiceRegister invoiceRegister)
{
if (ModelState.IsValid)
{
db.Entry(invoiceRegister).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(invoiceRegister));
}
public InvoiceRegister Update(InvoiceRegister invoiceRegister)
{
if (invoiceRegister == null)
{
return(null);
}
db.Entry(invoiceRegister).State = EntityState.Modified;
SaveChanges();
return(invoiceRegister);
}
public InvoiceRegister Add(InvoiceRegister invoiceRegister)
{
if (invoiceRegister == null)
{
return(null);
}
db.Entry(invoiceRegister).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
return(invoiceRegister);
}
public ActionResult Create([Bind(Include = "KeyId,CustomerFK,PhoneNumberFK,CostRegister")] InvoiceRegister invoiceRegister)
{
if (ModelState.IsValid)
{
db.InvoiceRegisters.Add(invoiceRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(invoiceRegister));
}
// GET: InvoiceRegister/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvoiceRegister invoiceRegister = db.InvoiceRegisters.Find(id);
if (invoiceRegister == null)
{
return(HttpNotFound());
}
return(View(invoiceRegister));
}
private void LoadRegister(InvoiceRegister register)
{
if (register != null)
{
int n = grvRegister.Rows.Add();
grvRegister.Rows[n].Cells[0].Value = register.KeyId;
grvRegister.Rows[n].Cells[1].Value = register.CustomerFKNavigation.CustomerName;
grvRegister.Rows[n].Cells[2].Value = register.CustomerFKNavigation.CMND;
grvRegister.Rows[n].Cells[3].Value = register.PhoneNumberFKNavigation.PhoneNo;
grvRegister.Rows[n].Cells[4].Value = register.DateRegisted;
grvRegister.Rows[n].Cells[5].Value = register.CostRegister;
grvRegister.Rows[n].Cells[6].Value = (register.Status) ? "Bình thường" : "Khóa";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(InvoiceRegister model)
{
Dictionary<string, object> param = new Dictionary<string, object>();
string strSql = @"update T_InvoiceRegister set
BeginCode=@beginCode,EndCode=@endCode ,InvoiceType=@InvoiceType
where ID=@ID";
param.Add("beginCode", model.BeginCode);
param.Add("endCode", model.EndCode);
param.Add("InvoiceType", model.InvoiceType);
param.Add("ID", model.ID);
using (DBHelper db = DBHelper.Create())
{
int effectLine=db.ExecuteNonQuery(strSql, param);
return effectLine>0?true:false;
}
}
/// <summary>
/// 编辑票据
/// </summary>
/// <param name="IR"></param>
/// <returns></returns>
public ActionResult ModifyInvoice(InvoiceRegister IR)
{
AjaxResult result = new AjaxResult();
try
{
result.Success = new InvoiceRegisterRule().Update(IR);
result.Message = result.Success ? "更新成功" : "更新失败";
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增票据登记
/// </summary>
/// <param name="IR"></param>
/// <returns></returns>
public ActionResult AddInvoice(InvoiceRegister IR)
{
AjaxResult result = new AjaxResult();
IR.ID = Guid.NewGuid().ToString("N");
IR.RegisterTime = DateTime.Now;
IR.OperatorID = MyTicket.CurrentTicket.EmployeeID;
IR.UseStatus = 0;
try
{
new InvoiceRegisterRule().Add(IR);
result.Success = true;
result.Message = "票据已经成功登记。";
}
catch (Exception ex)
{
result.Success = false;
result.Message = "票据登记失败" + ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool SaveEntities(InvoiceRegister invoiceRegister)
{
if (invoiceRegister.KeyId == 0)
{
if (invoiceRegisterDAL.Add(invoiceRegister) != null)
{
PhoneNumber phoneNumber = phoneNumberDAL.GetById(invoiceRegister.PhoneNumberFK);
phoneNumber.Status = true;
if (phoneNumberDAL.Update(phoneNumber) != null)
{
return(true);
}
}
return(false);
}
else
{
if (invoiceRegisterDAL.Update(invoiceRegister) != null)
{
PhoneNumber phoneNumber = phoneNumberDAL.GetById(invoiceRegister.PhoneNumberFK);
phoneNumber.Status = false;
SIM sIM = simDAL.GetTheLastestSIM(phoneNumber.PhoneNo);
sIM.Status = false;
if (invoiceRegisterDAL.Update(invoiceRegister) != null)
{
if (phoneNumberDAL.Update(phoneNumber) != null)
{
if (simDAL.Update(sIM) != null)
{
return(true);
}
}
}
}
return(false);
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
InvoiceRegister register = new InvoiceRegister();
if (invoiceRegisterBUS.CheckRegisterInformations(lblRegisterCustomerKeyId.Text, cbxRegisterPhoneNumber.Text, txtRegisterCost.Text))
{
register.CustomerFK = Convert.ToInt32(lblRegisterCustomerKeyId.Text);
register.PhoneNumberFK = phoneNumberBUS.GetByPhoneNumber(cbxRegisterPhoneNumber.Text).KeyId;
register.CostRegister = Convert.ToInt32(txtRegisterCost.Text);
register.Status = true;
register.DateRegisted = DateTime.Now;
if (invoiceRegisterBUS.SaveEntities(register))
{
MessageBox.Show("Đăng ký thành công");
GetComboboxPhoneNumber(cbxRegisterPhoneNumber, true);
cbxRegisterPhoneNumber.SelectedIndex = -1;
cbxRegisterPhoneNumber.Text = "";
txtRegisterCost.Text = "";
txtRegisterCustomer.Text = "";
lblRegisterCustomerKeyId.Text = "xxx";
lblRegisterCustomerName.Text = "xxx";
lblRegisterIdentity.Text = "xxx";
lblRegisterAddress.Text = "xxx";
lblRegisterEmail.Text = "xxx";
LoadAll();
}
else
{
MessageBox.Show("Có lỗi trong quá trình ghi");
}
}
}
