protected void SaveClose_Click(object sender, EventArgs e) { ctt_contract_block blk = new ctt_contract_block(); blk.id = long.Parse(Request.Form["id"]); blk.start_date = DateTime.Parse(Request.Form["startDate"]); blk.end_date = DateTime.Parse(Request.Form["endDate"]); if (string.IsNullOrEmpty(Request.Form["amount"])) { blk.rate = decimal.Parse(Request.Form["hourlyRate"]); blk.quantity = decimal.Parse(Request.Form["hours"]); } else { blk.rate = decimal.Parse(Request.Form["amount"]); blk.quantity = 1; } blk.status_id = sbyte.Parse(Request.Form["rdStatus"]); blk.date_purchased = DateTime.Parse(Request.Form["datePurchased"]); blk.payment_number = Request.Form["paymentNum"]; if (string.IsNullOrEmpty(paymentType.SelectedValue)) { blk.payment_type_id = null; } else { blk.payment_type_id = int.Parse(paymentType.SelectedValue); } blk.description = Request.Form["note"]; bll.EditPurchase(blk, GetLoginUserId()); blockId = blk.id; block = bll.GetBlockById(blk.id); contract = new ContractBLL().GetContract(block.contract_id); if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.BLOCK_HOURS) { blocktypeName = "时间"; } else if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.RETAINER) { blocktypeName = "费用"; } else if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.PER_TICKET) { blocktypeName = "事件"; } Response.Write("<script>alert('修改预付成功!');window.close();self.opener.location.reload();</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = Request.QueryString["id"]; if (!long.TryParse(id, out blockId)) { Response.Close(); return; } block = bll.GetBlockById(blockId); contract = new ContractBLL().GetContract(block.contract_id); if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.BLOCK_HOURS) { blocktypeName = "时间"; } else if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.RETAINER) { blocktypeName = "费用"; } else if (contract.type_id == (int)DicEnum.CONTRACT_TYPE.PER_TICKET) { blocktypeName = "事件"; } var dic = bll.GetField(); paymentType.DataValueField = "val"; paymentType.DataTextField = "show"; paymentType.DataSource = dic.FirstOrDefault(_ => _.Key == "paymentType").Value; paymentType.DataBind(); paymentType.Items.Insert(0, new ListItem() { Value = "", Text = " " }); if (block.payment_type_id != null) { paymentType.SelectedValue = ((int)block.payment_type_id).ToString(); } } }
/// <summary> /// 修改预付 /// </summary> /// <param name="blockEdit"></param> /// <param name="userId"></param> public void EditPurchase(ctt_contract_block blockEdit, long userId) { ctt_contract_block block = dal.FindById(blockEdit.id); ctt_contract_block blockOld = dal.FindById(blockEdit.id); block.start_date = blockEdit.start_date; block.end_date = blockEdit.end_date; block.rate = blockEdit.rate; block.quantity = blockEdit.quantity; block.status_id = blockEdit.status_id; block.date_purchased = blockEdit.date_purchased; block.payment_number = blockEdit.payment_number; block.payment_type_id = blockEdit.payment_type_id; block.description = blockEdit.description; block.update_time = EMT.Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); block.update_user_id = userId; dal.Update(block); OperLogBLL.OperLogUpdate <ctt_contract_block>(block, blockOld, block.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_BLOCK, "修改预付"); ctt_contract_cost_dal costDal = new ctt_contract_cost_dal(); var list = costDal.FindByBlockId(block.id); foreach (var cost in list) { var costEdit = costDal.FindById(cost.id); costEdit.quantity = block.quantity; costEdit.unit_price = block.rate; costEdit.date_purchased = block.date_purchased; costEdit.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); costEdit.update_user_id = userId; costDal.Update(costEdit); OperLogBLL.OperLogUpdate <ctt_contract_cost>(costEdit, cost, costEdit.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_COST, "修改成本"); } }
/// <summary> /// /撤销成本审批 /// </summary> /// <param name="user_id"></param> /// <param name="ids"></param> /// <returns></returns> public ERROR_CODE Revoke_CHARGES(long user_id, string ids, out string re) { re = string.Empty; var user = UserInfoBLL.GetUserInfo(user_id); if (user == null) { // 查询不到用户,用户丢失 return(ERROR_CODE.USER_NOT_FIND); } var cadDal = new crm_account_deduction_dal(); var sweDal = new sdk_work_entry_dal(); crm_account_deduction cad = new crm_account_deduction(); ctt_contract_block ccb = new ctt_contract_block(); ctt_contract_cost ccc = new ctt_contract_cost(); ctt_contract_cost_dal ccc_dal = new ctt_contract_cost_dal(); ctt_contract_block_dal ccb_dal = new ctt_contract_block_dal(); StringBuilder returnvalue = new StringBuilder(); //该条目已经生成发票(发票ID:发票ID),请先作废该发票 if (!string.IsNullOrEmpty(ids)) { var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); var idList = ids.Split(','); foreach (var id in idList) { var oldcad = cad = GetAccountDed(long.Parse(id)); if (cad != null) { if (cad.object_id != null) { var cadList = cadDal.GetListByObjectId((long)cad.object_id); if (cadList != null && cadList.Count > 0) { foreach (var thisCad in cadList) { if (thisCad.invoice_id != null) { var ci = new ctt_invoice_dal().FindNoDeleteById((long)thisCad.invoice_id); if (ci != null && ci.is_voided != 1) { returnvalue.Append(id + "条目已经生成发票(发票ID:" + thisCad.invoice_id + "),请先作废该发票\n"); } } } } if (string.IsNullOrEmpty(returnvalue.ToString())) { if (cadList != null && cadList.Count > 0) { cadList.ForEach(_ => { RecoveryBlock(_.id, user_id); cadDal.SoftDelete(_, user_id); OperLogBLL.OperLogDelete <crm_account_deduction>(_, _.id, user_id, OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION, "删除审批并提交条目"); }); var oldccc = ccc = ccc_dal.FindNoDeleteById((long)cad.object_id); if (ccc != null) { // var oldSwe = sweDal.FindNoDeleteById((long)cad.object_id); ccc.update_time = timeNow; ccc.update_user_id = user.id; ccc.bill_status = 0; ccc.extended_price = ccc.unit_price * ccc.quantity; ccc_dal.Update(ccc); OperLogBLL.OperLogUpdate <ctt_contract_cost>(ccc, oldccc, ccc.id, user_id, OPER_LOG_OBJ_CATE.CONTRACT_COST, "修改合同成本"); } } } else { re = returnvalue.ToString(); } } } #region 原有的撤销成本审批相关逻辑 //if (cad.invoice_id != null) //{ // var ci = new ctt_invoice_dal().FindNoDeleteById((long)cad.invoice_id); // if (ci.is_voided != 1) // { // returnvalue.Append(id + "条目已经生成发票(发票ID:" + cad.invoice_id + "),请先作废该发票\n"); // } //} //else //{ // cad.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); // cad.delete_user_id = user.id; // var add1_log = new sys_oper_log() // { // user_cate = "用户", // user_id = (int)user.id, // name = user.name, // phone = user.mobile == null ? "" : user.mobile, // oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), // oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION, // oper_object_id = cad.id,// 操作对象id // oper_type_id = (int)OPER_LOG_TYPE.DELETE, // oper_description = cad_dal.CompareValue(oldcad, cad), // remark = "删除审批并提交" // }; // 创建日志 // new sys_oper_log_dal().Insert(add1_log); // 插入日志 // if (!cad_dal.Update(cad)) // { // return ERROR_CODE.ERROR; // } // //合同成本 // var oldccc = ccc = ccc_dal.FindSignleBySql<ctt_contract_cost>($"select * from ctt_contract_cost where id={cad.object_id} and delete_time=0"); // if (ccc != null) // { // ccc.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); // ccc.update_user_id = user.id; // ccc.bill_status = 0; // ccc.extended_price = ccc.unit_price * ccc.quantity; // var add_log = new sys_oper_log() // { // user_cate = "用户", // user_id = (int)user.id, // name = user.name, // phone = user.mobile == null ? "" : user.mobile, // oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), // oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_COST, // oper_object_id = ccc.id,// 操作对象id // oper_type_id = (int)OPER_LOG_TYPE.UPDATE, // oper_description = cad_dal.CompareValue(oldccc, ccc), // remark = "修改合同成本" // }; // 创建日志 // new sys_oper_log_dal().Insert(add_log); // 插入日志 // if (!ccc_dal.Update(ccc)) // { // return ERROR_CODE.ERROR; // } // if (cad.contract_block_id != null) // { // //合同预付 // var oldccb = ccb = ccb_dal.FindSignleBySql<ctt_contract_block>($" select * from ctt_contract_block where id={cad.contract_block_id} and delete_time=0"); // if (ccb != null) // { // ccb.is_billed = 0; // ccb.status_id = 1; // ccb.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); // ccb.update_user_id = user.id; // var add3_log = new sys_oper_log() // { // user_cate = "用户", // user_id = (int)user.id, // name = user.name, // phone = user.mobile == null ? "" : user.mobile, // oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), // oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_BLOCK, // oper_object_id = ccc.id,// 操作对象id // oper_type_id = (int)OPER_LOG_TYPE.UPDATE, // oper_description = cad_dal.CompareValue(oldccb, ccb), // remark = "修改合同预付" // }; // 创建日志 // new sys_oper_log_dal().Insert(add3_log); // 插入日志 // if (!ccb_dal.Update(ccb)) // { // return ERROR_CODE.ERROR; // } // } // } // } //} #endregion } } if (!string.IsNullOrEmpty(returnvalue.ToString())) { re = returnvalue.ToString(); return(ERROR_CODE.EXIST); } return(ERROR_CODE.SUCCESS); }
/// <summary> /// 新增预付 /// </summary> /// <param name="dto"></param> /// <param name="userId"></param> public bool NewPurchase(ContractBlockAddDto dto, long userId) { ctt_contract_cost_dal costDal = new ctt_contract_cost_dal(); string blkName = ""; if (dto.type == 1) { blkName = "时间"; } if (dto.type == 2) { blkName = "费用"; } if (dto.type == 3) { blkName = "事件"; } if (dto.isMonthly) // 每月计费 { // 检查必填项 if (dto.type == 2) { if (dto.amount == null) { return(false); } } else { if (dto.hours == null || dto.hourlyRate == null) { return(false); } } if (dto.endDate == null && dto.purchaseNum == null) { return(false); } // 检查起止日期和计费周期 if (dto.endDate != null && (DateTime)dto.endDate < dto.startDate) { return(false); } if (dto.endDate == null && dto.purchaseNum <= 0) { return(false); } DateTime dtBlockStart = dto.startDate; // 一个预付周期开始时间 DateTime dtBlockEnd = DateTime.MinValue; // 所有预付周期结束时间 if (dto.endDate != null) { dtBlockEnd = (DateTime)dto.endDate; } int blockNums = 0; // 已处理新增预付时间 while (true) { if (dto.endDate != null) // 按最后一个周期的结束时间判断 { if (dtBlockStart > dtBlockEnd) { break; } } else // 按周期个数判断 { if (blockNums >= (int)dto.purchaseNum) { break; } } // 新增预付 ctt_contract_block block = new ctt_contract_block(); block.id = dal.GetNextIdCom(); block.contract_id = dto.contractId; block.is_billed = 0; block.is_paid = 0; block.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); block.create_user_id = userId; block.update_user_id = userId; block.update_time = block.create_time; block.start_date = dtBlockStart; block.end_date = dtBlockStart.AddMonths(1).AddDays(-1); if (dto.type == 1 || dto.type == 3) { block.quantity = ((decimal)dto.hours) * 10000 / 10000; block.rate = ((decimal)dto.hourlyRate) * 100 / 100; } else if (dto.type == 2) { block.quantity = 1; block.rate = (decimal)dto.amount; } if ((bool)dto.firstPart && blockNums == 0) // 首月部分的处理 { block.end_date = new DateTime(dtBlockStart.Year, dtBlockStart.Month + 1, 1).AddDays(-1); // 结束日期为开始日期同月份的最后一天 /* 修改:所有周期的计费按一整周期算 */ //if (dto.type != 2) // block.quantity = (decimal)((int)(((decimal)(block.end_date.Day - block.start_date.Day + 1) / block.end_date.Day) * ((decimal)dto.hours) * 10000)) / 10000; // 预付数量按照天数比例计算 //else // block.rate = (decimal)((int)(((decimal)(block.end_date.Day - block.start_date.Day + 1) / block.end_date.Day) * block.rate * 10000)) / 10000; } if (dto.endDate != null && ((DateTime)dto.endDate) < block.end_date) // 设置了结束时间的处理 { block.end_date = (DateTime)dto.endDate; /* 修改:所有周期的计费按一整周期算 */ //if (dto.type != 2) // block.quantity = ((decimal)((block.end_date - block.start_date).Days + 1) // / DateTime.DaysInMonth(block.start_date.Year, block.start_date.Month)) // * ((decimal)dto.hours) * 10000 / 10000; // 预付数量按照天数比例计算 //else // block.rate = (decimal)((int)(((decimal)((block.end_date - block.start_date).Days + 1) // / DateTime.DaysInMonth(block.start_date.Year, block.start_date.Month)) * block.rate * 10000)) / 10000; } dtBlockStart = block.end_date.AddDays(1); // 下一周期的开始日期 ++blockNums; // 已处理周期数加1 // 可以延期 if (dto.delayDays != null && dto.delayDays > 0) { block.end_date = block.end_date.AddDays((int)dto.delayDays); } block.status_id = (sbyte)(dto.status ? 1 : 0); block.date_purchased = block.start_date; block.payment_number = dto.paymentNum; block.payment_type_id = dto.paymentType; block.description = dto.note; dal.Insert(block); OperLogBLL.OperLogAdd <ctt_contract_block>(block, block.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_BLOCK, $"新增合同预付{blkName}"); // 新增合同成本 ctt_contract_cost cost = new ctt_contract_cost(); cost.id = costDal.GetNextIdCom(); cost.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); cost.create_user_id = userId; cost.update_time = cost.create_time; cost.update_user_id = userId; cost.contract_block_id = block.id; cost.contract_id = dto.contractId; List <d_cost_code> costCode; if (dto.type == 1) { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.BLOCK_PURCHASE); } else if (dto.type == 2) { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.RETAINER_PURCHASE); } else { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.TICKET_PURCHASE); } if (costCode == null || costCode.Count == 0) { throw new Exception("字典项缺失"); } cost.cost_code_id = costCode[0].id; cost.name = $"预付{blkName}[{block.start_date.ToShortDateString()}-{block.end_date.ToShortDateString()}]"; cost.date_purchased = block.date_purchased; cost.cost_type_id = (int)COST_TYPE.OPERATIONA; cost.status_id = (int)COST_STATUS.UNDETERMINED; cost.bill_status = 0; cost.is_billable = 1; cost.quantity = block.quantity; cost.unit_cost = 0; cost.unit_price = block.rate; cost.contract_block_id = block.id; cost.extended_price = (cost.quantity * cost.unit_price) * 100 / 100; if (dto.type == 1) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.PREPAID_TIME; } else if (dto.type == 2) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.PREPAID_COST; } else if (dto.type == 3) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.EVENTS; } costDal.Insert(cost); OperLogBLL.OperLogAdd <ctt_contract_cost>(cost, cost.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_COST, "新增合同成本"); } return(true); } else // 一次计费 { if (dto.type == 2) { if (dto.amount == null) { return(false); } } else { if (dto.hours == null || dto.hourlyRate == null) { return(false); } } if (dto.endDate == null) // 检查必填项 { return(false); } if ((DateTime)dto.endDate < dto.startDate) // 检查起止日期和计费周期 { return(false); } // 新增预付 ctt_contract_block block = new ctt_contract_block(); block.id = dal.GetNextIdCom(); block.contract_id = dto.contractId; block.is_billed = 0; block.is_paid = 0; block.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); block.create_user_id = userId; block.update_user_id = userId; block.update_time = block.create_time; block.start_date = dto.startDate; block.end_date = (DateTime)dto.endDate; if (dto.type == 1 || dto.type == 3) { block.quantity = ((decimal)dto.hours) * 10000 / 10000; block.rate = ((decimal)dto.hourlyRate) * 100 / 100; } else if (dto.type == 2) { block.quantity = 1; block.rate = (decimal)dto.amount; } block.status_id = (sbyte)(dto.status ? 1 : 0); block.date_purchased = dto.datePurchased; block.payment_number = dto.paymentNum; block.payment_type_id = dto.paymentType; block.description = dto.note; dal.Insert(block); OperLogBLL.OperLogAdd <ctt_contract_block>(block, block.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_BLOCK, $"新增合同预付{blkName}"); // 新增合同成本 ctt_contract_cost cost = new ctt_contract_cost(); cost.id = costDal.GetNextIdCom(); cost.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); cost.create_user_id = userId; cost.update_time = cost.create_time; cost.update_user_id = userId; cost.contract_block_id = block.id; cost.contract_id = dto.contractId; List <d_cost_code> costCode; if (dto.type == 1) { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.BLOCK_PURCHASE); } else if (dto.type == 2) { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.RETAINER_PURCHASE); } else { costCode = new d_cost_code_dal().GetListCostCode((int)COST_CODE_CATE.TICKET_PURCHASE); } if (costCode == null || costCode.Count == 0) { throw new Exception("字典项缺失"); } cost.cost_code_id = costCode[0].id; cost.name = $"预付{blkName}[{block.start_date.ToShortDateString()}-{block.end_date.ToShortDateString()}]"; cost.date_purchased = block.date_purchased; cost.cost_type_id = (int)COST_TYPE.OPERATIONA; cost.status_id = (int)COST_STATUS.UNDETERMINED; cost.bill_status = 0; cost.is_billable = 1; cost.quantity = block.quantity; cost.unit_cost = 0; cost.unit_price = block.rate; cost.contract_block_id = block.id; cost.extended_price = (cost.quantity * cost.unit_price) * 100 / 100; if (dto.type == 1) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.PREPAID_TIME; } else if (dto.type == 2) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.PREPAID_COST; } else if (dto.type == 3) { cost.sub_cate_id = (int)DicEnum.BILLING_ENTITY_SUB_TYPE.EVENTS; } costDal.Insert(cost); OperLogBLL.OperLogAdd <ctt_contract_cost>(cost, cost.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_COST, "新增合同成本"); return(true); } }
protected decimal befotMoveNum; // 转移前的数量 (余额) protected void Page_Load(object sender, EventArgs e) { long id = 0; if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out id)) { deduction = invBll.GetDeduction(id); } if (deduction != null) { vItem = new DAL.v_widget_posted_item_dal().FindById(deduction.id); if (deduction.contract_id != null) { contract = new ContractBLL().GetContract((long)deduction.contract_id); } if (deduction.contract_block_id != null) { block = new ContractBlockBLL().GetBlockById((long)deduction.contract_block_id); } if (block != null) { contract = new ContractBLL().GetContract(block.contract_id); } string contractTypeSql = string.Empty; // 合同类型过滤 if (contract?.type_id == (int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.RETAINER) { contractTypeSql = $" and cc.type_id = {(int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.RETAINER} "; dedNum = deduction.extended_price; if (block != null) { 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) { contractTypeSql = $" and cc.type_id = {(int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.BLOCK_HOURS} "; dedNum = deduction.quantity; if (block != null) { 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} ")); } } var dtoList = new CompanyBLL().GetBySql <MoveDeductionDto>($@"SELECT ccb.id,ccb.start_date,ccb.end_date,cc.id as contract_id,cc.name as contract_name, ca.id as account_id, ca.name as account_name,ccb.status_id, case cc.type_id when {(int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.RETAINER} then round(ccb.rate*ccb.quantity - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = ccb.id AND delete_time = 0 ),0),2) when {(int)EMT.DoneNOW.DTO.DicEnum.CONTRACT_TYPE.BLOCK_HOURS} then round(ccb.rate - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = ccb.id AND delete_time = 0 ),0),2) else 0 end as balance from ctt_contract_block ccb INNER JOIN ctt_contract cc on ccb.contract_id = cc.id INNER JOIN crm_account ca on cc.account_id = ca.id where ccb.delete_time =0 and cc.delete_time =0 and (cc.account_id = {deduction.account_id} or ca.parent_id = {deduction.account_id}) {contractTypeSql} and (round(ccb.rate*ccb.quantity - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = ccb.id AND delete_time = 0 ),0),2) >0 or round(ccb.rate - ifnull((SELECT sum(extended_price)FROM crm_account_deduction WHERE contract_block_id = ccb.id AND delete_time = 0 ),0),2)>0)" ); if (dtoList != null && dtoList.Count > 0) { dtoList = dtoList.OrderBy(_ => _.start_date).ToList(); dic = dtoList.GroupBy(_ => _.contract_id).ToDictionary(_ => _.Key, _ => _.ToList()); } } else { Response.Write("<script>alert('未获取到相关条目!');window.close();</script>"); } }
protected void Page_Load(object sender, EventArgs e) { long id = 0; if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out id)) { deduction = invBll.GetDeduction(id); } //if (deduction == null) //{ // Response.Write("<script>alert('未获取到相关条目');window.close();</script>"); //} long blockId = 0; if (!string.IsNullOrEmpty(Request.QueryString["blockId"]) && long.TryParse(Request.QueryString["blockId"], out blockId)) { block = new ContractBlockBLL().GetBlockById(blockId); } if (deduction != null) { vItem = new DAL.v_widget_posted_item_dal().FindById(deduction.id); rate = vItem?.rate; account = new CompanyBLL().GetCompany(deduction.account_id); if (deduction.contract_id != null) { contract = new ContractBLL().GetContract((long)deduction.contract_id); } if (deduction.task_id != null) { task = new TicketBLL().GetTask((long)deduction.task_id); } labour = new WorkEntryBLL().GetEntryById((long)deduction.object_id); if (vItem?.tax_category_id != null && vItem?.tax_region_id != null) { var thisTax = new DAL.d_tax_region_cate_dal().GetSingleTax((long)vItem?.tax_region_id, (long)vItem?.tax_category_id); taxRate = thisTax?.total_effective_tax_rate; } if (vItem?.resource_id != null) { resource = new UserResourceBLL().GetResourceById((long)vItem.resource_id); } if (deduction.contract_block_id != null) { dedBlock = new ContractBlockBLL().GetBlockById((long)deduction.contract_block_id); } } if (block != null) { contract = new ContractBLL().GetContract(block.contract_id); if (contract != null) { account = new CompanyBLL().GetCompany(contract.account_id); contractType = new GeneralBLL().GetSingleGeneral(contract.type_id); } } if (block == null && deduction == null) { Response.Write("<script>alert('未获取到相关条目');window.close();</script>"); } }