//获取输入数据 private BillTicket GetSaveEntity() { var entity = new BillTicket(); if (string.IsNullOrEmpty(hidID.Value.Trim()) == false) entity.ID = int.Parse(hidID.Value.Trim()); //hardcode according ddldep text entity.DepName = ddlDept.SelectedItem.Text; //??还是根据内部订单号前2位决定部门?? //if (string.IsNullOrEmpty(hidDepId.Value.Trim()) == false) // entity.DepId = int.Parse(hidDepId.Value.Trim()); //else { if (entity.DepName.Contains("Düsseldorf")) entity.DepId = 1; else if (entity.DepName.Contains("Stuttgart")) entity.DepId = 2; else if (entity.DepName.Contains("Maastricht") || entity.DepName.Contains("Arnhem")) entity.DepId = 3; else if (entity.DepName.Contains("肇庆")) entity.DepId = 4; else if (entity.DepName.Contains("Köln")) entity.DepId = 5; } if (string.IsNullOrEmpty(txtDepAddress.Text.Trim()) == false) entity.DepAddress = txtDepAddress.Text.Trim(); if (string.IsNullOrEmpty(txtInnerReferenceID.Text.Trim()) == false) entity.InnerReferenceID = txtInnerReferenceID.Text.Trim(); if (string.IsNullOrEmpty(txtBookingDate.Text.Trim()) == false) entity.BookingDate = DateTime.Parse(txtBookingDate.Text.Trim()); entity.ParentCompany = txtParentCompany.Text; if (string.IsNullOrEmpty(txtCustName.Text.Trim()) == false) entity.CustName = txtCustName.Text.Trim(); entity.CustAddress = txtCustAddress.Text.Trim(); entity.CustTel = txtCustTel.Text.Trim(); entity.CustFax = txtCustFax.Text.Trim(); entity.CustEmail = txtCustEmail.Text.Trim(); if (hidCustID.Text != "") entity.CustID = long.Parse(hidCustID.Text); else entity.CustID = CustSvr.GetCustIDByName(entity.CustName, entity.CustAddress, entity.CustTel, entity.CustEmail, base.LoginUserID, int.Parse(txtCustOwnerID.Text.Trim()), true); entity.ProdProvider = txtAirline.Text.Trim(); entity.BankAccount = txtBankAccount.Text.Trim(); entity.Currency = "EUR"; entity.Accessory = txtAccessory.Text; entity.MaxLuggage = txtMaxLuggage.Text; entity.CancellationFee = txtCancellationFee.Text; entity.ChangeFee = txtChangeFee.Text; entity.PaymentDate = txtPaymentDate.Text; entity.DestinationRegion = ddlDestination.Text; if (string.IsNullOrEmpty(txtCustCDate.Text.Trim()) == false) entity.CreateDate = DateTime.Parse(txtCustCDate.Text.Trim()); if (string.IsNullOrEmpty(txtCustCUserID.Value.Trim()) == false) entity.CreateUserID = int.Parse(txtCustCUserID.Value.Trim()); if (string.IsNullOrEmpty(txtCustOwnerID.Text.Trim()) == false) entity.CustOwnerID = int.Parse(txtCustOwnerID.Text.Trim()); entity.ModifyDate = DateTime.Now; entity.ModifyUserID = base.LoginUserID; //还没想好Status字段用途 entity.Status = 'A'; return entity; }
//获取输入数据 private BillTicket GetSaveEntity() { var entity = new BillTicket(); if (string.IsNullOrEmpty(hidID.Value.Trim()) == false) { entity.ID = int.Parse(hidID.Value.Trim()); } //hardcode according ddldep text entity.DepName = ddlDept.SelectedItem.Text; //??还是根据内部订单号前2位决定部门?? //if (string.IsNullOrEmpty(hidDepId.Value.Trim()) == false) // entity.DepId = int.Parse(hidDepId.Value.Trim()); //else { if (entity.DepName.Contains("Düsseldorf")) { entity.DepId = 1; } else if (entity.DepName.Contains("Stuttgart")) { entity.DepId = 2; } else if (entity.DepName.Contains("Maastricht") || entity.DepName.Contains("Arnhem")) { entity.DepId = 3; } else if (entity.DepName.Contains("肇庆")) { entity.DepId = 4; } else if (entity.DepName.Contains("Köln")) { entity.DepId = 5; } } if (string.IsNullOrEmpty(txtDepAddress.Text.Trim()) == false) { entity.DepAddress = txtDepAddress.Text.Trim(); } if (string.IsNullOrEmpty(txtInnerReferenceID.Text.Trim()) == false) { entity.InnerReferenceID = txtInnerReferenceID.Text.Trim(); } if (string.IsNullOrEmpty(txtBookingDate.Text.Trim()) == false) { entity.BookingDate = DateTime.Parse(txtBookingDate.Text.Trim()); } entity.ParentCompany = txtParentCompany.Text; if (string.IsNullOrEmpty(txtCustName.Text.Trim()) == false) { entity.CustName = txtCustName.Text.Trim(); } entity.CustAddress = txtCustAddress.Text.Trim(); entity.CustTel = txtCustTel.Text.Trim(); entity.CustFax = txtCustFax.Text.Trim(); entity.CustEmail = txtCustEmail.Text.Trim(); if (hidCustID.Text != "") { entity.CustID = long.Parse(hidCustID.Text); } else { entity.CustID = CustSvr.GetCustIDByName(entity.CustName, entity.CustAddress, entity.CustTel, entity.CustEmail, base.LoginUserID, int.Parse(txtCustOwnerID.Text.Trim()), true); } entity.ProdProvider = txtAirline.Text.Trim(); entity.BankAccount = txtBankAccount.Text.Trim(); entity.Currency = "EUR"; entity.Accessory = txtAccessory.Text; entity.MaxLuggage = txtMaxLuggage.Text; entity.CancellationFee = txtCancellationFee.Text; entity.ChangeFee = txtChangeFee.Text; entity.PaymentDate = txtPaymentDate.Text; entity.DestinationRegion = ddlDestination.Text; if (string.IsNullOrEmpty(txtCustCDate.Text.Trim()) == false) { entity.CreateDate = DateTime.Parse(txtCustCDate.Text.Trim()); } if (string.IsNullOrEmpty(txtCustCUserID.Value.Trim()) == false) { entity.CreateUserID = int.Parse(txtCustCUserID.Value.Trim()); } if (string.IsNullOrEmpty(txtCustOwnerID.Text.Trim()) == false) { entity.CustOwnerID = int.Parse(txtCustOwnerID.Text.Trim()); } entity.ModifyDate = DateTime.Now; entity.ModifyUserID = base.LoginUserID; //还没想好Status字段用途 entity.Status = 'A'; return(entity); }
private void AddAuditLog(BillTicket oldEntity, BillTicket newEntity) { string oldOwner = "", newOwner = ""; DataTable dtUser = base.GetUser(); DataRow[] drs = dtUser.Select("UserID=" + oldEntity.CustOwnerID); if (drs.Length > 0) { oldOwner = drs[0]["UserFullName"].ToString(); } drs = dtUser.Select("UserID=" + newEntity.CustOwnerID); if (drs.Length > 0) { newOwner = drs[0]["UserFullName"].ToString(); } CRMAuditLog Log = new CRMAuditLog(); Log.Action = "SaveTicket"; //界面显示时再转成多语言 SaveCustomer,SaveDeal,SaveUser Log.ActionAt = DateTime.Now; Log.ActionBy = newEntity.ModifyUserID; Log.PKId = newEntity.ID; string ActionLog = ""; if (oldEntity.DepName != newEntity.DepName) { ActionLog += "部门:" + oldEntity.DepName + "=>" + newEntity.DepName + " ;"; } if (oldEntity.DepAddress != newEntity.DepAddress) { ActionLog += "公司地址:" + oldEntity.DepAddress + "=>" + newEntity.DepAddress + " ;"; } if (oldEntity.InnerReferenceID != newEntity.InnerReferenceID) { ActionLog += "内部预订号:" + oldEntity.InnerReferenceID + "=>" + newEntity.InnerReferenceID + " ;"; } if (oldEntity.BookingDate != newEntity.BookingDate) { ActionLog += "预订日期:" + oldEntity.BookingDate + "=>" + newEntity.BookingDate + " ;"; } if (oldEntity.CustID != newEntity.CustID) { ActionLog += "CustID:" + oldEntity.CustID + "=>" + newEntity.CustID + " ;"; } if (oldEntity.CustName != newEntity.CustName) { ActionLog += "客户姓名:" + oldEntity.CustName + "=>" + newEntity.CustName + " ;"; } if (oldEntity.CustEmail != newEntity.CustEmail) { ActionLog += "电邮:" + oldEntity.CustEmail + "=>" + newEntity.CustEmail + " ;"; } if (oldEntity.CustAddress != newEntity.CustAddress) { ActionLog += "客户地址:" + oldEntity.CustAddress + "=>" + newEntity.CustAddress + " ;"; } if (oldEntity.CustTel != newEntity.CustTel) { ActionLog += "电话:" + oldEntity.CustTel + "=>" + newEntity.CustTel + " ;"; } if (oldEntity.CustOwnerID != newEntity.CustOwnerID) { ActionLog += "所属销售:" + oldOwner + "=>" + newOwner + " ;"; } //if (oldEntity.BankAccount != newEntity.BankAccount) // ActionLog += "BankAccount:" + oldEntity.BankAccount + "=>" + newEntity.BankAccount + " ;"; //if (oldEntity.Currency != newEntity.Currency) // ActionLog += "Currency:" + oldEntity.Currency + "=>" + newEntity.Currency + " ;"; if (oldEntity.TotalAmount != newEntity.TotalAmount) { ActionLog += "总价:" + oldEntity.TotalAmount + "=>" + newEntity.TotalAmount + " ;"; } if (oldEntity.ProdProvider != newEntity.ProdProvider) { ActionLog += "航空公司:" + oldEntity.ProdProvider + "=>" + newEntity.ProdProvider + " ;"; } if (oldEntity.Accessory != newEntity.Accessory) { ActionLog += "Leistung:" + oldEntity.Accessory + "=>" + newEntity.Accessory + " ;"; } if (oldEntity.MaxLuggage != newEntity.MaxLuggage) { ActionLog += "行李重量:" + oldEntity.MaxLuggage + "=>" + newEntity.MaxLuggage + " ;"; } if (oldEntity.CancellationFee != newEntity.CancellationFee) { ActionLog += "取消费用:" + oldEntity.CancellationFee + "=>" + newEntity.CancellationFee + " ;"; } if (oldEntity.ChangeFee != newEntity.ChangeFee) { ActionLog += "改签费用:" + oldEntity.ChangeFee + "=>" + newEntity.ChangeFee + " ;"; } if (oldEntity.PaymentDate != newEntity.PaymentDate) { ActionLog += "付款日期:" + oldEntity.PaymentDate + "=>" + newEntity.PaymentDate + " ;"; } if (oldEntity.DestinationRegion != newEntity.DestinationRegion) { ActionLog += "目的国:" + oldEntity.DestinationRegion + "=>" + newEntity.DestinationRegion + " ;"; } if (oldEntity.Status != newEntity.Status) { ActionLog += "Status:" + oldEntity.Status + "=>" + newEntity.Status + " ;"; } Log.ActionLog = ActionLog; this.CRMAuditLogs.InsertOnSubmit(Log); }
public BillTicket Save(BillTicket entity, IList <BillTicketPerson> PersonList, IList <BillTicketTour> TourList) { if (this.dataCtx.Connection != null) { if (this.dataCtx.Connection.State == ConnectionState.Closed) { this.dataCtx.Connection.Open(); } } DbTransaction tran = this.dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; string AuditLog = ""; try { //由BillTicketTour的Price合计算出总价 entity.TotalAmount = TourList.Sum(t => t.Price); //查询是否存在db var qry = from t in BillTickets where t.ID == entity.ID select t; var obj = qry.SingleOrDefault(); if (obj != null) { //对比新旧记录,增加auditlog this.AddAuditLog(obj, entity); this.CopyEntity(obj, entity); } else { this.BillTickets.InsertOnSubmit(entity); } this.dataCtx.SubmitChanges(); //-------------- Delete & Insert TicketPerson Again ------------- var OldPersonList = this.BillTicketPersons.Where(t => t.TicketID == entity.ID).ToList(); if (CompareListObject(OldPersonList, PersonList) == false) { AuditLog = "修改乘客信息"; } this.BillTicketPersons.DeleteAllOnSubmit(OldPersonList); if (PersonList != null) { foreach (var person in PersonList) { //如果是新增信息,id=0,要赋值 if (person.TicketID == 0) { person.TicketID = entity.ID; } //PersonAmount decimal PersonAmount = TourList.Where(p => p.OwnerName.Equals(person.OwnerName)).Sum(t => t.Price); person.Price = PersonAmount; if (person.OwnerName.Trim() != "") { this.BillTicketPersons.InsertOnSubmit(person); } } } this.dataCtx.SubmitChanges(); //-------------- Delete & Insert TourList Again ------------- var OldBillTicketTours = this.BillTicketTours.Where(t => t.TicketID == entity.ID).ToList(); if (CompareListObject(OldBillTicketTours, TourList) == false) { AuditLog += " 修改行程信息"; } this.BillTicketTours.DeleteAllOnSubmit(OldBillTicketTours); if (TourList != null) { foreach (var tour in TourList) { //如果是新增信息,id=0,要赋值 if (tour.TicketID == 0) { tour.TicketID = entity.ID; } //如果填写了机票号,或者金额不为0,保存行程记录 if (tour.FlightNum.Trim() != "" || tour.Price != 0) { this.BillTicketTours.InsertOnSubmit(tour); } } } if (AuditLog != "") { this.AddAuditLog(AuditLog, entity.ModifyUserID, entity.ID); } this.dataCtx.SubmitChanges(); //------------Sync to CRMCustomerDeal------------- Sync2CRMCustomerDeal(entity.InnerReferenceID); tran.Commit(); return(entity); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }
private void AddAuditLog(BillTicket oldEntity, BillTicket newEntity) { string oldOwner="", newOwner=""; DataTable dtUser = base.GetUser(); DataRow[] drs = dtUser.Select("UserID=" + oldEntity.CustOwnerID); if (drs.Length > 0) { oldOwner = drs[0]["UserFullName"].ToString(); } drs = dtUser.Select("UserID=" + newEntity.CustOwnerID); if (drs.Length > 0) { newOwner = drs[0]["UserFullName"].ToString(); } CRMAuditLog Log = new CRMAuditLog(); Log.Action = "SaveTicket"; //界面显示时再转成多语言 SaveCustomer,SaveDeal,SaveUser Log.ActionAt = DateTime.Now; Log.ActionBy = newEntity.ModifyUserID; Log.PKId = newEntity.ID; string ActionLog = ""; if (oldEntity.DepName != newEntity.DepName) ActionLog += "部门:" + oldEntity.DepName + "=>" + newEntity.DepName + " ;"; if (oldEntity.DepAddress != newEntity.DepAddress) ActionLog += "公司地址:" + oldEntity.DepAddress + "=>" + newEntity.DepAddress + " ;"; if (oldEntity.InnerReferenceID != newEntity.InnerReferenceID) ActionLog += "内部预订号:" + oldEntity.InnerReferenceID + "=>" + newEntity.InnerReferenceID + " ;"; if (oldEntity.BookingDate != newEntity.BookingDate) ActionLog += "预订日期:" + oldEntity.BookingDate + "=>" + newEntity.BookingDate + " ;"; if (oldEntity.CustID != newEntity.CustID) ActionLog += "CustID:" + oldEntity.CustID + "=>" + newEntity.CustID + " ;"; if (oldEntity.CustName != newEntity.CustName) ActionLog += "客户姓名:" + oldEntity.CustName + "=>" + newEntity.CustName + " ;"; if (oldEntity.CustEmail != newEntity.CustEmail) ActionLog += "电邮:" + oldEntity.CustEmail + "=>" + newEntity.CustEmail + " ;"; if (oldEntity.CustAddress != newEntity.CustAddress) ActionLog += "客户地址:" + oldEntity.CustAddress + "=>" + newEntity.CustAddress + " ;"; if (oldEntity.CustTel != newEntity.CustTel) ActionLog += "电话:" + oldEntity.CustTel + "=>" + newEntity.CustTel + " ;"; if (oldEntity.CustOwnerID != newEntity.CustOwnerID) ActionLog += "所属销售:" + oldOwner + "=>" + newOwner + " ;"; //if (oldEntity.BankAccount != newEntity.BankAccount) // ActionLog += "BankAccount:" + oldEntity.BankAccount + "=>" + newEntity.BankAccount + " ;"; //if (oldEntity.Currency != newEntity.Currency) // ActionLog += "Currency:" + oldEntity.Currency + "=>" + newEntity.Currency + " ;"; if (oldEntity.TotalAmount != newEntity.TotalAmount) ActionLog += "总价:" + oldEntity.TotalAmount + "=>" + newEntity.TotalAmount + " ;"; if (oldEntity.ProdProvider != newEntity.ProdProvider) ActionLog += "航空公司:" + oldEntity.ProdProvider + "=>" + newEntity.ProdProvider + " ;"; if (oldEntity.Accessory != newEntity.Accessory) ActionLog += "Leistung:" + oldEntity.Accessory + "=>" + newEntity.Accessory + " ;"; if (oldEntity.MaxLuggage != newEntity.MaxLuggage) ActionLog += "行李重量:" + oldEntity.MaxLuggage + "=>" + newEntity.MaxLuggage + " ;"; if (oldEntity.CancellationFee != newEntity.CancellationFee) ActionLog += "取消费用:" + oldEntity.CancellationFee + "=>" + newEntity.CancellationFee + " ;"; if (oldEntity.ChangeFee != newEntity.ChangeFee) ActionLog += "改签费用:" + oldEntity.ChangeFee + "=>" + newEntity.ChangeFee + " ;"; if (oldEntity.PaymentDate != newEntity.PaymentDate) ActionLog += "付款日期:" + oldEntity.PaymentDate + "=>" + newEntity.PaymentDate + " ;"; if (oldEntity.DestinationRegion != newEntity.DestinationRegion) ActionLog += "目的国:" + oldEntity.DestinationRegion + "=>" + newEntity.DestinationRegion + " ;"; if (oldEntity.Status != newEntity.Status) ActionLog += "Status:" + oldEntity.Status + "=>" + newEntity.Status + " ;"; Log.ActionLog = ActionLog; this.CRMAuditLogs.InsertOnSubmit(Log); }
public BillTicket Save(BillTicket entity, IList<BillTicketPerson> PersonList, IList<BillTicketTour> TourList) { if (this.dataCtx.Connection != null) if (this.dataCtx.Connection.State == ConnectionState.Closed) this.dataCtx.Connection.Open(); DbTransaction tran = this.dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; string AuditLog = ""; try { //由BillTicketTour的Price合计算出总价 entity.TotalAmount = TourList.Sum(t => t.Price); //查询是否存在db var qry = from t in BillTickets where t.ID == entity.ID select t; var obj = qry.SingleOrDefault(); if (obj != null) { //对比新旧记录,增加auditlog this.AddAuditLog(obj, entity); this.CopyEntity(obj, entity); } else this.BillTickets.InsertOnSubmit(entity); this.dataCtx.SubmitChanges(); //-------------- Delete & Insert TicketPerson Again ------------- var OldPersonList = this.BillTicketPersons.Where(t => t.TicketID == entity.ID).ToList(); if (CompareListObject(OldPersonList, PersonList) == false) AuditLog = "修改乘客信息"; this.BillTicketPersons.DeleteAllOnSubmit(OldPersonList); if (PersonList != null) { foreach (var person in PersonList) { //如果是新增信息,id=0,要赋值 if (person.TicketID == 0) person.TicketID = entity.ID; //PersonAmount decimal PersonAmount = TourList.Where(p => p.OwnerName.Equals(person.OwnerName)).Sum(t => t.Price); person.Price = PersonAmount; if (person.OwnerName.Trim() != "") this.BillTicketPersons.InsertOnSubmit(person); } } this.dataCtx.SubmitChanges(); //-------------- Delete & Insert TourList Again ------------- var OldBillTicketTours = this.BillTicketTours.Where(t => t.TicketID == entity.ID).ToList(); if (CompareListObject(OldBillTicketTours, TourList) == false) AuditLog += " 修改行程信息"; this.BillTicketTours.DeleteAllOnSubmit(OldBillTicketTours); if (TourList != null) { foreach (var tour in TourList) { //如果是新增信息,id=0,要赋值 if (tour.TicketID == 0) tour.TicketID = entity.ID; //如果填写了机票号,或者金额不为0,保存行程记录 if (tour.FlightNum.Trim() != "" || tour.Price!=0) this.BillTicketTours.InsertOnSubmit(tour); } } if(AuditLog!="") this.AddAuditLog(AuditLog, entity.ModifyUserID, entity.ID); this.dataCtx.SubmitChanges(); //------------Sync to CRMCustomerDeal------------- Sync2CRMCustomerDeal(entity.InnerReferenceID); tran.Commit(); return entity; } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }