/// <summary> /// 获取合同预付的相关信息 /// </summary> void GetBlockInfo(HttpContext context) { long id = 0; if (!string.IsNullOrEmpty(context.Request.QueryString["id"]) && long.TryParse(context.Request.QueryString["id"], out id)) { var block = new ContractBlockBLL().GetBlockById(id); if (block != null) { var contract = new ContractBLL().GetContract(block.contract_id); if (contract != null) { decimal befotMoveNum = 0; if (contract.type_id == (int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.RETAINER) { befotMoveNum = Convert.ToDecimal(new DAL.crm_account_dal().GetSingle($"SELECT round(b.rate*b.quantity - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = b.id AND delete_time = 0 ),0),2) AS rate FROM ctt_contract_block b WHERE b.delete_time = 0 and b.id = {block.id} ")); } else if (contract.type_id == (int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.BLOCK_HOURS) { befotMoveNum = Convert.ToDecimal(new DAL.crm_account_dal().GetSingle($"SELECT sum(round(b.rate - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = b.id AND delete_time = 0 ),0),2)) AS rate FROM ctt_contract_block b WHERE b.delete_time = 0 and b.id ={block.id} ")); } WriteResponseJson(new { contractName = contract.name, date = block.start_date.ToString("yyyy-MM-dd") + " - " + block.end_date.ToString("yyyy-MM-dd"), befotMoveNum = befotMoveNum.ToString("#0.0000") }); } } } }
/// <summary> /// 设置预付为停用状态 /// </summary> /// <param name="context"></param> /// <param name="blockId"></param> public void SetBlockInactive(HttpContext context, long blockId) { bool result = false; result = new ContractBlockBLL().SetBlockInactive(blockId, LoginUserId); context.Response.Write(result); }
/// <summary> /// 删除合同预付 /// </summary> /// <param name="context"></param> /// <param name="blockId"></param> public void DeleteContractBlock(HttpContext context, long blockId) { bool result = false; result = new ContractBlockBLL().DeletePurchase(blockId, LoginUserId); context.Response.Write(result); }