/// <summary>
/// 更新固定资产信息
/// </summary>
/// <param name="item">固定资产对象</param>
/// <returns></returns>
public string UpdAssets(T_Assets item)
{
string msg = string.Empty;
item.C_GUID = Session["CurrentCompany"].ToString();
bool result = new FixedAssetsSvc().UpdAssets(item);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
/// <summary>
/// 更新资产
/// </summary>
/// <param name="item">资产对象</param>
/// <returns></returns>
public bool UpdAssets(T_Assets item)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdAssets";
dh.AddPare("@ID", SqlDbType.NVarChar, 50, item.A_GUID);
dh.AddPare("@No", SqlDbType.NVarChar, 100, item.No);
dh.AddPare("@NAME", SqlDbType.NVarChar, 100, item.Name);
dh.AddPare("@AG_Guid", SqlDbType.NVarChar, 50, item.AG_GUID);
dh.AddPare("@PurchaseDate", SqlDbType.DateTime, 0, item.PurchaseDate);
dh.AddPare("@RegDate", SqlDbType.DateTime, 0, item.RegisterDate);
dh.AddPare("@AssetsCost", SqlDbType.Decimal, 0, item.AssetsCost);
dh.AddPare("@Creator", SqlDbType.NVarChar, 50, item.Creator);
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, item.C_GUID);
try
{
dh.NonQuery();
return(true);
}
catch (System.Exception)
{
return(false);
}
}
public JsonResult Check(T_AssetsApprove model, string CurUser)//资产审核保存
{
T_AssetsApprove editApprove = db.T_AssetsApprove.Find(model.ID);
T_AssetsTransferApply editApply = db.T_AssetsTransferApply.Find(model.ApplyID);
T_Assets editAssets = db.T_Assets.Find(editApply.Code);
int i = 0;
if (editApprove != null)//修改审核记录
{
editApprove.State = model.State;
editApprove.Memo = model.Memo;
editApprove.ApproveDate = DateTime.Now;
db.Entry <T_AssetsApprove>(editApprove).State = System.Data.EntityState.Modified;
}
if (editApply != null)
{
if (model.State == 1)//同意
{
#region 转移流程
#region 第一步和第二步审核
if (editApply.TransferType == "转移") //转移
{
if (editApply.Step == 1) //第一步,当前责任人同意转出后
{
string approvename = db.T_AssetsConfig.FirstOrDefault(a => a.Step == 2).Name; //添加第二步审核人(资产管理员)
editApply.Step = 2;
editApply.State = 0; //审核中
editApply.CurrentApproveName = approvename;
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
T_AssetsApprove newApprove = new T_AssetsApprove();
newApprove.ApplyID = editApprove.ApplyID;
newApprove.ApproveName = approvename;
newApprove.Code = editApprove.Code;
newApprove.State = 0;
newApprove.Step = "2";
db.T_AssetsApprove.Add(newApprove);
}
else if (editApply.Step == 2) //第二步,资产管理员同意转移发生
{
string approvename = editApply.LastApproveName; //添加第三步审核人(转移后责任人)
editApply.Step = 3;
editApply.State = 0; //审核中
editApply.CurrentApproveName = approvename;
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
if (editApply.LastApproveName.Contains(","))
{
string[] approveArr = approvename.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (var approve in approveArr)
{
T_AssetsApprove newApprove = new T_AssetsApprove();
newApprove.ApplyID = editApprove.ApplyID;
newApprove.ApproveName = approve;
newApprove.Code = editApprove.Code;
newApprove.State = 0;
newApprove.Step = "3";
db.T_AssetsApprove.Add(newApprove);
}
}
else
{
T_AssetsApprove newApprove = new T_AssetsApprove();
newApprove.ApplyID = editApprove.ApplyID;
newApprove.ApproveName = approvename;
newApprove.Code = editApprove.Code;
newApprove.State = 0;
newApprove.Step = "3";
db.T_AssetsApprove.Add(newApprove);
}
}
#endregion
#region 第三步审核
else if (editApply.Step == 3) //第三步,接收责任人同意即确认接收到该资产,流程结束,
{
List <T_AssetsApprove> ReceivedList = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3" && a.State == 1).ToList(); //接收过的数据
List <T_AssetsApprove> ApproveList = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3" && a.State == 0).ToList(); //待接收的数据
List <T_AssetsApprove> ApproveALl = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3").ToList();
if (ApproveALl.Count > 1) //这条数据的接收人有多个
{
if (ApproveList.Count > 1) //还有多个人要审核
{
editApply.CurrentApproveName = editApply.CurrentApproveName.Replace(editApprove.ApproveName, "");
if (ReceivedList.Count == 0)//没有人接收过
{
//修改资产的使用人等信息
editAssets.Department = editApply.TransferDepartment;
editAssets.Owner = editAssets.Owner.Replace(editApply.PostUserName, editApprove.ApproveName);
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editAssets.Responsible.Replace(editApply.PostUserName, editApprove.ApproveName);
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord TransferRecord = new T_AssetsTransferRecord();//添加一条资产变更记录
TransferRecord.Code = editApply.Code;
TransferRecord.Department = editApply.Department;
TransferRecord.Memo = editApply.Memo;
TransferRecord.Name = editApply.Name;
TransferRecord.Owner = editApply.Owner;
TransferRecord.Place = editApply.Place;
TransferRecord.Responsible = editApply.Responsible;
TransferRecord.TransferDate = DateTime.Now;
TransferRecord.TransferDepartment = editApply.TransferDepartment;
TransferRecord.TransferOwner = editApply.Owner.Replace(editApply.PostUserName, editApprove.ApproveName);
TransferRecord.TransferPlace = editApply.TransferPlace;
TransferRecord.TransferResponsible = editApply.Responsible.Replace(editApply.PostUserName, editApprove.ApproveName);
TransferRecord.PostUserName = editApply.PostUserName;
TransferRecord.Receiver = editApprove.ApproveName;//第一个人接收时 则接收人是这个人
TransferRecord.ApplyID = editApply.ID;
TransferRecord.TransferType = editApply.TransferType;
db.T_AssetsTransferRecord.Add(TransferRecord);
}
else
{
//修改资产的使用人等信息
editAssets.Department = editApply.TransferDepartment;
editAssets.Owner = editAssets.Owner + "," + editApprove.ApproveName;
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editAssets.Responsible + "," + editApprove.ApproveName;
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord EditRecord = db.T_AssetsTransferRecord.FirstOrDefault(a => a.ApplyID == editApply.ID);
EditRecord.Receiver = EditRecord.Receiver + "," + editApprove.ApproveName;//第二个开始来接收的人开始则加上这个人的名字
EditRecord.TransferOwner = EditRecord.TransferOwner + "," + editApprove.ApproveName;
EditRecord.TransferResponsible = EditRecord.TransferResponsible + "," + editApprove.ApproveName;
db.Entry <T_AssetsTransferRecord>(EditRecord).State = System.Data.EntityState.Modified;
}
}
else//最后一个接收人审核
{
editApply.Step = 9;
editApply.State = 1;//已同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
//修改资产的使用人等信息
editAssets.Department = editApply.TransferDepartment;
editAssets.Owner = editAssets.Owner + "," + editApprove.ApproveName;
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editAssets.Responsible + "," + editApprove.ApproveName;
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord EditRecord = db.T_AssetsTransferRecord.FirstOrDefault(a => a.ApplyID == editApply.ID);
EditRecord.Receiver = EditRecord.Receiver + "," + editApprove.ApproveName;//最后来接收的人则加上这个人的名字
EditRecord.TransferOwner = EditRecord.TransferOwner + "," + editApprove.ApproveName;
EditRecord.TransferResponsible = EditRecord.TransferResponsible + "," + editApprove.ApproveName;
db.Entry <T_AssetsTransferRecord>(EditRecord).State = System.Data.EntityState.Modified;
}
}
else//这条数据只有一个人接收
{
editApply.Step = 9;
editApply.State = 1;//已同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
//修改资产的使用人等信息
editAssets.Department = editApply.TransferDepartment;
editAssets.Owner = editAssets.Owner.Replace(editApply.PostUserName, editApply.LastApproveName);
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editApply.TransferResponsible;
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord TransferRecord = new T_AssetsTransferRecord();//添加一条资产变更记录
TransferRecord.Code = editApply.Code;
TransferRecord.Department = editApply.Department;
TransferRecord.Memo = editApply.Memo;
TransferRecord.Name = editApply.Name;
TransferRecord.Owner = editApply.Owner;
TransferRecord.Place = editApply.Place;
TransferRecord.Responsible = editApply.Responsible;
TransferRecord.TransferDate = DateTime.Now;
TransferRecord.TransferDepartment = editApply.TransferDepartment;
TransferRecord.TransferOwner = editApply.TransferOwner;
TransferRecord.TransferPlace = editApply.TransferPlace;
TransferRecord.TransferResponsible = editApply.TransferResponsible;
TransferRecord.PostUserName = editApply.PostUserName;
TransferRecord.Receiver = editApply.LastApproveName;
TransferRecord.ApplyID = editApply.ID;
TransferRecord.TransferType = editApply.TransferType;
db.T_AssetsTransferRecord.Add(TransferRecord);
}
IQueryable <T_AssetsTransferApply> TransferApplyList = db.T_AssetsTransferApply.Where(a => (a.State == -1 || a.State == 0) && a.Code == editApply.Code && a.ID != editApply.ID);
if (TransferApplyList.Count() > 0)
{
foreach (T_AssetsTransferApply item in TransferApplyList)//一个资产同时发生多条变更记录的时候,同意了其中一个的转移，就将其他未审核完成的记录的接收人和接收责任人等修改
{
item.TransferOwner = item.TransferOwner.Replace(editApply.PostUserName, editApply.LastApproveName);
item.TransferResponsible = item.TransferResponsible.Replace(editApply.PostUserName, editApply.LastApproveName);
item.Owner = item.Owner.Replace(editApply.PostUserName, editApply.LastApproveName);
item.Responsible = item.Responsible.Replace(editApply.PostUserName, editApply.LastApproveName);
}
}
}
#endregion
}
#endregion
#region 交
else if (editApply.TransferType == "上交")
{
if (editApply.Step == 1)//第一步,资产管理员确认资产已上交,流程结束,添加一条资产变更记录
{
editApply.Step = 9;
editApply.State = 1;//已同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
//修改资产的使用人等信息
editAssets.Department = editApply.TransferDepartment;;
editAssets.Owner = editApply.TransferOwner;
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editApply.TransferResponsible;//资产管理员负责待分配的资产
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord TransferRecord = new T_AssetsTransferRecord();//添加一条资产变更记录
TransferRecord.Code = editApply.Code;
TransferRecord.Department = editApply.Department;
TransferRecord.Memo = editApply.Memo;
TransferRecord.Name = editApply.Name;
TransferRecord.Owner = editApply.Owner;
TransferRecord.Place = editApply.Place;
TransferRecord.Responsible = editApply.Responsible;
TransferRecord.TransferDate = DateTime.Now;
TransferRecord.TransferDepartment = editApply.TransferDepartment;
TransferRecord.TransferOwner = editApply.TransferOwner;
TransferRecord.TransferPlace = editApply.TransferPlace;
TransferRecord.TransferResponsible = editApply.TransferResponsible;
TransferRecord.PostUserName = editApply.PostUserName;
TransferRecord.Receiver = "";
TransferRecord.ApplyID = editApply.ID;
TransferRecord.TransferType = editApply.TransferType;
db.T_AssetsTransferRecord.Add(TransferRecord);
IQueryable <T_AssetsTransferApply> TransferApplyList = db.T_AssetsTransferApply.Where(a => (a.State == -1 || a.State == 0) && a.Code == editApply.Code);
if (TransferApplyList.Count() > 0)
{
foreach (T_AssetsTransferApply item in TransferApplyList)
{
int Oindex = item.TransferOwner.IndexOf(editApply.PostUserName);
if (Oindex == 0)//如果名字在第一个,则删去名字及名字后面的逗号,否则删去名字及名字前面的一个逗号
{
item.TransferOwner = item.TransferOwner.Replace(editApply.PostUserName + ",", "");
}
else
{
item.TransferOwner = item.TransferOwner.Replace("," + editApply.PostUserName, "");
}
int Rindex = item.TransferResponsible.IndexOf(editApply.PostUserName);
if (Rindex == 0)
{
item.TransferResponsible = item.TransferResponsible.Replace(editApply.PostUserName + ",", "");
}
else
{
item.TransferResponsible = item.TransferResponsible.Replace("," + editApply.PostUserName, "");
}
}
}
}
}
#endregion
#region 领用
else if (editApply.TransferType == "领用")
{
if (editApply.Step == 1)//第一步,资产管理员确认资产已上交,流程结束,添加一条资产变更记录
{
editApply.Step = 9;
editApply.State = 1;//已同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
editAssets.Department = editApply.TransferDepartment;;
editAssets.Owner = editApply.TransferOwner;
editAssets.Place = editApply.TransferPlace;
editAssets.Responsible = editApply.TransferResponsible;//资产管理员负责待分配的资产
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord TransferRecord = new T_AssetsTransferRecord();//添加一条资产变更记录
TransferRecord.Code = editApply.Code;
TransferRecord.Department = editApply.Department;
TransferRecord.Memo = editApply.Memo;
TransferRecord.Name = editApply.Name;
TransferRecord.Owner = editApply.Owner;
TransferRecord.Place = editApply.Place;
TransferRecord.Responsible = editApply.Responsible;
TransferRecord.TransferDate = DateTime.Now;
TransferRecord.TransferDepartment = editApply.TransferDepartment;
TransferRecord.TransferOwner = editApply.TransferOwner;
TransferRecord.TransferPlace = editApply.TransferPlace;
TransferRecord.TransferResponsible = editApply.TransferResponsible;
TransferRecord.PostUserName = editApply.PostUserName;
TransferRecord.Receiver = TransferRecord.TransferOwner;
TransferRecord.ApplyID = editApply.ID;
TransferRecord.TransferType = editApply.TransferType;
db.T_AssetsTransferRecord.Add(TransferRecord);
}
}
#endregion
#region 报废
else if (editApply.TransferType == "报废")
{
if (editApply.Step == 1)//第一步,资产管理员确认资产报废,流程结束,添加一条资产变更记录
{
editApply.Step = 9;
editApply.State = 1;//已同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
editAssets.Department = "无";
editAssets.Owner = "报废";
editAssets.Place = "无";
editAssets.Responsible = "无";
editAssets.isScrap = "1";
db.Entry <T_Assets>(editAssets).State = System.Data.EntityState.Modified;
T_AssetsTransferRecord TransferRecord = new T_AssetsTransferRecord();//添加一条资产变更记录
TransferRecord.Code = editApply.Code;
TransferRecord.Department = editApply.Department;
TransferRecord.Memo = editApply.Memo;
TransferRecord.Name = editApply.Name;
TransferRecord.Owner = editApply.Owner;
TransferRecord.Place = editApply.Place;
TransferRecord.Responsible = editApply.Responsible;
TransferRecord.TransferDate = DateTime.Now;
TransferRecord.TransferDepartment = editApply.TransferDepartment;
TransferRecord.TransferOwner = editApply.TransferOwner;
TransferRecord.TransferPlace = editApply.TransferPlace;
TransferRecord.TransferResponsible = editApply.TransferResponsible;
TransferRecord.PostUserName = editApply.PostUserName;
TransferRecord.Receiver = "";
TransferRecord.ApplyID = editApply.ID;
TransferRecord.TransferType = editApply.TransferType;
db.T_AssetsTransferRecord.Add(TransferRecord);
}
}
#endregion
}
else//不同意
{
#region 转移
if (editApply.TransferType == "转移" && editApply.Step == 3) //转移的第三步有可能有多个人接收就会有多个人审核
{
List <T_AssetsApprove> ReceivedList = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3" && a.State == 1).ToList(); //接收过的数据
List <T_AssetsApprove> ApproveList = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3" && a.State == 0).ToList(); //待接收的数据
List <T_AssetsApprove> ApproveALl = db.T_AssetsApprove.Where(a => a.ApplyID == model.ApplyID && a.Step == "3").ToList();
if (ApproveALl.Count > 1) //这条数据的接收人有多个
{
if (ApproveList.Count > 1) //还有多个人要审核
{
editApply.CurrentApproveName = editApply.CurrentApproveName.Replace(editApprove.ApproveName, "");
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
}
else//最后一个接收人审核
{
editApply.Step = 9;
if (ReceivedList.Count > 0)
{
editApply.State = 1;//有人接收表示已同意
}
else
{
editApply.State = 2;//没有任何一个人接收则为不同意
}
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
}
}
else//一人接收
{
editApply.Step = 9;
editApply.State = 2;//不同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
}
}
#endregion
#region 其他
else
{
editApply.Step = 9;
editApply.State = 2;//不同意
editApply.CurrentApproveName = "流程结束";
db.Entry <T_AssetsTransferApply>(editApply).State = System.Data.EntityState.Modified;
}
#endregion
}
}
i = db.SaveChanges();
try
{
List <T_ModularNotaudited> ModularNotaudited = db.T_ModularNotaudited.Where(a => a.ModularName == "资产变更").ToList();
if (ModularNotaudited.Count > 0)
{
foreach (var item in ModularNotaudited)
{
db.T_ModularNotaudited.Remove(item);
}
db.SaveChanges();
}
string RetreatAppRoveSql = " select ApproveName as PendingAuditName,COUNT(*) as NotauditedNumber from T_AssetsApprove where ApplyID in ( select ID from T_AssetsTransferApply where isDelete=0 ) and State=0 and ApproveDate is null GROUP BY ApproveName ";
List <Modular> RetreatAppRoveQuery = db.Database.SqlQuery <Modular>(RetreatAppRoveSql).ToList();
string Nickname = CurUser;
for (int e = 0; e < RetreatAppRoveQuery.Count; e++)
{
string PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;
T_ModularNotaudited NotauditedModel = db.T_ModularNotaudited.SingleOrDefault(a => a.ModularName == "资产变更" && a.PendingAuditName == PendingAuditName);
if (NotauditedModel != null)
{
NotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
db.Entry <T_ModularNotaudited>(NotauditedModel).State = System.Data.EntityState.Modified;
}
else
{
T_ModularNotaudited ModularNotauditedModel = new T_ModularNotaudited();
ModularNotauditedModel.ModularName = "资产变更";
ModularNotauditedModel.RejectNumber = 0;
ModularNotauditedModel.NotauditedNumber = RetreatAppRoveQuery[e].NotauditedNumber;
ModularNotauditedModel.PendingAuditName = RetreatAppRoveQuery[e].PendingAuditName;
ModularNotauditedModel.ToupdateDate = DateTime.Now; ModularNotauditedModel.ToupdateName = Nickname;
db.T_ModularNotaudited.Add(ModularNotauditedModel);
}
db.SaveChanges();
}
//增加驳回数据
string RejectNumberSql = " select PostUserName as PendingAuditName,COUNT(*) as NotauditedNumber from T_AssetsTransferApply where State='2' GROUP BY PostUserName ";
List <Modular> RejectNumberQuery = db.Database.SqlQuery <Modular>(RejectNumberSql).ToList();
for (int e = 0; e < RejectNumberQuery.Count; e++)
{
string PendingAuditName = RejectNumberQuery[e].PendingAuditName;
T_ModularNotaudited NotauditedModel = db.T_ModularNotaudited.SingleOrDefault(a => a.ModularName == "资产变更" && a.PendingAuditName == PendingAuditName);
if (NotauditedModel != null)
{
NotauditedModel.RejectNumber = RejectNumberQuery[e].NotauditedNumber;
db.Entry <T_ModularNotaudited>(NotauditedModel).State = System.Data.EntityState.Modified;
}
else
{
T_ModularNotaudited ModularNotauditedModel = new T_ModularNotaudited();
ModularNotauditedModel.ModularName = "资产变更";
ModularNotauditedModel.NotauditedNumber = 0;
ModularNotauditedModel.RejectNumber = RejectNumberQuery[e].NotauditedNumber;
ModularNotauditedModel.PendingAuditName = RejectNumberQuery[e].PendingAuditName;
ModularNotauditedModel.ToupdateDate = DateTime.Now;
ModularNotauditedModel.ToupdateName = Nickname;
db.T_ModularNotaudited.Add(ModularNotauditedModel);
}
db.SaveChanges();
}
}
catch (DbUpdateException e)
{
}
return(Json(i));
}
