// GET: Edit
public ActionResult Edit(string id, string ProjectId, string SupplierId)
{
FlowOrderDto flowOrderDto = service.FlowOrderSearchById(id, UserInfo.UserId).FirstOrDefault();
if (flowOrderDto == null)
{
flowOrderDto = new FlowOrderDto();
}
return(PartialView("_PartialEdit", flowOrderDto));
}
public ActionResult ApplyDetail_FlowOrderBy(string applyId, string id)
{
//FlowOrderService flowerService = new FlowOrderService();
// FlowOrderDto flowOrderDto = flowerService.FlowOrderSearchById(id, UserInfo.UserId).FirstOrDefault();
FlowOrderDto flowOrderDto = service.ApplyDtl_FlowOrderByApplyIdAndFlowOrderId(applyId, id).FirstOrDefault();
if (flowOrderDto == null)
{
flowOrderDto = new FlowOrderDto();
}
return(PartialView("_PartialApplyCheckApplyDtlFlowOrderDtlEdit", flowOrderDto));
}
public void FlowOrderSave(FlowOrderDto dto, string userId)
{
string EstimatedPaymentTime1 = "";
string FactPaymentTime1 = "";
if (dto.Remark == null)
{
dto.Remark = "";
}
if (dto.InvoiceAmt == null)
{
dto.InvoiceAmt = "";
}
if (dto.EstimatePaymentAmt == null)
{
dto.EstimatePaymentAmt = "";
}
if (dto.FactPaymentAmt == null)
{
dto.FactPaymentAmt = "";
}
if (dto.EstimatedPaymentTime != null)
{
EstimatedPaymentTime1 = dto.EstimatedPaymentTime.ToString();
}
if (dto.FactPaymentTime != null)
{
FactPaymentTime1 = dto.FactPaymentTime.ToString();
}
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", dto.FlowOrderId.ToString()),
new SqlParameter("@ProjectId", dto.ProjectId.ToString()),
new SqlParameter("@SupplierId", dto.SupplierId.ToString()),
new SqlParameter("@ExecuteCycleStartDate", dto.ExecuteCycleStartDate),
new SqlParameter("@ExecuteCycleEndDate", dto.ExecuteCycleEndDate),
new SqlParameter("@ExpendPattern", dto.ExpendPattern),
new SqlParameter("@ExpendType", dto.ExpendType),
new SqlParameter("@PaymentType", dto.PaymentType),
new SqlParameter("@PaymentCompany", dto.PaymentCompany),
new SqlParameter("@EstimatedPaymentTime", EstimatedPaymentTime1),
new SqlParameter("@EstimatedPaymentAmt", dto.EstimatePaymentAmt.ToString()),
new SqlParameter("@FactPaymentTime", FactPaymentTime1),
new SqlParameter("@FactPaymentAmt", dto.FactPaymentAmt.ToString()),
new SqlParameter("@InvoceAmt", dto.InvoiceAmt.ToString()),
new SqlParameter("@Payee", dto.Payee),
new SqlParameter("@Remark", dto.Remark),
new SqlParameter("@UserId", userId) };
db.Database.ExecuteSqlCommand("EXEC up_FlowOrder_S @Id,@ProjectId,@SupplierId,@ExecuteCycleStartDate,@ExecuteCycleEndDate,@ExpendPattern,@ExpendType,@PaymentType,@PaymentCompany,@EstimatedPaymentTime,@EstimatedPaymentAmt,@FactPaymentTime,@FactPaymentAmt,@InvoceAmt,@Payee,@Remark,@UserId", para);
}
public ActionResult FinanceSave()
{
FlowOrderDto flowOrder = new FlowOrderDto()
{
PreTaxAmt = "",
InvoceAmtThis = "",
ProjectType = "",
ConstractChk = "",
SettlementChk = "",
InvoceChk = "",
PaperChk = "",
PaymentRemark = ""
};
TryUpdateModel <FlowOrderDto>(flowOrder);
service.PaymentListUpdate(flowOrder, UserInfo.UserId);
return(Json(""));
}
public ActionResult Save()
{
FlowOrderDto flowOrder = new FlowOrderDto()
{
PaymentRemark = "",
Finance_PaymentStatus = "",
Finance_PaymentAmt = "",
Finance_NotPayReason = "",
Finance_Constract = "",
Finance_SettlementChk = "",
Finance_InvoceAmt = "",
Finance_InvoceAmtThis = ""
};
TryUpdateModel <FlowOrderDto>(flowOrder);
service.PaymentListUpdate(flowOrder, UserInfo.UserId);
return(Json(""));
}
public ActionResult Save()
{
FlowOrderDto flowOrder = new FlowOrderDto();
TryUpdateModel <FlowOrderDto>(flowOrder);
service.FlowOrderSave(flowOrder, UserInfo.UserId);
try
{
MasterService master = new MasterService();
master.RemindCancelSave("计提填写提醒", flowOrder.ProjectId.ToString(), UserInfo.UserId, DateTime.Now.ToString());
master.RemindCancelSave("资金需求填写提醒", flowOrder.ProjectId.ToString(), UserInfo.UserId, DateTime.Now.ToString());
// 对公付款填写提醒拥有对公付款保存权限的人员
List <UserInfoDto> list = master.UserInfoSearch("", "", "对公付款保存");
foreach (UserInfoDto user in list)
{
master.RemindCancelSave("对公付款填写提醒", flowOrder.ProjectId.ToString(), user.UserId, DateTime.Now.ToString());
}
}
catch (Exception)
{
}
return(Json(""));
}
public ActionResult FinanceEdit(string flowOrderId)
{
FlowOrderDto flowOrderDto = service.FlowOrderSearchById(flowOrderId, UserInfo.UserId).FirstOrDefault();
return(PartialView("_PartialFinanceEdit", flowOrderDto));
}
/// <summary>
///
/// </summary>
/// <param name="dto"></param>
/// <param name="userId"></param>
public void PaymentListUpdate(FlowOrderDto dto, string userId)
{
if (dto.PreTaxAmt == null)
{
dto.PreTaxAmt = "";
}
if (dto.InvoceAmtThis == null)
{
dto.InvoceAmtThis = "";
}
if (dto.Finance_PaymentAmt == null)
{
dto.Finance_PaymentAmt = "";
}
if (dto.Finance_InvoceAmt == null)
{
dto.Finance_InvoceAmt = "";
}
if (dto.Finance_InvoceAmtThis == null)
{
dto.Finance_InvoceAmtThis = "";
}
if (dto.ProjectType == null)
{
dto.ProjectType = "";
}
if (dto.ConstractChk == null)
{
dto.ConstractChk = "";
}
if (dto.SettlementChk == null)
{
dto.SettlementChk = "";
}
if (dto.InvoceChk == null)
{
dto.InvoceChk = "";
}
if (dto.PaperChk == null)
{
dto.PaperChk = "";
}
if (dto.PaymentRemark == null)
{
dto.PaymentRemark = "";
}
if (dto.Finance_PaymentStatus == null)
{
dto.Finance_PaymentStatus = "";
}
if (dto.Finance_NotPayReason == null)
{
dto.Finance_NotPayReason = "";
}
if (dto.Finance_Constract == null)
{
dto.Finance_Constract = "";
}
if (dto.Finance_SettlementChk == null)
{
dto.Finance_SettlementChk = "";
}
if (dto.InvoiceNO == null)
{
dto.InvoiceNO = "";
}
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", dto.FlowOrderId),
new SqlParameter("@PreTaxAmt", dto.PreTaxAmt),
new SqlParameter("@InvoceAmtThis", dto.InvoceAmtThis),
new SqlParameter("@ProjectType", dto.ProjectType),
new SqlParameter("@ConstractChk", dto.ConstractChk),
new SqlParameter("@SettlementChk", dto.SettlementChk),
new SqlParameter("@InvoceChk", dto.InvoceChk),
new SqlParameter("@PaperChk", dto.PaperChk),
new SqlParameter("@InvoiceNO", dto.InvoiceNO),
new SqlParameter("@PaymentRemark", dto.PaymentRemark),
new SqlParameter("@Finance_PaymentStatus", dto.Finance_PaymentStatus),
new SqlParameter("@Finance_PaymentAmt", dto.Finance_PaymentAmt),
new SqlParameter("@Finance_NotPayReason", dto.Finance_NotPayReason),
new SqlParameter("@Finance_Constract", dto.Finance_Constract),
new SqlParameter("@Finance_SettlementChk", dto.Finance_SettlementChk),
new SqlParameter("@Finance_InvoceAmt", dto.Finance_InvoceAmt),
new SqlParameter("@Finance_InvoceAmtThis", dto.Finance_InvoceAmtThis),
new SqlParameter("@UserId", userId) };
db.Database.ExecuteSqlCommand("EXEC up_FlowOrder_U @Id,@PreTaxAmt,@InvoceAmtThis,@ProjectType,@ConstractChk,@SettlementChk,@InvoceChk,@PaperChk,@InvoiceNO,@PaymentRemark,@Finance_PaymentStatus,@Finance_PaymentAmt,@Finance_NotPayReason,@Finance_Constract,@Finance_SettlementChk,@Finance_InvoceAmt,@Finance_InvoceAmtThis,@UserId", para);
}
