//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_AssetsTransferApply mod = db.T_AssetsTransferApply.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.Code = mod.Code;
list.Name = mod.Name;
list.Owner = mod.Owner;
list.Department = mod.Department;
list.Place = mod.Place;
list.Responsible = mod.Responsible;
list.TransferOwner = mod.TransferOwner;
list.TransferDepartment = mod.TransferDepartment;
list.TransferPlace = mod.TransferPlace;
list.UserName = mod.UserName;
list.TransferResponsible = mod.TransferResponsible;
list.Memo = mod.Memo;
list.TransferType = mod.TransferType;
list.PostDate = mod.PostDate;
list.ReplaceCode = mod.ReplaceCode;
list.CurrentApproveName = mod.CurrentApproveName;
list.State = mod.State;
list.Step = mod.Step;
list.PostUserName = mod.PostUserName;
list.LastApproveName = mod.LastApproveName;
list.IsDelete = mod.IsDelete;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_AssetsApprove> mod_Approve = db.T_AssetsApprove.Where(a => a.ApplyID == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_AssetsApprove Approve = db.T_AssetsApprove.FirstOrDefault(s => !s.ApproveDate.HasValue && s.ApplyID == ID);
if (Approve == null)
{
Approve = db.T_AssetsApprove.FirstOrDefault(s => s.ApproveDate.HasValue && s.ApplyID == ID);
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_AssetsApprove MyApprove = db.T_AssetsApprove.FirstOrDefault(a => a.ApplyID == ID && a.ApproveName == name && a.ApproveDate == null);
if (MyApprove != null)
{
myCheck = 1;
}
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":" + myCheck + ",\"approveId\":" + Approve.ID + ",\"ID\":" + ID + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情页面数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_LossReport mod = db.T_LossReport.Find(ID);
mainItem list = new mainItem();
list.Code = mod.Code;
list.Department = GetDaparementString(mod.Department);
list.PostTime = mod.PostTime;
list.ID = mod.ID;
list.PostUser = mod.PostUser;
list.Shop = mod.Shop;
list.Total = mod.Total;
list.Status = mod.Status;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//详情
IQueryable <T_LossReportDetail> mod_Detail = db.T_LossReportDetail.Where(a => a.Oid == ID);
string modDetail = JsonConvert.SerializeObject(mod_Detail, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_LossReportApprove> mod_Approve = db.T_LossReportApprove.Where(a => a.Oid == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
//查看是不是财务主管
T_LossReportApproveConfig financeMod = db.T_LossReportApproveConfig.SingleOrDefault(a => a.Type == "财务主管"); //审核财务主管一步
string financeAdmin = financeMod.Name;
T_LossReport lossreport = db.T_LossReport.Find(ID);
//用于判断是不是 财务主管 且 不是部门主管身份进来审核
int nextMan = 0;
if (name == financeAdmin && lossreport.Step > 0)
{
nextMan = 1;
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_LossReportApprove MyApprove = db.T_LossReportApprove.FirstOrDefault(a => a.Oid == ID && a.ApproveName == name && a.ApproveTime == null);
if (MyApprove != null)
{
myCheck = 1;
}
result += "{\"Loss\":[" + modJson + "],\"Detail\":" + modDetail + ",\"Approve\":" + approve + ",\"nextMan\":" + nextMan + ",\"myCheck\":" + myCheck + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_Freeze mod = db.T_Freeze.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.shopName = mod.shopName;
list.alipay = mod.alipay;
list.freezeMoney = mod.freezeMoney;
list.freezeReason = mod.freezeReason;
list.remark = mod.remark;
list.userName = mod.userName;
list.datetime = mod.datetime;
list.state = mod.state;
list.usedMoney = mod.usedMoney;
list.surplusMoney = mod.surplusMoney;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_FreezeApprove> mod_Approve = db.T_FreezeApprove.Where(a => a.freezeID == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_FreezeApprove Approve = db.T_FreezeApprove.FirstOrDefault(s => !s.ApproveTime.HasValue && s.freezeID == ID);
if (Approve == null)
{
Approve = db.T_FreezeApprove.FirstOrDefault(s => s.ApproveTime.HasValue && s.freezeID == ID);
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_FreezeApprove MyApprove = db.T_FreezeApprove.FirstOrDefault(a => a.freezeID == ID && a.ApproveName == name && a.ApproveTime == null);
if (MyApprove != null)
{
myCheck = 1;
}
//财务主管？
int Cashier = 0;
int curStep = int.Parse(mod.Step.ToString());
//取最后一步
int lastStep = db.T_FreezeConfig.OrderByDescending(s => s.Step).First().Step;
if (lastStep == curStep)
{
Cashier = 1;
}
//付款银行
List <SelectListItem> listPayBank = Lib.Comm.PayBank;
string ThePaymentBank = JsonConvert.SerializeObject(listPayBank, Lib.Comm.setTimeFormat());
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":" + myCheck + ",\"Cashier\":" + Cashier + ",\"approveId\":" + Approve.ID + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_FundAllot mod = db.T_FundAllot.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.PostUser = mod.PostUser;
list.Department = mod.Department;
list.TheReceivingBank = mod.TheReceivingBank;
list.CompanyIn = mod.CompanyIn;
list.AccountNumber = mod.AccountNumber;
list.CompanyOut = mod.CompanyOut;
list.ThePaymentBank = mod.ThePaymentBank;
list.PaymentNumber = mod.PaymentNumber;
list.Status = mod.Status;
list.UseOfProceeds = mod.UseOfProceeds;
list.PostTime = mod.PostTime;
list.Step = mod.Step;
list.theMoney = Convert.ToDouble(mod.theMoney);
list.PostTime = mod.PostTime;
list.Status = mod.Status;
list.FundAllotCode = mod.FundAllotCode;
list.IsPzStatus = mod.IsPzStatus;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_FundApprove> mod_Approve = db.T_FundApprove.Where(a => a.ItemId == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_FundApprove Approve = db.T_FundApprove.FirstOrDefault(s => !s.ApproveTime.HasValue && s.ItemId == ID);
if (Approve == null)
{
Approve = db.T_FundApprove.FirstOrDefault(s => s.ApproveTime.HasValue && s.ItemId == ID);
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_FundApprove MyApprove = db.T_FundApprove.FirstOrDefault(a => a.ItemId == ID && a.ApproveName == name && a.ApproveTime == null);
if (MyApprove != null)
{
myCheck = 1;
}
//财务主管？
int Cashier = 0;
int curStep = int.Parse(mod.Step.ToString());
//支付帐号
if (name == "殷治云")
{
Cashier = 1;
}
//付款账号
string PayNumber = JsonConvert.SerializeObject(Com.PayNumber(), Lib.Comm.setTimeFormat());
//资金调拨调出单位
string CompanyOut = JsonConvert.SerializeObject(Com.CompanyOut(), Lib.Comm.setTimeFormat());
//付款银行
List <SelectListItem> listPayBank = Lib.Comm.PayBank;
string ThePaymentBank = JsonConvert.SerializeObject(listPayBank, Lib.Comm.setTimeFormat());
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":" + myCheck + ",\"Cashier\":" + Cashier + ",\"CompanyOut\":" + CompanyOut + ",\"PayNumber\":" + PayNumber + ",\"ThePaymentBank\":" + ThePaymentBank + ",\"approveId\":" + Approve.ID + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情页面数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_Reissue mod = db.T_Reissue.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.OrderCode = mod.OrderCode;
list.NewOrderCode = mod.NewOrderCode;
list.VipName = mod.VipName;
list.StoreCode = mod.StoreCode;
list.StoreName = mod.StoreName;
list.WarhouseName = mod.WarhouseName;
list.ExpressName = mod.ExpressName;
list.OrderType = mod.OrderType;
list.SingleTime = mod.SingleTime;
list.ReceivingName = mod.ReceivingName;
list.PostalCode = mod.PostalCode;
list.Phone = mod.Phone;
list.TelPhone = mod.TelPhone;
list.VipCode = mod.VipCode;
list.Address = mod.Address;
list.SalesRemark = mod.SalesRemark;
list.BuyRemark = mod.BuyRemark;
list.Status = int.Parse(mod.Status.ToString());
list.BusinessName = mod.BusinessName;
list.AddressMessage = mod.AddressMessage;
list.CreatDate = DateTime.Parse(mod.CreatDate.ToString());
list.PostUser = mod.PostUser;
list.SystemRemark = mod.SystemRemark;
list.DraftName = mod.DraftName;
list.Cost = decimal.Parse(mod.Cost.ToString());
list.ReissueReson = mod.ReissueReson;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//详情
IQueryable <T_ReissueDetail> mod_Detail = db.T_ReissueDetail.Where(a => a.ReissueId == ID);
string modDetail = JsonConvert.SerializeObject(mod_Detail, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_ReissueApprove> mod_Approve = db.T_ReissueApprove.Where(a => a.Pid == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_Reissue lossreport = db.T_Reissue.Find(ID);
//用于判断是不是 财务主管
int nextMan = 0;
int Step = db.T_ReissueApprove.ToList().Count;
if (mod.Step != Step - 1)
{
nextMan = 1;
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
// T_ExchangeCenterApprove MyApprove = db.T_ExchangeCenterApprove.FirstOrDefault(a => a.Pid == ID && (a.ApproveName == UserName || a.ApproveUser == UserName) && a.ApproveTime == null);
string sql = "select * from T_ReissueApprove where Pid='" + ID + "' and ApproveTime is null and (ApproveUser='******' or ApproveName='" + UserName + "' or ApproveName in (select GroupName from T_ReissueGroup where GroupUser in ('" + UserName + "')) )";
List <T_ReissueApprove> MyApprove = db.Database.SqlQuery <T_ReissueApprove>(sql).ToList();
if (MyApprove.Count > 0)
{
myCheck = 1;
}
//审核人
List <SelectListItem> getCheckMan = new List <SelectListItem>();
var approveusers = db.T_ExpenseApproveConfig.FirstOrDefault(a => a.Step == mod.Step + 1);
if (approveusers != null)
{
//如果是动态获取当前部门主管
if (approveusers.ApproveUser.Equals("部门主管"))
{
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "请选择", Value = "9999"
});
getCheckMan = items;
}
//如果还有其他的审核组或者动态绑定的数据 再增加else
//如果是固定的某些人
else
{
string[] array = approveusers.ApproveUser.Split(',');
List <SelectListItem> items = new List <SelectListItem>();
foreach (var item in array)
{
T_User user = db.T_User.FirstOrDefault(a => a.Nickname.Equals(item));
if (user != null)
{
items.Add(new SelectListItem {
Text = user.Nickname, Value = user.ID.ToString()
});
}
}
getCheckMan = items;
}
}
else
{
getCheckMan = null;
}
string CheckManJson = JsonConvert.SerializeObject(getCheckMan, Lib.Comm.setTimeFormat());
//未审核记录ID
T_ReissueApprove Approve = db.T_ReissueApprove.FirstOrDefault(s => !s.ApproveTime.HasValue && s.Pid == ID);
if (Approve == null)
{
Approve = db.T_ReissueApprove.FirstOrDefault(s => s.ApproveTime.HasValue && s.Pid == ID);
}
result += "{\"Main\":[" + modJson + "],\"Detail\":" + modDetail + ",\"Approve\":" + approve + ",\"Step\":" + nextMan + ",\"approveId\":" + Approve.ID + ",\"myCheck\":" + myCheck + ",\"CheckList\":" + CheckManJson + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_CashBack mod = db.T_CashBack.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.PostUser = mod.PostUser;
list.OrderNum = mod.OrderNum;
list.VipName = mod.VipName;
list.ShopName = mod.ShopName;
list.WangWang = mod.WangWang;
list.Reason = mod.Reason;
list.BackMoney = mod.BackMoney;
list.ApproveName = mod.ApproveName;
list.OrderMoney = mod.OrderMoney;
list.AlipayName = mod.AlipayName;
list.AlipayAccount = mod.AlipayAccount;
list.Note = mod.Note;
list.PostTime = mod.PostTime;
list.Status = mod.Status;
list.Repeat = mod.Repeat;
list.Method = mod.Method;
list.BackFrom = mod.BackFrom;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_CashBackApprove> mod_Approve = db.T_CashBackApprove.Where(a => a.Oid == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_CashBackApprove MyApprove = db.T_CashBackApprove.FirstOrDefault(a => a.Oid == ID && a.ApproveName == UserName && a.ApproveTime == null);
if (MyApprove != null)
{
myCheck = 1;
}
//财务出纳？
int Cashier = 0;
int curStep = int.Parse(mod.Step.ToString());
//支付帐号
IQueryable <T_CashBackFrom> BackFrom = db.T_CashBackFrom.AsQueryable();
T_CashbackMethod MOD_method = db.T_CashbackMethod.FirstOrDefault(a => a.Method == mod.Method && a.Step == curStep);
if (MOD_method.Cashier == 1)
{
using (TransactionScope sc = new TransactionScope())
{
if (UserName == MOD_method.Name)
{
//string order = mod.OrderNum;
//T_OrderList MOD_Order = db.T_OrderList.FirstOrDefault(a => a.platform_code == order);
//int cash = int.Parse(MOD_Order.Status_CashBack.ToString());
//int retreat = int.Parse(MOD_Order.Status_Retreat.ToString());
//string repeatString = "返现状态：";
//switch (cash)
//{
// case 0:
// repeatString += "未申请";
// break;
// case 1:
// repeatString += "申请中";
// break;
// case 2:
// repeatString += "已返现";
// break;
//}
//repeatString += ",退货退款：";
//switch (retreat)
//{
// case 0:
// repeatString += "未退款";
// break;
// case 1:
// repeatString += "未退款";
// break;
// case 2:
// repeatString += "已退款";
// break;
//}
Cashier = 1; //是财务出纳
//mod.Repeat = repeatString;
//db.Entry<T_CashBack>(mod).State = System.Data.EntityState.Modified;
//db.SaveChanges();
}
sc.Complete();
}
//是财务出纳 刷新 是否返现/退款 字段
}
string sBackFrom = JsonConvert.SerializeObject(BackFrom, Lib.Comm.setTimeFormat());
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":" + myCheck + ",\"Cashier\":" + Cashier + ",\"BackFrom\":" + sBackFrom + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情页面数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_Expense mod = db.T_Expense.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.Department = mod.Department;
list.Reun_Reason = mod.Reun_Reason;
list.ExpenseNextApprove = mod.ExpenseNextApprove;
list.Reun_Cost = mod.Reun_Cost;
list.PostUser = mod.PostUser;
list.CrateDate = mod.CrateDate;
list.Reun_Code = mod.Reun_Code;
list.AccountType = mod.AccountType;
list.Reun_Bank = mod.Reun_Bank;
list.Shop = mod.Shop;
list.Reun_Name = mod.Reun_Name;
list.Car_Number = mod.Car_Number;
list.Status = mod.Status;
list.Step = mod.Step;
list.IsExpenseMatch = mod.IsExpenseMatch;
list.IsExpenseEnclosure = mod.IsExpenseEnclosure;
list.Pz_BXStatus = mod.Pz_BXStatus;
list.MatchBorrowNumber = mod.MatchBorrowNumber;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//详情
IQueryable <T_ExpenseProduct> mod_Detail = db.T_ExpenseProduct.Where(a => a.ReunId == ID);
string modDetail = JsonConvert.SerializeObject(mod_Detail, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_ExpenseApprove> mod_Approve = db.T_ExpenseApprove.Where(a => a.Reunbursement_id == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_Expense lossreport = db.T_Expense.Find(ID);
//用于判断是不是 财务主管
int nextMan = 0;
int Step = db.T_ExpenseApproveConfig.ToList().Count;
if (mod.Step != Step - 1)
{
nextMan = 1;
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_ExpenseApprove MyApprove = db.T_ExpenseApprove.FirstOrDefault(a => a.Reunbursement_id == ID && a.ApproveName == UserName && a.ApproveDate == null);
if (MyApprove != null)
{
myCheck = 1;
}
//审核人
List <SelectListItem> getCheckMan = new List <SelectListItem>();
var approveusers = db.T_ExpenseApproveConfig.FirstOrDefault(a => a.Step == 4);
if (approveusers != null)
{
//如果是动态获取当前部门主管
string[] array = approveusers.ApproveUser.Split(',');
List <SelectListItem> items = new List <SelectListItem>();
foreach (var item in array)
{
T_User user = db.T_User.FirstOrDefault(a => a.Nickname.Equals(item) || a.Name.Equals(item));
if (user != null)
{
items.Add(new SelectListItem {
Text = user.Nickname, Value = user.ID.ToString()
});
}
}
getCheckMan = items;
}
else
{
getCheckMan = null;
}
string CheckManJson = JsonConvert.SerializeObject(getCheckMan);
string ExpStatus = JsonConvert.SerializeObject(Com.ExpenseStatus());
//未审核记录ID
T_ExpenseApprove Approve = db.T_ExpenseApprove.FirstOrDefault(s => !s.ApproveDate.HasValue && s.Reunbursement_id == ID);
if (Approve == null)
{
Approve = db.T_ExpenseApprove.FirstOrDefault(s => s.ApproveDate.HasValue && s.Reunbursement_id == ID);
}
result += "{\"Main\":[" + modJson + "],\"Detail\":" + modDetail + ",\"Approve\":" + approve + ",\"Step\":" + mod.Step + ",\"approveId\":" + Approve.ID + ",\"myCheck\":" + myCheck + ",\"ExpStatus\":" + ExpStatus + ",\"CheckList\":" + CheckManJson + ",\"Company\":" + JsonConvert.SerializeObject(Com.ExpenseCompany()) + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_Generalize mod = db.T_Generalize.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.Guid = mod.Guid;
list.CreateDate = mod.CreateDate;
list.PlatformCode = mod.PlatformCode;
list.PostUser = mod.PostUser;
list.StoreName = mod.StoreName;
list.OrderNumber = mod.OrderNumber;
list.ProductName = mod.ProductName;
list.Cost = mod.Cost;
list.CommissionCost = mod.CommissionCost;
list.DKUserMessage = mod.DKUserMessage;
list.AliNumber = mod.AliNumber;
list.BankNumber = mod.BankNumber;
list.TenPay = mod.TenPay;
list.IsCheck = mod.IsCheck;
list.OrderType = mod.OrderType;
list.PayCommissionNumber = mod.PayCommissionNumber;
list.Memo = mod.Memo;
list.BorrowCode = mod.BorrowCode;
list.ResponsibleName = mod.ResponsibleName;
list.IsSend = mod.IsSend;
list.IsCancel = mod.IsCancel;
list.PlatformFlag = mod.PlatformFlag;
list.WarhouseName = mod.WarhouseName;
list.UploadName = mod.UploadName;
list.Status = mod.Status;
list.IsDelete = mod.IsDelete;
list.IsDispose = mod.IsDispose;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_GeneralizeApprove> mod_Approve = db.T_GeneralizeApprove.Where(a => a.Pid == mod.Guid);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_GeneralizeApprove Approve = db.T_GeneralizeApprove.FirstOrDefault(s => !s.ApproveTime.HasValue && s.Pid == mod.Guid);
if (Approve == null)
{
Approve = db.T_GeneralizeApprove.FirstOrDefault(s => s.ApproveTime.HasValue && s.Pid == mod.Guid);
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
string MyApprove = db.T_GeneralizeApproveConfig.OrderByDescending(s => s.ID).First().ApproveUser == UserName ? "true" : "false";
// T_FreezeApprove MyApprove = db.T_FreezeApprove.FirstOrDefault(a => a.freezeID == ID && a.ApproveName == name && a.ApproveTime == null);
if (MyApprove == "true" && mod.IsDispose != 1)
{
myCheck = 1;
}
//付款银行
List <SelectListItem> listPayBank = Lib.Comm.PayBank;
string ThePaymentBank = JsonConvert.SerializeObject(listPayBank, Lib.Comm.setTimeFormat());
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":\"" + myCheck + "\",\"Guid\":\"" + Approve.Pid + "\"}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
//详情数据加载
public JsonResult GetDetail(int ID, string UserName)
{
T_User MOD_User = db.T_User.FirstOrDefault(a => a.Nickname == UserName);
//真名
string name = MOD_User.Name;
string result = "";
//主表
T_Borrow mod = db.T_Borrow.Find(ID);
mainItem list = new mainItem();
list.ID = mod.ID;
list.BorrowName = mod.BorrowName;
list.BorrowerFrom = mod.BorrowerFrom;
list.BorrowerDep = mod.BorrowerDep;
list.BorrowReason = mod.BorrowReason;
list.BorrowMoney = mod.BorrowMoney;
list.BorrowDate = mod.BorrowDate;
list.BorrowState = mod.BorrowState;
list.BorrowSettementState = mod.BorrowSettementState;
list.BorrowCode = mod.BorrowCode;
list.BorrowAccountID = mod.BorrowAccountID;
list.BorrowBank = mod.BorrowBank;
list.BorrowNeedDate = mod.BorrowNeedDate;
list.BorrowAccountName = mod.BorrowAccountName;
list.BorrowNextApprove = mod.BorrowNextApprove;
list.BorrowStep = mod.BorrowStep;
list.BorrowAccountName = mod.BorrowAccountName;
list.IsVoucher = mod.IsVoucher;
string modJson = JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat());
//审核记录
IQueryable <T_BorrowApprove> mod_Approve = db.T_BorrowApprove.Where(a => a.Pid == ID);
string approve = JsonConvert.SerializeObject(mod_Approve, Lib.Comm.setTimeFormat());
T_BorrowApprove Approve = db.T_BorrowApprove.FirstOrDefault(s => !s.ApproveTime.HasValue && s.Pid == ID);
if (Approve == null)
{
Approve = db.T_BorrowApprove.FirstOrDefault(s => s.ApproveTime.HasValue && s.Pid == ID);
}
//用于判断是不是我审核 0不是 1是
int myCheck = 0;
T_BorrowApprove MyApprove = db.T_BorrowApprove.FirstOrDefault(a => a.Pid == ID && a.ApproveName == UserName && a.ApproveTime == null);
if (MyApprove != null)
{
myCheck = 1;
}
//财务主管？
//int Cashier = 0;
int curStep = int.Parse(mod.BorrowStep.ToString());
//取最后一步
int Step = db.T_BorrowApproveConfig.ToList().Count;
//如果不是最后1 步，就显示选择下拉框
List <SelectListItem> getCheckMan = new List <SelectListItem>();
T_BorrowApproveConfig approveusers;
mod.BorrowStep = mod.BorrowStep + 1;
if (UserName == "子轩" && mod.BorrowStep == 3)
{
mod.BorrowStep = mod.BorrowStep + 1;
approveusers = db.T_BorrowApproveConfig.FirstOrDefault(a => a.Step == mod.BorrowStep);
}
else
{
approveusers = db.T_BorrowApproveConfig.FirstOrDefault(a => a.Step == mod.BorrowStep);
}
//var approveusers = db.T_BorrowApproveConfig.FirstOrDefault(a => a.Step == mod.BorrowStep + 1);
if (approveusers != null)
{
//如果是动态获取当前部门主管
if (approveusers.ApproveUser.Equals("部门主管"))
{
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "请选择", Value = "9999"
});
getCheckMan = items;
}
//如果还有其他的审核组或者动态绑定的数据 再增加else
//如果是固定的某些人
else
{
string[] array = approveusers.ApproveUser.Split(',');
List <SelectListItem> items = new List <SelectListItem>();
foreach (var item in array)
{
T_User user = db.T_User.FirstOrDefault(a => a.Nickname.Equals(item));
if (user != null)
{
items.Add(new SelectListItem {
Text = user.Nickname, Value = user.ID.ToString()
});
}
}
getCheckMan = items;
}
}
else
{
getCheckMan = null;
}
//支付
List <SelectListItem> listBorrowForm = Lib.Comm.BorrowForm;
string theBorrowForm = JsonConvert.SerializeObject(listBorrowForm, Lib.Comm.setTimeFormat());
//审核人
string CheckManJson = JsonConvert.SerializeObject(getCheckMan, Lib.Comm.setTimeFormat());
//公司
List <SelectListItem> listCompany = Com.ExpenseCompany();
string theCompany = JsonConvert.SerializeObject(listCompany, Lib.Comm.setTimeFormat());
result += "{\"Main\":[" + modJson + "],\"Approve\":" + approve + ",\"myCheck\":" + myCheck + ",\"Step\":" + Step + ",\"approveId\":" + Approve.ID + ",\"CheckList\":" + CheckManJson + ",\"theBorrowForm\":" + theBorrowForm + ",\"listCompany\":" + theCompany + "}";
return(Json(result, JsonRequestBehavior.AllowGet));
}
