public void ExportNeibu(string path, List <SettlementDtlDto> lst, SettlementMstDto settlementMstDto)
{
MSExcelUtil msExcelUtil = new MSExcelUtil();
Workbook workbook = msExcelUtil.OpenExcelByMSExcel(path);
Worksheet sheet = workbook.ActiveSheet;
msExcelUtil.SetCellValueAndMultLine(sheet, 2, 7, settlementMstDto.ProjectName, 11);
msExcelUtil.SetCellValueAndMultLine(sheet, 5, 7, settlementMstDto.ProjectCode, 11);
//msExcelUtil.SetCellValueAndMultLine(sheet, 2, 8, settlementMstDto.ExecuteCycle, 40);
msExcelUtil.SetCellValueAndMultLine(sheet, 5, 8, settlementMstDto.SupplyService, 10);
msExcelUtil.SetCellValueAndMultLine(sheet, 2, 9, settlementMstDto.SupplierName, 11);
msExcelUtil.SetCellValueAndMultLine(sheet, 5, 9, settlementMstDto.ServiceRegion, 10);
int startIndex = 11;
startIndex = InsertSettlements(msExcelUtil, sheet, lst.Where(x => x.SettlementType == "1").ToList(), startIndex);
startIndex += 3;
startIndex = InsertSettlements(msExcelUtil, sheet, lst.Where(x => x.SettlementType == "2").ToList(), startIndex);
startIndex += 3;
startIndex = InsertSettlements(msExcelUtil, sheet, lst.Where(x => x.SettlementType == "3").ToList(), startIndex);
startIndex += 4;
msExcelUtil.SetCellValue(sheet, 4, startIndex, settlementMstDto.FlowOrderSum);
workbook.Save();
msExcelUtil.dispose();
}
// GET: QuotationExport
public ActionResult ExportList(string ProjectId, string SupplierId, string ProjectShortName, string ProjectCode,
string SupplierName, string ProjectName, string ModelType, string quotationGroupId, string settlementId, string zipPath)
{
SettlementMstDto mstDto = service.SettleDtlMainSearch(ProjectId, SupplierId, settlementId, quotationGroupId, UserInfo.UserId).FirstOrDefault();
SettlementExport export = new SettlementExport();
mstDto.ProjectName = ProjectName;
mstDto.ProjectCode = ProjectCode;
mstDto.ProjectShortName = ProjectShortName;
mstDto.SupplierName = SupplierName;
string path = GetExcelPath(ProjectShortName, SupplierName, ModelType, zipPath);
List <SettlementDtlDto> lst = service.SettlementDtlSearch_After(settlementId, UserInfo.UserId);
lst.AddRange(service.SettlementDtlSearch_After_shoudong(settlementId, UserInfo.UserId));
if (ModelType == "业务")
{
export.Export(path, lst, mstDto);
}
else
{
export.ExportNeibu(path, lst, mstDto);
}
return(Json(path + "," + Path.GetFileName(path)));
}
public ActionResult LoadSettlementDtlsForEdit(string projectId, string supplierId, string quotationGroupId, string settlementId)
{
SettlementMstDto settlementMstDto = service.SettleDtlMainSearch(projectId, supplierId, settlementId, quotationGroupId, UserInfo.UserId).FirstOrDefault();
if (settlementMstDto.ExecuteCycle == null)
{
settlementMstDto.ExecuteCycle = "";
}
if (settlementMstDto.zhixingchengshi == "全国-")
{
settlementMstDto.zhixingchengshi = "全国";
}
if (settlementMstDto == null)
{
settlementMstDto = new SettlementMstDto();
}
List <SettlementDtlDto> lst = service.SettlementDtlSearch_After(settlementId, UserInfo.UserId);
List <SettlementDtlDto> zhuijiaShoudong = service.SettlementDtlSearch_After_shoudong(settlementId, UserInfo.UserId);
return(Json(new
{
List = lst,
MainObject = settlementMstDto,
Exist = false,
//BugetAmtDto = bugetAmtDto,
ZuijiaShoudongList = zhuijiaShoudong
}));
}
/// <summary>
/// 供应商结算单Mst保存
/// </summary>
/// <param name="dto"></param>
/// <param name="userId"></param>
public int SettlementMstSave(SettlementMstDto dto, string userId)
{
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", dto.SettlementId.ToString()),
new SqlParameter("@ProjectId", dto.ProjectId.ToString()),
new SqlParameter("@SupplierId", dto.SupplierId.ToString()),
new SqlParameter("@QuotationGroupId", dto.QuotationGroupId.ToString()),
new SqlParameter("@SettleChk", dto.SettleChk),
new SqlParameter("@UserId", userId) };
Type t = typeof(int);
//db.Database.ExecuteSqlCommand("EXEC up_SettlementMst_S @Id,@ProjectId,@SupplierId,@SettleChk,@UserId", para);
int settlementId = db.Database.SqlQuery(t, "EXEC up_SettlementMst_S @Id,@ProjectId,@SupplierId,@QuotationGroupId,@SettleChk,@UserId", para).Cast <int>().First();
return(settlementId);
}
public ActionResult SettleDtlMainSearch(string projectId, string supplierId, string quotationGroupId, string settlementId, bool settleChk, bool?delChk)
{
bool delChk_temp = true;
if (delChk == null || delChk == false)
{
delChk_temp = false;
}
else
{
delChk_temp = true;
}
service.SettlementMstUpdate(settlementId, settleChk, delChk_temp, UserInfo.UserId);
SettlementMstDto settlementMstDto = service.SettleDtlMainSearch(projectId, supplierId, settlementId, quotationGroupId, UserInfo.UserId).FirstOrDefault();
if (settlementMstDto == null)
{
settlementMstDto = new SettlementMstDto();
}
return(Json(settlementMstDto));
}
public ActionResult SaveSettlementDtls(string jsonArr, string shoudongArr, string ProjectId, string SupplierId, string QuotationGroupId, string SettlementId, string SeqNO_Supplier)
{
int mstId = int.Parse(SettlementId);
if (mstId == 0)
{
SettlementMstDto mstDto = new SettlementMstDto()
{
SettlementId = SettlementId,
ProjectId = ProjectId,
SupplierId = SupplierId,
QuotationGroupId = QuotationGroupId
};
mstId = service.SettlementMstSave(mstDto, UserInfo.UserId);
}
List <SettlementDtlDto> lst = JsonConvert.DeserializeObject <List <SettlementDtlDto> >(jsonArr);
foreach (SettlementDtlDto dto in lst)
{
dto.SettlementId = mstId.ToString();
service.SettlementDtlSave(dto, UserInfo.UserId);
}
List <SettlementDtlDto> shoudongLst = JsonConvert.DeserializeObject <List <SettlementDtlDto> >(shoudongArr);
foreach (SettlementDtlDto dto in shoudongLst)
{
dto.SettlementId = mstId.ToString();
dto.settlementSeqNO = dto.settlementSeqNO == null ? "0" : dto.settlementSeqNO;
dto.Quotationid = "0";
dto.SeqNO = "0";
dto.SettlementType = "3";
service.SettlementDtlSave_shoudong(dto, UserInfo.UserId);
}
return(Json(new { SettlementId = mstId }));
}
public ActionResult ApplyDetail_SettlementDtl(int applyId, int settlementId, int quotationGroupId, int projectId, int supplierId)
{
SettlementService settlementService = new SettlementService();
// 查询当前项目下供应商执行的基本信息
SettlementMstDto settlementMstDto = settlementService.SettleDtlMainSearch(projectId.ToString(), supplierId.ToString(), settlementId.ToString(), quotationGroupId.ToString(), UserInfo.UserId).FirstOrDefault();
// 查询当前项目下的预算和结算信息
SettlementBugetAmtDto bugetAmtDto = service.ApplyDtl_SettlementBugetAmtSearch(projectId.ToString(), applyId.ToString()).FirstOrDefault();
if (settlementMstDto.ExecuteCycle == null)
{
settlementMstDto.ExecuteCycle = "";
}
if (settlementMstDto.zhixingchengshi == "全国-")
{
settlementMstDto.zhixingchengshi = "全国";
}
// 查询供应商结算的详细信息
List <SettlementDtlDto> lst = service.ApplyDtl_SettlementDtlByApplyIdAndSettlementIdSearch(applyId.ToString(), settlementId.ToString());
lst.AddRange(service.ApplyDtl_SettlementDtlByApplyIdAndSettlementIdSearch_shoudong(applyId.ToString(), settlementId.ToString()));
return(Json(new { List = lst, MainObject = settlementMstDto, BugetAmtDto = bugetAmtDto }));
}
public ActionResult LoadSettlementDtlsForAdd(string projectId, string supplierId, string quotationGroupId)
{
SettlementMstDto settlementMstDto = service.SettleDtlMainSearch(projectId, supplierId, "0", quotationGroupId, UserInfo.UserId).FirstOrDefault();
if (settlementMstDto.ExecuteCycle == null)
{
settlementMstDto.ExecuteCycle = "";
}
if (settlementMstDto.zhixingchengshi == "全国-")
{
settlementMstDto.zhixingchengshi = "全国";
}
if (settlementMstDto == null)
{
settlementMstDto = new SettlementMstDto();
}
List <SettlementDtlDto> lst = new List <SettlementDtlDto>();
List <SettlementDtlDto> zhuijiaShoudong = new List <SettlementDtlDto>();
lst = service.SettlementDtlSearch_Before(projectId, supplierId, quotationGroupId, UserInfo.UserId);
List <SettlementDtlDto> lst2 = new List <SettlementDtlDto>();
List <SettlementDtlDto> lst3 = new List <SettlementDtlDto>();
foreach (SettlementDtlDto dto in lst)
{
dto.SettlementType = "1";
lst2.Add(new SettlementDtlDto()
{
ProjectId = dto.ProjectId,
SupplierId = dto.SupplierId,
Quotationid = dto.Quotationid,
SeqNO = dto.SeqNO,
danjia = "",
FeeContent = dto.FeeContent,
SettleCount = dto.SettleCount,
Remark = dto.Remark,
SettlementType = "2",
});
lst3.Add(new SettlementDtlDto()
{
ProjectId = dto.ProjectId,
SupplierId = dto.SupplierId,
Quotationid = dto.Quotationid,
SeqNO = dto.SeqNO,
danjia = "",
FeeContent = dto.FeeContent,
SettleCount = dto.SettleCount,
Remark = dto.Remark,
SettlementType = "3",
});
}
lst.AddRange(lst2);
lst.AddRange(lst3);
//做分次结算以后 每个供应商有多个结算记录，单个结算登记时不需要结算金额
//SettlementBugetAmtDto bugetAmtDto = service.SettlementBugetAmtSearch(projectId.ToString()).FirstOrDefault();
return(Json(new
{
List = lst,
MainObject = settlementMstDto,
Exist = false,
//BugetAmtDto = bugetAmtDto,
ZuijiaShoudongList = zhuijiaShoudong
}));
}
