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>");
}
}
