/// <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("");
}
}
