/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(EditLog model, SqlTransaction tran = null) { StringBuilder strSql = new StringBuilder(); strSql.Append("update EditLog set "); strSql.Append("UserID=@UserID,OldValue=@OldValue,NewValue=@NewValue,Type=@Type,CreateTime=@CreateTime"); strSql.Append(" where EditLogId=@EditLogId"); SqlParameter[] parameters = { new SqlParameter("@UserID", model.UserID), new SqlParameter("@OldValue", model.OldValue), new SqlParameter("@NewValue", model.NewValue), new SqlParameter("@Type", model.Type), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@EditLogId", model.EditLogId) }; if (tran == null) { return(SqlHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters) > 0); } else { return(SqlHelper.ExecuteSql(tran, CommandType.Text, strSql.ToString(), parameters) > 0); } }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(EditLog model, SqlTransaction tran = null) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into EditLog("); strSql.Append(" UserID,OldValue,NewValue,Type,CreateTime )"); strSql.Append(" values ("); strSql.Append("@UserID,@OldValue,@NewValue,@Type,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", model.UserID), new SqlParameter("@OldValue", model.OldValue), new SqlParameter("@NewValue", model.NewValue), new SqlParameter("@Type", model.Type), new SqlParameter("@CreateTime", model.CreateTime), }; object obj; if (tran == null) { obj = SqlHelper.GetSingle(strSql.ToString(), CommandType.Text, parameters); } else { obj = SqlHelper.GetSingle(tran, CommandType.Text, strSql.ToString(), parameters); } return(obj == null ? 0 : Convert.ToInt32(obj)); }
public void CreateEditRecord(EditLog model) { var ErrorModel = MongoDBHelper.EditLog.Find(c => c.BillNo == model.BillNo && c.CreateTime == model.CreateTime).FirstOrDefault(); if (ErrorModel != null) { //存在这个数据就不再插入 return; } model.NumberID = GetMaxBillNo() + 1; MongoDBHelper.EditLog.InsertOne(model); }
/// <summary> /// 修改 (可能有其他业务逻辑检查) /// </summary> /// <param name="model"></param> /// <returns></returns> public ResultInfo Update(EditLog model, SqlTransaction tran = null) { ResultInfo ri = new ResultInfo(); if (Edit(model, tran)) { ri.Ok = true; ri.Msg = "修改成功"; } return(ri); }
private void MenuItemLog_Click(object sender, RoutedEventArgs e) { EditLog editImageSetLog = new EditLog(this.DataHandler.FileDatabase.ImageSet.Log, this) { Owner = this }; bool?result = editImageSetLog.ShowDialog(); if (result == true) { this.DataHandler.FileDatabase.ImageSet.Log = editImageSetLog.Log.Text; this.DataHandler.FileDatabase.UpdateSyncImageSetToDatabase(); } }
/// <summary> /// 保存 (可能有其他业务逻辑检查) /// </summary> /// <param name="model">实体</param> /// <returns></returns> public ResultInfo Create(EditLog model, SqlTransaction tran = null) { ResultInfo ri = new ResultInfo(); if (model == null) { return(ri); } int result = Add(model, tran); if (result > 0) { ri.Ok = true; ri.Msg = "添加成功"; } return(ri); }
public bool IsChangedThisMonth(long userID, int edittype) { EditLog model = ModelConvertHelper <EditLog> .ConverToModel(dal.GetEditLogByNew(userID, edittype)); if (model != null) { if (model.CreateTime.HasValue) { int editMonth = model.CreateTime.Value.Month; int editYear = model.CreateTime.Value.Year; int nowMonth = DateTime.Now.Month; int nowYear = DateTime.Now.Year; if (editYear < nowYear) { return(false); } else if (editYear == nowYear) { if (editMonth < nowMonth) { return(false); } else { return(true); } } else { return(true); } } else { return(false); } } else { return(false); } }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="model">实体对象</param> /// <returns></returns> public bool Edit(EditLog model, SqlTransaction tran = null) { return(dal.Update(model, tran)); }
/// <summary> /// 添加一条记录,没有任何逻辑 /// </summary> /// <param name="model">实体对象</param> /// <returns></returns> public int Add(EditLog model, SqlTransaction tran = null) { return(dal.Add(model, tran)); }
/// <summary> /// 保存单据修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public string SaveBillChange(EditBillModel model) { try { var employee = Marisfrolg.Public.Common.GetEmployeeInfo(); EditBillModel OriginalModel = new EditBillModel(); EditLog Editform = new EditLog(); string result = ""; switch (model.BillsType) { //费用单 case "1": var list1 = new FeeBill().GetBillModel(model.BillNo); OriginalModel = list1.MapTo <FeeBillModel, EditBillModel>(); OriginalModel.Brand = list1.PersonInfo.Brand; OriginalModel.CostCenter = list1.PersonInfo.CostCenter; var obj1 = GetCompanyInfo(list1.PersonInfo.IsHeadOffice, model.CostCenter); model.E_Company = obj1.NAME; model.E_CompanyCode = obj1.CODE; result = new FeeBill().SaveFeeBillChange(model); break; //付款单 case "2": var list2 = new NoticeBill().GetBillModel(model.BillNo); OriginalModel.BillNo = list2.BillNo; OriginalModel.BillsType = list2.BillsType; OriginalModel.BillsItems = list2.BillsItems; OriginalModel.Brand = list2.PersonInfo.Brand; OriginalModel.CostCenter = list2.PersonInfo.CostCenter; OriginalModel.Currency = list2.Currency; OriginalModel.Items = list2.Items; OriginalModel.MissBill = list2.MissBill; OriginalModel.SpecialAttribute = new SpecialAttribute() { Agent = list2.SpecialAttribute.Agent, Funds = list2.SpecialAttribute.Funds, Check = list2.SpecialAttribute.Check, BankDebt = 0, MarketDebt = 0, Cash = 0 }; OriginalModel.MissBill = list2.MissBill; OriginalModel.Photos = list2.Photos; var obj2 = GetCompanyInfo(list2.PersonInfo.IsHeadOffice, model.CostCenter); model.E_Company = obj2.NAME; model.E_CompanyCode = obj2.CODE; result = new NoticeBill().SaveNoticeBillChange(model); break; //借款单 case "3": var list3 = new BorrowBill().GetBillModel(model.BillNo); OriginalModel = list3.MapTo <BorrowBillModel, EditBillModel>(); OriginalModel.SpecialAttribute = list3.SpecialAttribute; OriginalModel.Brand = list3.PersonInfo.Brand; OriginalModel.CostCenter = list3.PersonInfo.CostCenter; var obj3 = GetCompanyInfo(list3.PersonInfo.IsHeadOffice, model.CostCenter); model.E_Company = obj3.NAME; model.E_CompanyCode = obj3.CODE; result = new BorrowBill().SaveBorrowBillChange(model); break; //费用还款单 case "4": var list4 = new RefundBill().GetBillModel(model.BillNo); OriginalModel = list4.MapTo <RefundBillModel, EditBillModel>(); OriginalModel.Brand = list4.PersonInfo.Brand; OriginalModel.CostCenter = list4.PersonInfo.CostCenter; var obj4 = GetCompanyInfo(list4.PersonInfo.IsHeadOffice, model.CostCenter); model.E_Company = obj4.NAME; model.E_CompanyCode = obj4.CODE; result = new RefundBill().SaveRefundBillChange(model); break; default: break; } Editform.BillNo = model.BillNo; Editform.CreateTime = DateTime.Now; Editform.Creator = employee.EmployeeNo; Editform.OriginalData = OriginalModel; Editform.ModifiedData = model; new EditLogForm().CreateEditRecord(Editform); return(result); } catch (Exception ex) { Logger.Write("保存单据失败:" + ex.ToString() + "," + System.Reflection.MethodBase.GetCurrentMethod().Name); return(""); } }