/// <summary> /// 搁置单据 /// </summary> /// <param name="BillNo"></param> /// <param name="Type"></param> /// <returns></returns> public string ShelveBill(string BillNo, string Type, string Remark) { var employee = Marisfrolg.Public.Common.GetEmployeeInfo(); string status = String.Empty; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("ApprovalStatus", "5"); dic.Add("ApprovalPost", Remark); dic.Add("ShelveNo", employee.EmployeeNo); switch (Type.ToUpper()) { case "FEEBILL": status = new FeeBill().PublicEditMethod(BillNo, dic); break; case "NOTICEBILL": status = new NoticeBill().PublicEditMethod(BillNo, dic); break; case "BORROWBILL": status = new BorrowBill().PublicEditMethod(BillNo, dic); break; case "REFUNDBILL": status = new RefundBill().PublicEditMethod(BillNo, dic); break; default: break; } return(status); }
public string ExistBillNo(string BillNo, string No) { string Result = ""; BillNo = BillNo.Trim().ToUpper(); var FeeModel = new FeeBill().GetBillModel(BillNo, No); if (FeeModel != null) { Result = "FeeBill"; return(Result); } var NoticeModel = new NoticeBill().GetBillModel(BillNo, No); if (NoticeModel != null) { Result = "NoticeBill"; return(Result); } var BorrowModel = new BorrowBill().GetBillModel(BillNo, No); if (BorrowModel != null) { Result = "BorrowBill"; return(Result); } var RefundModel = new RefundBill().GetBillModel(BillNo, No); if (RefundModel != null) { Result = "RefundBill"; return(Result); } return(Result); }
public string AddPrintedCount(string BillNo, string BillType) { string Status = ""; switch (BillType) { case "1": Status = new FeeBill().AddPrintedNum(BillNo); break; case "2": Status = new NoticeBill().AddPrintedNum(BillNo); break; case "3": Status = new BorrowBill().AddPrintedNum(BillNo); break; case "4": Status = new RefundBill().AddPrintedNum(BillNo); break; default: break; } return(""); }
/// <summary> /// 添加附件 /// </summary> /// <param name="Model">附件列表</param> /// <returns></returns> public string AddPhoto(AddPhotoModel Model) { string result = ""; Dictionary <string, List <PhotoModel> > dic = new Dictionary <string, List <PhotoModel> >(); dic.Add("Photos", Model.Photos); switch (Model.Type.ToUpper()) { case "1": result = new FeeBill().PublicEditMethod <List <PhotoModel> >(Model.BillNo, dic); break; case "2": result = new NoticeBill().PublicEditMethod <List <PhotoModel> >(Model.BillNo, dic); break; case "3": result = new BorrowBill().PublicEditMethod <List <PhotoModel> >(Model.BillNo, dic); break; case "4": result = new RefundBill().PublicEditMethod <List <PhotoModel> >(Model.BillNo, dic); break; default: break; } return(result); }
private string GetWorkFlowID(string BillNo) { BillNo = BillNo.Trim(' '); string WorkFlowID = string.Empty; if (BillNo.Contains("FB")) { var model = new FeeBill().GetBillModel(BillNo); if (model != null) { WorkFlowID = model.WorkFlowID; } else { var model1 = new RefundBill().GetBillModel(BillNo); WorkFlowID = model1.WorkFlowID; } } else if (BillNo.Contains("FT")) { var model = new NoticeBill().GetBillModel(BillNo); WorkFlowID = model.WorkFlowID; } else if (BillNo.Contains("JS")) { var model = new BorrowBill().GetBillModel(BillNo); WorkFlowID = model.WorkFlowID; } else { var model = new RefundBill().GetBillModel(BillNo); WorkFlowID = model.WorkFlowID; } return(WorkFlowID); }
public string GetBillTypeFrmBillNo(string BillNo) { var model = new FeeBill().GetBillModel(BillNo); if (model != null) { return("FeeBill"); } var model1 = new NoticeBill().GetBillModel(BillNo); if (model != null) { return("NoticeBill"); } var model2 = new BorrowBill().GetBillModel(BillNo); if (model2 != null) { return("BorrowBill"); } var model3 = new RefundBill().GetBillModel(BillNo); if (model3 != null) { return("RefundBill"); } return(""); }
public string MoveRecycleBin(string BillNo, string Type, string Status) { string result = ""; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("RecycleBin", Status); switch (Type.ToUpper()) { case "FEEBILL": result = new FeeBill().PublicEditMethod(BillNo, dic); break; case "NOTICEBILL": result = new NoticeBill().PublicEditMethod(BillNo, dic); break; case "BORROWBILL": result = new BorrowBill().PublicEditMethod(BillNo, dic); break; case "REFUNDBILL": result = new RefundBill().PublicEditMethod(BillNo, dic); break; default: break; } return(result); }
/// <summary> /// 删除单据 /// </summary> /// <param name="BillNo">单号</param> /// <param name="Type">类型</param> /// <returns></returns> public string DelectMyBill(string BillNo, int Type) { string result = ""; switch (Type) { case 1: result = new FeeBill().DelectFeeBill(BillNo); break; case 2: result = new NoticeBill().DelectNotcieBill(BillNo); break; case 3: result = new BorrowBill().DelectBorrowBill(BillNo); break; case 4: result = new RefundBill().DelectRefundBill(BillNo); break; default: break; } return(result); }
private string GetPostName(string BillNo, int Type) { string FlowType = string.Empty; switch (Type) { case 1: var f1 = new FeeBill().GetBillModel(BillNo); FlowType = f1.BillsType; break; case 2: var f2 = new NoticeBill().GetBillModel(BillNo); FlowType = f2.BillsType; break; case 3: var f3 = new BorrowBill().GetBillModel(BillNo); FlowType = f3.BillsType; break; case 4: var f4 = new RefundBill().GetBillModel(BillNo); FlowType = f4.BillsType; break; default: break; } var name = DbContext.FEE_ACCOUNT_DICTIONARY.Where(c => c.CODE == FlowType).Select(x => x.NAME).FirstOrDefault(); return(name); }
public ActionResult TransferAuditor(string BillNos, string No) { List <string> list = BillNos.ToUpper().Replace(",", "").Replace(",", "").Replace(" ", "").Replace("/", "").Replace("F", ",F").Replace("J", ",J").Replace("H", ",H").Split(',').ToList(); list.Remove(""); var em = DbContext.EMPLOYEE.Where(c => c.NO == No && c.LEAVE == "0" && c.AVAILABLE == "1").FirstOrDefault(); if (em == null) { return(Json(new { Msg = "工号无效", Status = "error" })); } string str = string.Empty; foreach (var item in list) { string Wk_Id = string.Empty; string obj_ID = new FeeBill().GetTransferData(item, out Wk_Id); string url = "http://192.168.2.14/WorkFlowServer/WorkFlowServer/upApproval"; string postDataStr = string.Format("WorkFlowId={0}&AssignmentIds={1}&userids={2}", Wk_Id, obj_ID, No); string jsonList = this.HttpGet(url, postDataStr); if (jsonList == "0") { str += "单号" + item + ","; } } if (!string.IsNullOrEmpty(str)) { str += "未转移成功"; } return(Json(new { Msg = str, Status = "success" }, JsonRequestBehavior.AllowGet)); }
public string EditColletion(string BillList, string username, string bankname, string code, string number) { string error = string.Empty; string msg = string.Empty; if (string.IsNullOrEmpty(BillList) || string.IsNullOrEmpty(username) || string.IsNullOrEmpty(bankname) || string.IsNullOrEmpty(code) || string.IsNullOrEmpty(number)) { error = "1"; msg = "信息缺失"; return(Public.JsonSerializeHelper.SerializeToJson(new { error = error, msg = msg })); } BillList = BillList.ToUpper().Replace(",", "").Replace(" ", "").Replace("/", "").Replace("F", ",F").Replace("J", ",J").Replace("H", ",H"); var list = BillList.Split(',').ToList(); var FB = new FeeBill(); var JS = new BorrowBill(); var RB = new RefundBill(); Dictionary <string, CollectionInfo> dic = new Dictionary <string, CollectionInfo>(); CollectionInfo coll = new CollectionInfo(); coll.Name = username; coll.SubbranchBank = bankname; coll.SubbranchBankCode = number; coll.CardCode = code; dic.Add("CollectionInfo", coll); foreach (var item in list) { if (item.Contains("FB")) { var model = FB.GetBillModel(item); if (model != null) { //审批通过了 if (model.ApprovalStatus == 2) { //不予许通过 msg += "单号" + item + "未做处理;"; } else { //进行修改 FB.PublicEditMethod <CollectionInfo>(item, dic); } } else { var model2 = RB.GetBillModel(item); if (model2.ApprovalStatus == 2) { msg += "单号" + item + "未做处理;"; } else { RB.PublicEditMethod <CollectionInfo>(item, dic); } } } else if (item.Contains("JS")) { var Model3 = JS.GetBillModel(item); if (Model3.ApprovalStatus == 2) { msg += "单号" + item + "未做处理;"; } else { JS.PublicEditMethod <CollectionInfo>(item, dic); } } } error = "0"; if (string.IsNullOrEmpty(msg)) { msg = "修改成功"; } return(Public.JsonSerializeHelper.SerializeToJson(new { error = error, msg = msg })); }
public string UpdatePayCode(string BillNo, string code) { string error = string.Empty; string msg = string.Empty; if (string.IsNullOrEmpty(BillNo)) { error = "1"; msg = "单号为空"; return(Public.JsonSerializeHelper.SerializeToJson(new { error = error, msg = msg })); } BillNo = BillNo.ToUpper().Replace(",", "").Replace(" ", "").Replace("/", "").Replace("F", ",F").Replace("J", ",J").Replace("H", ",H"); var list = BillNo.Split(',').ToList(); list.Remove(""); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("PaymentCompanyCode", code); var FB = new FeeBill(); var FT = new NoticeBill(); var JS = new BorrowBill(); var RB = new RefundBill(); try { foreach (var item in list) { if (item.Contains("FB")) { var isFee = FB.GetBillModel(item); if (isFee != null) { FB.PublicEditMethod(item, dic); string sql = string.Format(" Update FEE_FEEBILL set PAYCOMPANYCODE='{0}' where BIllno='{1}' ", code, item); DbContext.Database.ExecuteSqlCommand(sql); DbContext.SaveChanges(); } else { RB.PublicEditMethod(item, dic); string sql = string.Format(" Update FEE_FEEREFUNDBILL set PAYCOMPANYCODE='{0}' where BIllno='{1}' ", code, item); DbContext.Database.ExecuteSqlCommand(sql); DbContext.SaveChanges(); } } else if (item.Contains("FT")) { FT.PublicEditMethod(item, dic); string sql = string.Format(" Update FEE_NOTICEBILL set PAYCOMPANYCODE='{0}' where BIllno='{1}' ", code, item); DbContext.Database.ExecuteSqlCommand(sql); DbContext.SaveChanges(); } else if (item.Contains("JS")) { JS.PublicEditMethod(item, dic); string sql = string.Format(" Update FEE_BORROWBILL set PAYCOMPANYCODE='{0}' where BIllno='{1}' ", code, item); DbContext.Database.ExecuteSqlCommand(sql); DbContext.SaveChanges(); } else { RB.PublicEditMethod(item, dic); string sql = string.Format(" Update FEE_FEEREFUNDBILL set PAYCOMPANYCODE='{0}' where BIllno='{1}' ", code, item); DbContext.Database.ExecuteSqlCommand(sql); DbContext.SaveChanges(); } } } catch (Exception) { error = "1"; msg = "系统错误"; return(Public.JsonSerializeHelper.SerializeToJson(new { error = error, msg = msg })); } error = "0"; msg = "更新成功"; return(Public.JsonSerializeHelper.SerializeToJson(new { error = error, msg = msg })); }
public string GetEditPayCodeList(string BillNo) { BillNo = BillNo.ToUpper().Replace(",", "").Replace(" ", "").Replace("/", "").Replace("F", ",F").Replace("J", ",J").Replace("H", ",H"); var list = BillNo.Split(',').ToList(); list.Remove(""); var FB = new FeeBill(); var FT = new NoticeBill(); var JS = new BorrowBill(); var RB = new RefundBill(); List <PublicClass> ReturnModel = new List <PublicClass>(); foreach (var item in list) { PublicClass model = new PublicClass(); if (item.Contains("FB")) { var isFee = FB.GetBillModel(item); if (isFee != null) { model.c1 = isFee.BillNo; model.c2 = "费用报销单"; model.c3 = AjaxGetName(isFee.Creator); model.c4 = isFee.Owner; model.c5 = isFee.CreateTime.ToString("yyyy-mm-dd"); model.c6 = isFee.ApprovalTime; model.c7 = ReturnPayCode(isFee.PaymentCompanyCode, isFee.PersonInfo.CostCenter, isFee.PersonInfo.IsHeadOffice); model.c8 = isFee.Remark; } else { var IsRB = RB.GetBillModel(BillNo); if (IsRB != null) { model.c1 = IsRB.BillNo; model.c2 = "费用还款单"; model.c3 = AjaxGetName(IsRB.Creator); model.c4 = IsRB.Owner; model.c5 = IsRB.CreateTime.ToString("yyyy-mm-dd"); model.c6 = IsRB.ApprovalTime; model.c7 = ReturnPayCode(IsRB.PaymentCompanyCode, IsRB.PersonInfo.CostCenter, IsRB.PersonInfo.IsHeadOffice); model.c8 = IsRB.Remark; } } } else if (item.Contains("FT")) { var isFT = FT.GetBillModel(BillNo); if (isFT != null) { model.c1 = isFT.BillNo; model.c2 = "付款通知书"; model.c3 = AjaxGetName(isFT.Creator); model.c4 = isFT.Owner; model.c5 = isFT.CreateTime.ToString("yyyy-mm-dd"); model.c6 = isFT.ApprovalTime; model.c8 = isFT.Remark; } } else if (item.Contains("JS")) { var isJS = JS.GetBillModel(BillNo); if (isJS != null) { model.c1 = isJS.BillNo; model.c2 = "借款单"; model.c3 = AjaxGetName(isJS.Creator); model.c4 = isJS.Owner; model.c5 = isJS.CreateTime.ToString("yyyy-mm-dd"); model.c6 = isJS.ApprovalTime; model.c7 = ReturnPayCode(isJS.PaymentCompanyCode, isJS.PersonInfo.CostCenter, isJS.PersonInfo.IsHeadOffice); model.c8 = isJS.Remark; } } if (!string.IsNullOrEmpty(model.c1)) { ReturnModel.Add(model); } } return(Public.JsonSerializeHelper.SerializeToJson(ReturnModel)); }
private FeeBillModelRef ConvertData(string wkID) { FeeBillModelRef model = new FeeBillModelRef(); var FeeModel = new FeeBill().GetModelFromWorkFlowID(wkID); if (FeeModel != null) { model = FeeModel.MapTo <FeeBillModel, FeeBillModelRef>(); model.PageName = "FeeBill"; return(model); } var NotcieModel = new NoticeBill().GetModelFromWorkFlowID(wkID); if (NotcieModel != null) { model.BillNo = NotcieModel.BillNo; model.PersonInfo = NotcieModel.PersonInfo; model.TotalMoney = NotcieModel.TotalMoney; model.CreateTime = NotcieModel.CreateTime; model.TransactionDate = NotcieModel.TransactionDate; model.ApprovalTime = NotcieModel.ApprovalTime; model.ApprovalStatus = NotcieModel.ApprovalStatus; model.ApprovalPost = NotcieModel.ApprovalPost; model.Remark = NotcieModel.Remark; model.ProviderName = NotcieModel.ProviderInfo.ProviderName; model.Owner = NotcieModel.Owner; model.Creator = NotcieModel.Creator; model.SpecialAttribute = new SpecialAttribute(); model.SpecialAttribute.Funds = NotcieModel.SpecialAttribute.Funds; model.SpecialAttribute.Agent = NotcieModel.SpecialAttribute.Agent; model.SpecialAttribute.Check = NotcieModel.SpecialAttribute.Check; model.Items = NotcieModel.Items; model.Currency = NotcieModel.Currency; model.WorkNumber = NotcieModel.WorkNumber; model.ProviderCode = NotcieModel.ProviderInfo.ProviderCode; model.Owner = NotcieModel.Owner; model.MissBill = NotcieModel.MissBill; model.WorkFlowID = NotcieModel.WorkFlowID; model.CountTime = new CountTime(); model.Status = NotcieModel.Status; model.PageName = "NoticeBill"; return(model); } var BorrowModel = new BorrowBill().GetModelFromWorkFlowID(wkID); if (BorrowModel != null) { model.BillNo = BorrowModel.BillNo; model.PageName = "BorrowBill"; model.PersonInfo = BorrowModel.PersonInfo; model.TotalMoney = BorrowModel.TotalMoney; model.CreateTime = BorrowModel.CreateTime; model.TransactionDate = BorrowModel.TransactionDate; model.ApprovalTime = BorrowModel.ApprovalTime; model.ApprovalStatus = BorrowModel.ApprovalStatus; model.ApprovalPost = BorrowModel.ApprovalPost; model.Remark = BorrowModel.Remark; model.Owner = BorrowModel.Owner; model.Creator = BorrowModel.Creator; model.SpecialAttribute = BorrowModel.SpecialAttribute; model.Items = BorrowModel.Items; model.Currency = BorrowModel.Currency; model.WorkNumber = BorrowModel.WorkNumber; model.Owner = BorrowModel.Owner; model.WorkFlowID = BorrowModel.WorkFlowID; model.CollectionInfo = BorrowModel.CollectionInfo; model.CountTime = new CountTime(); model.Status = BorrowModel.Status; return(model); } var RefundModel = new RefundBill().GetModelFromWorkFlowID(wkID); if (RefundModel != null) { model = RefundModel.MapTo <RefundBillModel, FeeBillModelRef>(); model.PageName = "RefundBill"; return(model); } return(model); }
public string GetRelationBill(string itemName, string DepartmentCode, string ShopCode, DateTime CreateTime, string ProviderName, int IsHeadOffice, string BillNo) { if (string.IsNullOrEmpty(ShopCode) || ShopCode == "null") { ShopCode = null; } int FindDadaType = 0; if (BillNo.ToUpper().Contains("FT")) { FindDadaType = 1; } else if (BillNo.ToUpper().Contains("JS")) { FindDadaType = 2; } //取CreateTime时间,然后往前推三个月 CreateTime = CreateTime.AddMonths(-3); List <FeeBillModelRef> DataList = new List <FeeBillModelRef>(); if (FindDadaType == 0) { var FeeModel = new FeeBill().GetRelationBillList(itemName, DepartmentCode, ShopCode, CreateTime); if (FeeModel.Count > 0) { foreach (var item in FeeModel) { try { FeeBillModelRef model = new FeeBillModelRef() { BillNo = item.BillNo, BillsType = "FeeBill", CreateTime = item.CreateTime, TransactionDate = item.TransactionDate, Remark = item.Remark, ApprovalPost = item.ApprovalPost, ApprovalStatus = item.ApprovalStatus, PersonInfo = new PersonInfo { Brand = item.PersonInfo.Brand, Department = item.PersonInfo.Department, Shop = item.PersonInfo.Shop }, Items = item.Items, TotalMoney = item.TotalMoney, Creator = item.Creator, Owner = item.Owner }; DataList.Add(model); } catch (Exception) { continue; } } } } if (FindDadaType == 0 || FindDadaType == 1) { var NoticeModel = new NoticeBill().GetRelationBillList(itemName, DepartmentCode, ShopCode, CreateTime, ProviderName, IsHeadOffice, FindDadaType); if (NoticeModel.Count > 0) { foreach (var item in NoticeModel) { try { FeeBillModelRef model = new FeeBillModelRef() { BillNo = item.BillNo, BillsType = "NoticeBill", CreateTime = item.CreateTime, TransactionDate = item.TransactionDate, Remark = item.Remark, ApprovalPost = item.ApprovalPost, ApprovalStatus = item.ApprovalStatus, PersonInfo = new PersonInfo { Brand = item.PersonInfo.Brand, Department = item.PersonInfo.Department, Shop = item.PersonInfo.Shop }, Items = item.Items, TotalMoney = item.TotalMoney, Creator = item.Creator, Owner = item.Owner }; DataList.Add(model); } catch (Exception) { continue; } } } } if (FindDadaType == 0 || FindDadaType == 2) { var BorrowModel = new BorrowBill().GetRelationBillList(itemName, DepartmentCode, ShopCode, CreateTime); if (BorrowModel.Count > 0) { foreach (var item in BorrowModel) { try { FeeBillModelRef model = new FeeBillModelRef() { BillNo = item.BillNo, BillsType = "BorrowBill", CreateTime = item.CreateTime, TransactionDate = item.TransactionDate, Remark = item.Remark, ApprovalPost = item.ApprovalPost, ApprovalStatus = item.ApprovalStatus, PersonInfo = new PersonInfo { Brand = item.PersonInfo.Brand, Department = item.PersonInfo.Department, Shop = item.PersonInfo.Shop }, Items = item.Items, TotalMoney = item.TotalMoney, Creator = item.Creator, Owner = item.Owner }; DataList.Add(model); } catch (Exception) { continue; } } } } if (FindDadaType == 0) { var RefundModel = new RefundBill().GetRelationBillList(itemName, DepartmentCode, ShopCode, CreateTime); if (RefundModel.Count > 0) { foreach (var item in RefundModel) { try { FeeBillModelRef model = new FeeBillModelRef() { BillNo = item.BillNo, BillsType = "RefundBill", CreateTime = item.CreateTime, TransactionDate = item.TransactionDate, Remark = item.Remark, ApprovalPost = item.ApprovalPost, ApprovalStatus = item.ApprovalStatus, PersonInfo = new PersonInfo { Brand = item.PersonInfo.Brand, Department = item.PersonInfo.Department, Shop = item.PersonInfo.Shop }, Items = item.Items, TotalMoney = item.RealRefundMoney, Creator = item.Creator, Owner = item.Owner }; DataList.Add(model); } catch (Exception) { continue; } } } } if (DataList.Count > 0) { DataList = DataList.OrderByDescending(c => c.CreateTime).ToList(); } return(Public.JsonSerializeHelper.SerializeToJson(DataList)); }
public string EditFeeBillContent(FeeBillModel postFeeBill) { this.Request.Url.AbsoluteUri.ToString(); string result = "Fail"; //检查 if (string.IsNullOrEmpty(postFeeBill.COST_ACCOUNT)) { result = "成本中心为空"; return(result); } if (postFeeBill.Items == null || postFeeBill.Items.Count < 1) { result = "缺少报销项"; return(result); } else { postFeeBill.TotalMoney = postFeeBill.Items.Sum(all => all.money) + postFeeBill.Items.Sum(all => all.taxmoney); } if (postFeeBill.Photos == null || postFeeBill.Photos.Count < 1) { result = "缺少发票照片"; return(result); } if (postFeeBill.SpecialAttribute.MarketDebt != 1 && postFeeBill.SpecialAttribute.BankDebt != 1 && postFeeBill.SpecialAttribute.Cash != 1) { if (postFeeBill.CollectionInfo == null || string.IsNullOrEmpty(postFeeBill.CollectionInfo.CardCode) || string.IsNullOrEmpty(postFeeBill.CollectionInfo.Name) || string.IsNullOrEmpty(postFeeBill.CollectionInfo.SubbranchBank) || string.IsNullOrEmpty(postFeeBill.CollectionInfo.SubbranchBankCode)) { result = "收款信息缺失"; return(result); } } else { postFeeBill.CollectionInfo = new CollectionInfo(); } var obj = PublicGetCosterCenter(postFeeBill.PersonInfo.IsHeadOffice, postFeeBill.PersonInfo.CostCenter); if (postFeeBill.PersonInfo.IsHeadOffice == 0) { var DicModel = DbContext.FEE_ACCOUNT_DICTIONARY.Where(c => c.CODE == postFeeBill.BillsType && c.BRAND == obj.NAME).FirstOrDefault(); if (DicModel != null) { if (DicModel.PARTBRAND == 1) //分品牌 { if (postFeeBill.PersonInfo.Brand == null || postFeeBill.PersonInfo.Brand.Count < 1) { result = "记账品牌至少选择一项!"; return(result); } int brandcount = 0; foreach (var item in postFeeBill.PersonInfo.Brand) { if (DicModel.BRANDLIST.Contains(item)) { brandcount++; } } if (brandcount >= 2) { result = DicModel.BRANDLIST + "只能选择一项!"; return(result); } } } } try { var lable = PublicDemand(postFeeBill.PersonInfo.IsHeadOffice, postFeeBill.BillsType, postFeeBill.PersonInfo.DepartmentCode, obj, postFeeBill.Items, postFeeBill.SpecialAttribute, postFeeBill.DepartmentName); Dictionary <string, string> dic = new Dictionary <string, string>(); string dicString = Public.JsonSerializeHelper.SerializeToJson(dic); var oldModel = new FeeBill().GetBillModel(postFeeBill.BillNo); WorkFlowProxy.WorkFlowProxy proxy = new WorkFlowProxy.WorkFlowProxy(); string objectID = proxy.NewWorkFlowInstance(lable.CODE, postFeeBill.Creator, oldModel.BillNo, dicString); postFeeBill.BillNo = oldModel.BillNo; postFeeBill.Id = oldModel.Id; postFeeBill.WorkFlowID = objectID; postFeeBill.CreateTime = oldModel.CreateTime; postFeeBill.Status = oldModel.Status; postFeeBill.ApprovalPost = oldModel.ApprovalPost; postFeeBill.ApprovalStatus = oldModel.ApprovalStatus; postFeeBill.ApprovalTime = oldModel.ApprovalTime; postFeeBill.BillsItems = postFeeBill.Items; string status = new FeeBill().EditFeeBill(postFeeBill); if (status != "Success") { result = "编辑失败"; return(result); } result = "Success"; } catch { result = "Fail"; } return(result); }
/// <summary> /// 获取未办结单据 /// </summary> /// <param name="?"></param> /// <returns></returns> public List <FeeBillModelRef> GetNotFinishBill(string EmployeeNo) { List <FeeBillModelRef> Temp = new List <FeeBillModelRef>(); var FeeModel = new FeeBill().GetNotFinishBill(EmployeeNo); if (FeeModel != null && FeeModel.Count > 0) { foreach (var item in FeeModel) { var model = new FeeBillModelRef() { BillNo = item.BillNo, TotalMoney = item.TotalMoney, Owner = item.Owner }; model.PageName = "费用报销单"; Temp.Add(model); } } var NoticeModel = new NoticeBill().GetNotFinishBill(EmployeeNo); if (NoticeModel != null && NoticeModel.Count > 0) { foreach (var item in NoticeModel) { var model = new FeeBillModelRef() { BillNo = item.BillNo, TotalMoney = item.TotalMoney, Owner = item.Owner }; model.PageName = "付款通知书"; Temp.Add(model); } } var BorrowModel = new BorrowBill().GetNotFinishBill(EmployeeNo); if (BorrowModel != null && BorrowModel.Count > 0) { foreach (var item in BorrowModel) { var model = new FeeBillModelRef() { BillNo = item.BillNo, TotalMoney = item.TotalMoney, Owner = item.Owner }; model.PageName = "借款单"; Temp.Add(model); } } var RefundModel = new RefundBill().GetNotFinishBill(EmployeeNo); if (RefundModel != null && RefundModel.Count > 0) { foreach (var item in RefundModel) { var model = new FeeBillModelRef() { BillNo = item.BillNo, TotalMoney = item.RealRefundMoney, Owner = item.Owner }; model.PageName = "还款单"; Temp.Add(model); } } return(Temp); }
public string GetReportData(int billType, int Time, int departmentID, string operation, string StartTime = "", string EndTime = "") { var employee = Marisfrolg.Public.Common.GetEmployeeInfo(); //我搁置的单 if (operation == "1") { List <FeeBillModelRef> AllModel = new List <FeeBillModelRef>(); var Temp1 = new FeeBill().ReturnShelveNo(employee.EmployeeName); var Temp2 = new NoticeBill().ReturnShelveNo(employee.EmployeeNo); var Temp3 = new BorrowBill().ReturnShelveNo(employee.EmployeeNo); var Temp4 = new RefundBill().ReturnShelveNo(employee.EmployeeNo); foreach (var item1 in Temp1) { FeeBillModelRef TempModel = new FeeBillModelRef() { BillNo = item1.BillNo, PageName = "费用报销单", Creator = item1.Creator, Owner = item1.Owner, TotalMoney = item1.TotalMoney, StringTime = item1.CreateTime.ToString("yyyy-MM-dd"), CreateTime = item1.CreateTime, PersonInfo = new PersonInfo() { DepartmentCode = item1.PersonInfo.DepartmentCode, Department = item1.PersonInfo.Department } }; AllModel.Add(TempModel); } foreach (var item2 in Temp2) { FeeBillModelRef TempModel = new FeeBillModelRef() { BillNo = item2.BillNo, PageName = "付款通知书", Creator = item2.Creator, Owner = item2.Owner, TotalMoney = item2.TotalMoney, StringTime = item2.CreateTime.ToString("yyyy-MM-dd"), CreateTime = item2.CreateTime, PersonInfo = new PersonInfo() { DepartmentCode = item2.PersonInfo.DepartmentCode, Department = item2.PersonInfo.Department } }; AllModel.Add(TempModel); } foreach (var item3 in Temp3) { FeeBillModelRef TempModel = new FeeBillModelRef() { BillNo = item3.BillNo, PageName = "借款单", Creator = item3.Creator, Owner = item3.Owner, TotalMoney = item3.TotalMoney, StringTime = item3.CreateTime.ToString("yyyy-MM-dd"), CreateTime = item3.CreateTime, PersonInfo = new PersonInfo() { DepartmentCode = item3.PersonInfo.DepartmentCode, Department = item3.PersonInfo.Department } }; AllModel.Add(TempModel); } foreach (var item4 in Temp4) { FeeBillModelRef TempModel = new FeeBillModelRef() { BillNo = item4.BillNo, PageName = item4.RefundType.ToUpper() == "CASH" ? "现金还款" : "费用单还款", Creator = item4.Creator, Owner = item4.Owner, TotalMoney = item4.RealRefundMoney, StringTime = item4.CreateTime.ToString("yyyy-MM-dd"), CreateTime = item4.CreateTime, PersonInfo = new PersonInfo() { DepartmentCode = item4.PersonInfo.DepartmentCode, Department = item4.PersonInfo.Department } }; AllModel.Add(TempModel); } switch (billType) { case 0: break; case 1: AllModel.RemoveAll(c => c.PageName.Contains("付款") || c.PageName.Contains("借款") || c.PageName.Contains("还款")); break; case 2: AllModel.RemoveAll(c => c.PageName.Contains("费用报销") || c.PageName.Contains("借款") || c.PageName.Contains("还款")); break; case 3: AllModel.RemoveAll(c => c.PageName.Contains("付款") || c.PageName.Contains("费用报销") || c.PageName.Contains("还款")); break; case 4: AllModel.RemoveAll(c => c.PageName.Contains("付款") || c.PageName.Contains("借款") || c.PageName.Contains("费用报销")); break; default: break; } if (AllModel.Count > 0) { var temp = TransformData(AllModel, 0); MemoryCachingClient M = new MemoryCachingClient(); M.Remove(employee.EmployeeNo); M.Add(employee.EmployeeNo, temp); return(JsonSerializeHelper.SerializeToJson(temp)); } return("{}"); } object data = GetApprovalData(billType, Time, employee.EmployeeNo, departmentID.ToString(), StartTime, EndTime); if (data != null) { var temp = TransformData(data, billType); MemoryCachingClient M = new MemoryCachingClient(); M.Remove(employee.EmployeeNo); M.Add(employee.EmployeeNo, temp); return(JsonSerializeHelper.SerializeToJson(temp)); } return("{}"); //ReportHelper helper = new ReportHelper(); //DataTable dt = helper.GetDataTable(@"select ID,NO,NAME,SHOPCODE,CREATOR,CHANGER,AVAILABLE,LEAVE,PASSWORD,DEPID from Employee where (DEPID=" + departmentID + " or 0=" + departmentID + ") and length(NO)>4 and ROWNUM<100"); //foreach (DataColumn item in dt.Columns) //{ // if (item.ColumnName == "NAME") // { // item.ColumnName = "姓名"; // } // if (item.ColumnName == "NO") // { // item.ColumnName = "工号"; // } //} //var temp = ReportHelper.ConvertDataTable(dt); //return JsonSerializeHelper.SerializeToJson(temp); }
public string CreateRefundBill(RefundBillModel postRefundBill) { this.Request.Url.AbsoluteUri.ToString(); string result = "Fail"; //费用报销单还款 var obj = GetBrandFromCosterCenterNew(postRefundBill.PersonInfo.CostCenter); if (postRefundBill.RefundType.ToUpper() == "FEEBILL") { //检查 if (string.IsNullOrEmpty(postRefundBill.COST_ACCOUNT)) { result = "成本中心为空"; return(result); } if (postRefundBill.Items == null || postRefundBill.Items.Count < 1) { result = "缺少报销项"; return(result); } else { postRefundBill.RealRefundMoney = postRefundBill.Items.Sum(all => all.money) + postRefundBill.Items.Sum(all => all.taxmoney); } if (postRefundBill.Photos == null || postRefundBill.Photos.Count < 1) { result = "缺少发票照片"; return(result); } foreach (var item in postRefundBill.Items) { var value = DbContext.FEE_ACCOUNT.Where(c => c.NAME == item.name || c.OLDNAME == item.name).Select(c => c.IS_MARKET).FirstOrDefault(); if (value == null) { item.IsMarket = 0; } else { item.IsMarket = Convert.ToInt32(item.IsMarket); } } if (postRefundBill.PersonInfo.IsHeadOffice == 0) { var DicModel = DbContext.FEE_ACCOUNT_DICTIONARY.Where(c => c.CODE == postRefundBill.BillsType && c.BRAND == obj.NAME).FirstOrDefault(); if (DicModel != null) { if (DicModel.PARTBRAND == 1) { if (postRefundBill.PersonInfo.Brand == null || postRefundBill.PersonInfo.Brand.Count < 1) { result = "记账品牌至少选择一项!"; return(result); } int brandcount = 0; foreach (var item in postRefundBill.PersonInfo.Brand) { if (DicModel.BRANDLIST.Contains(item)) { brandcount++; } } if (brandcount >= 2) { result = DicModel.BRANDLIST + "只能选择一项!"; return(result); } } } //增加店柜品牌属性 if (!string.IsNullOrEmpty(postRefundBill.PersonInfo.ShopCode)) { postRefundBill.ShopLogo = DbContext.SHOP.Where(c => c.CODE == postRefundBill.PersonInfo.ShopCode).Select(x => x.SHOPLOGO).FirstOrDefault(); } } } //现金还款 else { if (postRefundBill.RealRefundMoney < 0) { result = "还款金额错误"; return(result); } } try { var BorrowModel = new BorrowBill().GetBillModel(postRefundBill.BorrowBillNo); //费用还款可以还款超出欠款额度,只须拆成两单 if (postRefundBill.RealRefundMoney > BorrowModel.SurplusMoney && postRefundBill.RefundType.ToUpper() != "FEEBILL") { result = "还款金额超出"; return(result); } WorkFlowProxy.WorkFlowProxy proxy = new WorkFlowProxy.WorkFlowProxy(); string MaxNumber = string.Empty; if (postRefundBill.RefundType.ToUpper() == "CASH") { postRefundBill.BillsType = "HK1"; MaxNumber = new RefundBill().GenerateMaxBillNo(); } else { MaxNumber = new FeeBill().GenerateMaxBillNo(); } var lable = PublicDemand(postRefundBill.PersonInfo.IsHeadOffice, postRefundBill.BillsType, postRefundBill.PersonInfo.DepartmentCode, obj, postRefundBill.Items, postRefundBill.SpecialAttribute, postRefundBill.DepartmentName); //PackClass PackString = new PackClass() { Creator = postRefundBill.Creator, BillsType = postRefundBill.BillsType, Brand = postRefundBill.PersonInfo.Brand, CompanyCode = postRefundBill.PersonInfo.CompanyCode, CostCenter = postRefundBill.PersonInfo.CostCenter, Department = postRefundBill.PersonInfo.Department, DepartmentCode = postRefundBill.PersonInfo.DepartmentCode, IsHeadOffice = postRefundBill.PersonInfo.IsHeadOffice, Items = postRefundBill.Items == null ? null : postRefundBill.Items.Select(x => x.name).ToList() }; //Dictionary<string, string> dic = new Dictionary<string, string>(); //string pack = Public.JsonSerializeHelper.SerializeToJson(PackString); //dic.Add("pack", pack); //string dicString = Public.JsonSerializeHelper.SerializeToJson(dic); Dictionary <string, string> dic = new Dictionary <string, string>(); string dicString = Public.JsonSerializeHelper.SerializeToJson(dic); try { string sql = " insert into FEE_BILLNO (BILLNO) values('" + MaxNumber + "')"; int num = DbContext.Database.ExecuteSqlCommand(sql); if (num < 1) { DeleteInvalidBillNo(MaxNumber); result = "服务器繁忙!请重新提交"; return(result); } } catch { result = "服务器繁忙!请重新提交"; return(result); } string objectID = string.Empty; try { objectID = proxy.NewWorkFlowInstance(lable.CODE, postRefundBill.Creator, MaxNumber, dicString); } catch { DeleteInvalidBillNo(MaxNumber); result = "服务内部出错,请联系数控中心"; return(result); } postRefundBill.CreateTime = DateTime.Now; postRefundBill.Status = 0; postRefundBill.WorkFlowID = objectID; postRefundBill.BillsItems = postRefundBill.Items; postRefundBill.BillNo = MaxNumber; new RefundBill().CreateRefundBill(postRefundBill); result = MaxNumber; } catch { result = "Fail"; } return(result); }
/// <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(""); } }