/// <summary>
/// 比较合同和工单的采购订单信息,返回合同订单号和工单的成本未审批成本数量
/// </summary>
private void CheckContractPurchaseOrder(HttpContext context)
{
var contractId = context.Request.QueryString["contract_id"];
var purchaseOrder = context.Request.QueryString["purchase_order"];
var ticketId = context.Request.QueryString["ticket_id"];
var returnOrder = "";
int count = 0;
bool isUpdateOrder = false; // 是否需要更新采购订单
if (!string.IsNullOrEmpty(contractId) && !string.IsNullOrEmpty(purchaseOrder))
{
var thisContract = new ctt_contract_dal().FindNoDeleteById(long.Parse(contractId));
if (thisContract != null && !string.IsNullOrEmpty(thisContract.purchase_order_no))
{
returnOrder = thisContract.purchase_order_no;
if (purchaseOrder != thisContract.purchase_order_no)
{
isUpdateOrder = true;
}
}
}
if (!string.IsNullOrEmpty(ticketId))
{
var thisCost = new ctt_contract_cost_dal().GetListByTicketId(long.Parse(ticketId), $" and bill_status=0 and purchase_order_no='{purchaseOrder}'");
if (thisCost != null && thisCost.Count > 0)
{
count = thisCost.Count;
}
}
context.Response.Write(new EMT.Tools.Serialize().SerializeJson(new { isUpdateOrder = isUpdateOrder, count = count, returnOrder = returnOrder }));
}
protected List <ctt_contract_cost> noCicostList = null; // 没有配置项的项目产品
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
var taskList = new sdk_task_dal().GetProTask(thisProject.id);
if (taskList != null && taskList.Count > 0)
{
actTaskList = taskList.Where(_ => _.status_id != (int)DTO.DicEnum.TICKET_STATUS.DONE).ToList();
}
var costList = new ctt_contract_cost_dal().GetCostByProId(thisProject.id);
if (costList != null && costList.Count > 0)
{
noCicostList = costList.Where(_ => _.product_id == null).ToList();
}
if (!IsPostBack)
{
// noTempId
noTempId.DataTextField = "name";
noTempId.DataValueField = "id";
noTempId.DataSource = new sys_notify_tmpl_dal().GetTempByEvent(DicEnum.NOTIFY_EVENT.PROJECT_COMPLETED);
noTempId.DataBind();
}
}
}
catch (Exception msg)
{
Response.End();
}
}
/// <summary>
/// 删除预付
/// </summary>
/// <param name="blockId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool DeletePurchase(long blockId, long userId)
{
ctt_contract_cost_dal costDal = new ctt_contract_cost_dal();
var list = costDal.FindByBlockId(blockId);
foreach (var cost in list)
{
cost.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
cost.delete_user_id = userId;
costDal.Update(cost);
OperLogBLL.OperLogDelete <ctt_contract_cost>(cost, cost.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_COST, "删除合同预付");
}
var block = dal.FindById(blockId);
if (block == null)
{
return(false);
}
block.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
block.delete_user_id = userId;
dal.Update(block);
OperLogBLL.OperLogDelete <ctt_contract_block>(block, block.id, userId, OPER_LOG_OBJ_CATE.CONTRACT_BLOCK, "删除合同预付");
return(true);
}
/// <summary>
/// 获取单个的成本信息
/// </summary>
private void GetSinCost(HttpContext context, long cost_id)
{
var thisCost = new ctt_contract_cost_dal().FindNoDeleteById(cost_id);
if (thisCost != null)
{
context.Response.Write(new Tools.Serialize().SerializeJson(thisCost));
}
}
/// <summary>
/// 获取到合同成本信息
/// </summary>
public void GetContractCost(HttpContext context, long cid)
{
var conCost = new ctt_contract_cost_dal().FindNoDeleteById(cid);
if (conCost != null)
{
context.Response.Write(new EMT.Tools.Serialize().SerializeJson(conCost));
}
}
/// <summary>
/// 获取到成本的属性
/// </summary>
/// <param name="context"></param>
/// <param name="id"></param>
public void GetContractCostoProperty(HttpContext context, long id, string propertyName)
{
var cost = new ctt_contract_cost_dal().FindNoDeleteById(id);
if (cost != null)
{
context.Response.Write(BaseDAL <ctt_contract> .GetObjectPropertyValue(cost, propertyName));
}
}
/// <summary>
/// 根据成本状态更改销售订单状态
/// </summary>
/// <param name="cost_id"></param>
/// <param name="isDoneOrder">是否将销售订单完成</param>
/// <returns></returns>
public bool ChangeSaleOrderStatus(long cost_id, long user_id, out bool isDoneOrder)
{
isDoneOrder = false;
var thisOrder = _dal.GetOrderByCostId(cost_id);
var thisCost = new ctt_contract_cost_dal().FindNoDeleteById(cost_id);
if (thisOrder != null && thisCost != null)
{
var proList = new ctt_contract_cost_product_dal().GetListBySale(thisOrder.id);
var costList = new ctt_contract_cost_dal().GetListBySaleOrderId(thisOrder.id);
var oldOrderStatus = thisOrder.status_id;
if (proList != null && proList.Count > 0 && costList != null && costList.Count > 0)
{
if (costList.Any(_ => _.status_id == (int)DicEnum.COST_STATUS.PENDING_DELIVERY) && oldOrderStatus == (int)SALES_ORDER_STATUS.OPEN)
{
thisOrder.status_id = (int)SALES_ORDER_STATUS.IN_PROGRESS;
}
if (costList.Any(_ => _.status_id == (int)DicEnum.COST_STATUS.ALREADY_DELIVERED) && (oldOrderStatus == (int)SALES_ORDER_STATUS.OPEN || oldOrderStatus == (int)SALES_ORDER_STATUS.IN_PROGRESS))
{
thisOrder.status_id = (int)SALES_ORDER_STATUS.PARTIALLY_FULFILLED;
}
// 获取销售订单下的所有成本，所有成本下的所有成本产品 已配送的时候，进行提示 isDoneOrder = true
if (!proList.Any(_ => _.status_id != (int)CONTRACT_COST_PRODUCT_STATUS.DISTRIBUTION))
{
isDoneOrder = true;
}
}
// 如果销售订单下的产品部分已配送，且销售订单状态为“进行中”/“新建”，则将其状态置为“部分发货”
if (oldOrderStatus != thisOrder.status_id)
{
var oldOrder = _dal.FindNoDeleteById(thisOrder.id);
thisOrder.update_user_id = user_id;
thisOrder.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Update(thisOrder);
OperLogBLL.OperLogUpdate <crm_sales_order>(thisOrder, oldOrder, thisOrder.id, user_id, OPER_LOG_OBJ_CATE.SALE_ORDER, "修改销售订单状态");
}
return(true);
}
return(false);
}
/// <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="quote_item"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Insert(crm_quote_item quote_item, Dictionary <long, int> wareDic, long user_id, bool isSaleOrder = false, long?saleOrderId = null)
{
if (quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISCOUNT)
{
if (quote_item.unit_price == null || quote_item.unit_cost == null || quote_item.quantity == null || quote_item.unit_discount == null)
{
return(ERROR_CODE.PARAMS_ERROR);
}
if (string.IsNullOrEmpty(quote_item.name))
{
return(ERROR_CODE.PARAMS_ERROR);
}
}
else
{
if (string.IsNullOrEmpty(quote_item.name))
{
return(ERROR_CODE.PARAMS_ERROR);
}
if (quote_item.discount_percent == null && quote_item.unit_discount == null)
{
return(ERROR_CODE.PARAMS_ERROR);
}
}
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
return(ERROR_CODE.USER_NOT_FIND);
}
quote_item.id = _dal.GetNextIdCom();
quote_item.tax_cate_id = quote_item.tax_cate_id == 0 ? null : quote_item.tax_cate_id;
quote_item.period_type_id = quote_item.period_type_id == 0 ? null : quote_item.period_type_id;
quote_item.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
quote_item.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
quote_item.create_user_id = user_id;
quote_item.update_user_id = user_id;
_dal.Insert(quote_item);
new sys_oper_log_dal().Insert(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.QUOTE_ITEM,
oper_object_id = quote_item.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(quote_item),
remark = "保存报价项信息"
});
var oDal = new crm_opportunity_dal();
var oppo = oDal.GetOpByItemID(quote_item.id);
if (oppo != null && oppo.use_quote == 1)
{
if (quote_item.optional != 1 && quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISCOUNT && quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES)
{
decimal?changeRevenue = quote_item.quantity * ((quote_item.unit_price ?? 0) - (quote_item.unit_discount ?? 0));
decimal?changeCost = quote_item.quantity * quote_item.unit_cost;
switch (quote_item.period_type_id)
{
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.ONE_TIME:
oppo.one_time_revenue += (changeRevenue ?? 0);
oppo.one_time_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.MONTH:
oppo.monthly_revenue += (changeRevenue ?? 0);
oppo.monthly_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.QUARTER:
oppo.quarterly_revenue += (changeRevenue ?? 0);
oppo.quarterly_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.HALFYEAR:
oppo.semi_annual_revenue += (changeRevenue ?? 0);
oppo.semi_annual_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.YEAR:
oppo.yearly_revenue += (changeRevenue ?? 0);
oppo.yearly_cost += (changeCost ?? 0);
break;
default:
break;
}
// var udfDto = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.OPPORTUNITY);
// var udfValue =
OpportunityAddOrUpdateDto param = new OpportunityAddOrUpdateDto()
{
general = oppo,
udf = null,
notify = null
};
new OpportunityBLL().Update(param, user.id);
}
}
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
if (wareDic != null && wareDic.Count > 0)
{
var irDal = new ivt_reserve_dal();
var iwDal = new ivt_warehouse_dal();
foreach (var thisPageWare in wareDic)
{
var thisWareHouse = iwDal.FindNoDeleteById(thisPageWare.Key);
if (thisWareHouse != null && thisPageWare.Value != 0)
{
var thisReserve = new ivt_reserve()
{
id = irDal.GetNextIdCom(),
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
create_user_id = user_id,
update_user_id = user_id,
quote_item_id = quote_item.id,
warehouse_id = thisPageWare.Key,
quantity = thisPageWare.Value,
resource_id = thisWareHouse.resource_id,
};
irDal.Insert(thisReserve);
OperLogBLL.OperLogAdd <ivt_reserve>(thisReserve, thisReserve.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "新增库存预留");
}
}
}
}
if (isSaleOrder && saleOrderId != null && (quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.PRODUCT || quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.DEGRESSION || quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES))
{
var cccDal = new ctt_contract_cost_dal();
var costList = cccDal.GetListBySaleOrderId((long)saleOrderId);
if (costList != null && costList.Count > 0)
{
int status_id = 0;
long cost_code_id = (long)quote_item.object_id;
long?product_id = null;
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
product_id = quote_item.object_id;
status_id = (int)COST_STATUS.PENDING_PURCHASE;
var thisProduct = new ivt_product_dal().FindNoDeleteById((long)quote_item.object_id);
if (thisProduct != null)
{
cost_code_id = thisProduct.cost_code_id;
}
else
{
return(ERROR_CODE.ERROR);
}
var appSet = new SysSettingBLL().GetSetById(DTO.SysSettingEnum.CTT_COST_APPROVAL_VALUE);
if (appSet != null && !string.IsNullOrEmpty(appSet.setting_value) && thisProduct.does_not_require_procurement == 0) // 该产品走采购流程，并且价格大于设置，则带审批
{
if (((decimal)quote_item.quantity * (decimal)quote_item.unit_price) > decimal.Parse(appSet.setting_value)) // 金额超出（待审批）
{
status_id = (int)COST_STATUS.PENDING_APPROVAL;
}
}
}
else
{
status_id = (int)COST_STATUS.PENDING_DELIVERY;
}
ctt_contract_cost cost = new ctt_contract_cost()
{
id = _dal.GetNextIdCom(),
opportunity_id = costList[0].opportunity_id,
quote_item_id = quote_item.id,
cost_code_id = cost_code_id,
product_id = product_id,
name = quote_item.name,
description = quote_item.description,
date_purchased = DateTime.Now,
is_billable = 1,
bill_status = 0,
cost_type_id = (int)COST_TYPE.OPERATIONA,
status_id = status_id,
quantity = quote_item.quantity ?? 0,
unit_price = (quote_item.unit_price ?? 0) - (quote_item.unit_discount ?? 0),
unit_cost = quote_item.unit_cost,
extended_price = ((quote_item.unit_price ?? 0) - (quote_item.unit_discount ?? 0)) * quote_item.quantity,
create_user_id = user.id,
update_user_id = user.id,
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
project_id = costList[0].project_id,
contract_id = costList[0].contract_id,
task_id = costList[0].task_id,
sub_cate_id = costList[0].sub_cate_id,
};
cccDal.Insert(cost);
OperLogBLL.OperLogAdd <ctt_contract_cost>(cost, cost.id, user_id, OPER_LOG_OBJ_CATE.CONTRACT_COST, "新增成本");
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
var ccBll = new ContractCostBLL();
var irDal = new ivt_reserve_dal();
var thisPro = new ivt_product_dal().FindNoDeleteById((long)quote_item.object_id);
var thisProResList = irDal.GetListByItemId(quote_item.id);
if (thisProResList != null && thisProResList.Count > 0 && thisPro != null)
{
foreach (var thisProRes in thisProResList)
{
ccBll.AddCostProduct(cost.id, thisPro.id, thisProRes.warehouse_id, thisProRes.quantity, "", "", user.id);
irDal.SoftDelete(thisProRes, user.id);
OperLogBLL.OperLogDelete <ivt_reserve>(thisProRes, thisProRes.id, user.id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "删除产品预留");
}
ccBll.ChangCostStatus(cost.id, user_id);
}
}
}
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 编辑报价项
/// </summary>
/// <param name="quote_item"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Update(crm_quote_item quote_item, Dictionary <long, int> wareDic, long user_id, bool isSaleOrder = false, long?saleOrderId = null)
{
if (quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISCOUNT)
{
if (quote_item.unit_price == null || quote_item.unit_cost == null || quote_item.quantity == null || quote_item.unit_discount == null)
{
return(ERROR_CODE.PARAMS_ERROR);
}
if (string.IsNullOrEmpty(quote_item.name))
{
return(ERROR_CODE.PARAMS_ERROR);
}
}
else
{
if (string.IsNullOrEmpty(quote_item.name))
{
return(ERROR_CODE.PARAMS_ERROR);
}
if (quote_item.discount_percent == null && quote_item.unit_discount == null)
{
return(ERROR_CODE.PARAMS_ERROR);
}
}
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
return(ERROR_CODE.USER_NOT_FIND);
}
var old_quote_item = _dal.GetQuoteItem(quote_item.id);
int?oldPeriod = old_quote_item.period_type_id;
quote_item.oid = old_quote_item.oid;
quote_item.update_user_id = user_id;
quote_item.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
quote_item.tax_cate_id = quote_item.tax_cate_id == 0 ? null : quote_item.tax_cate_id;
_dal.Update(quote_item);
new sys_oper_log_dal().Insert(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.QUOTE_ITEM,
oper_object_id = quote_item.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old_quote_item, quote_item),
remark = "编辑报价项信息"
});
var oDal = new crm_opportunity_dal();
var oppo = oDal.GetOpByItemID(quote_item.id);
if (oppo != null && oppo.use_quote == 1)
{
if (quote_item.optional != 1 && quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISCOUNT && quote_item.type_id != (int)DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES)
{
decimal?changeRevenue = quote_item.quantity * quote_item.unit_price;
decimal?changeCost = quote_item.quantity * quote_item.unit_cost;
decimal?oldChangeRevenue = old_quote_item.quantity * ((old_quote_item.unit_price ?? 0) - (old_quote_item.unit_discount ?? 0));
decimal?oldChangeCost = old_quote_item.quantity * old_quote_item.unit_cost;
switch (oldPeriod)
{
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.ONE_TIME:
oppo.one_time_revenue = oppo.one_time_revenue - (oldChangeRevenue ?? 0);
oppo.one_time_cost = oppo.one_time_cost - (oldChangeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.MONTH:
oppo.one_time_revenue = oppo.one_time_revenue - (oldChangeRevenue ?? 0);
oppo.one_time_cost = oppo.one_time_cost - (oldChangeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.QUARTER:
oppo.one_time_revenue = oppo.one_time_revenue - (oldChangeRevenue ?? 0);
oppo.one_time_cost = oppo.one_time_cost - (oldChangeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.HALFYEAR:
oppo.one_time_revenue = oppo.one_time_revenue - (oldChangeRevenue ?? 0);
oppo.one_time_cost = oppo.one_time_cost - (oldChangeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.YEAR:
oppo.one_time_revenue = oppo.one_time_revenue - (oldChangeRevenue ?? 0);
oppo.one_time_cost = oppo.one_time_cost - (oldChangeCost ?? 0);
break;
default:
break;
}
switch (quote_item.period_type_id)
{
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.ONE_TIME:
oppo.one_time_revenue += (changeRevenue ?? 0);
oppo.one_time_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.MONTH:
oppo.monthly_revenue += (changeRevenue ?? 0);
oppo.monthly_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.QUARTER:
oppo.quarterly_revenue += (changeRevenue ?? 0);
oppo.quarterly_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.HALFYEAR:
oppo.semi_annual_revenue += (changeRevenue ?? 0);
oppo.semi_annual_cost += (changeCost ?? 0);
break;
case (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.YEAR:
oppo.yearly_revenue += (changeRevenue ?? 0);
oppo.yearly_cost += (changeCost ?? 0);
break;
default:
break;
}
// var udfDto = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.OPPORTUNITY);
// var udfValue =
OpportunityAddOrUpdateDto param = new OpportunityAddOrUpdateDto()
{
general = oppo,
udf = null,
notify = null
};
new OpportunityBLL().Update(param, user.id);
}
}
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
var irDal = new ivt_reserve_dal();
var iwDal = new ivt_warehouse_dal();
var oldReserList = irDal.GetListByItemId(quote_item.id);
if (wareDic != null && wareDic.Count > 0)
{
if (oldReserList != null && oldReserList.Count > 0)
{
foreach (var thisPageWare in wareDic)
{
var thisWareHouse = iwDal.FindNoDeleteById(thisPageWare.Key);
var thisOldReser = oldReserList.FirstOrDefault(_ => _.warehouse_id == thisPageWare.Key);
if (thisOldReser != null)
{
oldReserList.Remove(thisOldReser);
if (thisWareHouse != null)
{
if (thisPageWare.Value == 0)
{
irDal.SoftDelete(thisOldReser, user_id);
OperLogBLL.OperLogDelete <ivt_reserve>(thisOldReser, thisOldReser.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "删除库存预留");
continue;
}
if (thisOldReser.quantity != thisPageWare.Value || thisOldReser.resource_id != thisWareHouse.resource_id)
{
thisOldReser.quantity = thisPageWare.Value;
thisOldReser.resource_id = thisWareHouse.resource_id;
var thisOld = irDal.FindNoDeleteById(thisOldReser.id);
irDal.Update(thisOldReser);
OperLogBLL.OperLogUpdate <ivt_reserve>(thisOldReser, thisOld, thisOldReser.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "修改库存预留");
}
}
}
else
{
if (thisWareHouse != null && thisPageWare.Value != 0)
{
var thisReserve = new ivt_reserve()
{
id = irDal.GetNextIdCom(),
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
create_user_id = user_id,
update_user_id = user_id,
quote_item_id = quote_item.id,
warehouse_id = thisPageWare.Key,
quantity = thisPageWare.Value,
resource_id = thisWareHouse.resource_id,
};
irDal.Insert(thisReserve);
OperLogBLL.OperLogAdd <ivt_reserve>(thisReserve, thisReserve.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "新增库存预留");
}
}
}
}
else
{
foreach (var thisPageWare in wareDic)
{
var thisWareHouse = iwDal.FindNoDeleteById(thisPageWare.Key);
if (thisWareHouse != null)
{
var thisReserve = new ivt_reserve()
{
id = irDal.GetNextIdCom(),
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
create_user_id = user_id,
update_user_id = user_id,
quote_item_id = quote_item.id,
warehouse_id = thisPageWare.Key,
quantity = thisPageWare.Value,
resource_id = thisWareHouse.resource_id,
};
irDal.Insert(thisReserve);
OperLogBLL.OperLogAdd <ivt_reserve>(thisReserve, thisReserve.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "新增库存预留");
}
}
}
}
if (oldReserList != null && oldReserList.Count > 0)
{
oldReserList.ForEach(_ =>
{
irDal.SoftDelete(_, user_id);
OperLogBLL.OperLogDelete <ivt_reserve>(_, _.id, user_id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "删除库存预留");
});
}
}
if (isSaleOrder && saleOrderId != null && (quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.PRODUCT || quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.DEGRESSION || quote_item.type_id == (int)DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES))
{
var cccDal = new ctt_contract_cost_dal();
var thisCost = cccDal.GetSinBuQuoteItem(quote_item.id);
if (thisCost != null)
{
long?product_id = thisCost.product_id;
int status_id = thisCost.status_id;
long cost_code_id = thisCost.cost_code_id;
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
product_id = quote_item.object_id;
status_id = thisCost.status_id;
var thisProduct = new ivt_product_dal().FindNoDeleteById((long)quote_item.object_id);
if (thisProduct != null)
{
cost_code_id = thisProduct.cost_code_id;
}
else
{
return(ERROR_CODE.ERROR);
}
if (status_id != (int)COST_STATUS.UNDETERMINED && status_id != (int)COST_STATUS.PENDING_APPROVAL && status_id != (int)COST_STATUS.CANCELED)
{
if (thisCost.quantity != quote_item.quantity)
{
status_id = (int)COST_STATUS.PENDING_PURCHASE;
var appSet = new SysSettingBLL().GetSetById(DTO.SysSettingEnum.CTT_COST_APPROVAL_VALUE);
if (appSet != null && !string.IsNullOrEmpty(appSet.setting_value) && thisProduct.does_not_require_procurement == 0)
{
if (((decimal)quote_item.quantity * (decimal)quote_item.unit_price) > decimal.Parse(appSet.setting_value)) // 金额超出（待审批）
{
status_id = (int)COST_STATUS.PENDING_APPROVAL;
}
}
}
}
}
thisCost.product_id = product_id;
thisCost.cost_code_id = cost_code_id;
thisCost.name = quote_item.name;
thisCost.description = quote_item.description;
thisCost.unit_price = (quote_item.unit_price ?? 0) - (quote_item.unit_discount ?? 0);
thisCost.unit_cost = quote_item.unit_cost;
thisCost.quantity = quote_item.quantity;
thisCost.status_id = status_id;
var olderCost = cccDal.FindNoDeleteById(thisCost.id);
cccDal.Update(thisCost);
OperLogBLL.OperLogUpdate <ctt_contract_cost>(thisCost, olderCost, thisCost.id, user_id, OPER_LOG_OBJ_CATE.CONTRACT_COST, "修改成本");
if (quote_item.type_id == (int)QUOTE_ITEM_TYPE.PRODUCT)
{
var ccBll = new ContractCostBLL();
var irDal = new ivt_reserve_dal();
var thisPro = new ivt_product_dal().FindNoDeleteById((long)quote_item.object_id);
var thisProResList = irDal.GetListByItemId(quote_item.id);
if (thisProResList != null && thisProResList.Count > 0 && thisPro != null)
{
foreach (var thisProRes in thisProResList)
{
ccBll.AddCostProduct(thisCost.id, thisPro.id, thisProRes.warehouse_id, thisProRes.quantity, "", "", user.id);
irDal.SoftDelete(thisProRes, user.id);
OperLogBLL.OperLogDelete <ivt_reserve>(thisProRes, thisProRes.id, user.id, OPER_LOG_OBJ_CATE.WAREHOUSE_RESERVE, "删除产品预留");
}
ccBll.ChangCostStatus(thisCost.id, user_id);
}
}
}
}
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);
}
}
/// <summary>
/// 产品删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ERROR_CODE DeleteProduct(long id, long user_id, out string returnvalue)
{
returnvalue = string.Empty;
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
StringBuilder result = new StringBuilder();
result.Append("产品不能被删除，因为它被以下对象引用\n");
var opportunitylist = new crm_opportunity_dal().FindListBySql($"select * from crm_opportunity where primary_product_id={id} and delete_time=0");
var installed_productlist = new crm_installed_product_dal().FindListBySql($"select * from crm_installed_product where product_id={id} and delete_time=0");
var warehouse_productlist = new ivt_warehouse_product_dal().FindListBySql($"select * from ivt_warehouse_product where product_id={id} and delete_time=0");
var contract_costlist = new ctt_contract_cost_dal().FindListBySql($"select * from ctt_contract_cost where product_id={id} and delete_time=0");
int n = 1;
if (opportunitylist.Count > 0)
{
result.Append($"{opportunitylist.Count} 商机\n");
//foreach (var op in opportunitylist) {
// result.Append("N"+(n++)+" "+op.id + "\n");
//}
}
if (installed_productlist.Count > 0)
{
result.Append($"{installed_productlist.Count} 配置项\n");
//foreach (var op in installed_productlist)
//{
// result.Append("N" + (n++) + " " + op.id + "\n");
//}
}
if (warehouse_productlist.Count > 0)
{
result.Append($"{warehouse_productlist.Count} 库存\n");
//foreach (var op in warehouse_productlist)
//{
// result.Append("N" + (n++) + " " + op.id + "\n");
//}
}
if (contract_costlist.Count > 0)
{
result.Append($"{contract_costlist.Count} 工单\n");
//foreach (var op in contract_costlist)
//{
// result.Append("N" + (n++) + " " + op.id + "\n");
//}
}
if (contract_costlist.Count > 0 || warehouse_productlist.Count > 0 || installed_productlist.Count > 0 || opportunitylist.Count > 0)
{
returnvalue = result.ToString();
return(ERROR_CODE.EXIST);
}
var product_del = _dal.FindSignleBySql <ivt_product>($"select * from ivt_product where id={id} and delete_time=0");
if (product_del == null)
{
return(ERROR_CODE.ERROR);
}
product_del.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
product_del.delete_user_id = user.id;
if (!_dal.Update(product_del))
{
return(ERROR_CODE.ERROR);
}
//操作日志
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.PRODUCT, //
oper_object_id = product_del.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(product_del),
remark = "删除产品信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
var del = _dal.FindSignleBySql <ivt_product>($"select * from ivt_product where id={id} and delete_time=0");
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 取消配送
/// </summary>
/// <param name="costPdtIds">成本产品id</param>
/// <param name="userId"></param>
/// <returns></returns>
public string PurchaseUnShip(string costPdtIds, long userId)
{
ctt_contract_cost_product_dal cstPdtDal = new ctt_contract_cost_product_dal();
var pdtList = cstPdtDal.FindListBySql <ctt_contract_cost_product>($"select * from ctt_contract_cost_product where id in({costPdtIds})");
if (pdtList == null || pdtList.Count == 0)
{
return("");
}
ctt_contract_cost_dal costDal = new ctt_contract_cost_dal();
ivt_transfer_dal tsfDal = new ivt_transfer_dal();
ctt_contract_dal cttDal = new ctt_contract_dal();
pro_project_dal proDal = new pro_project_dal();
sdk_task_dal tskDal = new sdk_task_dal();
ivt_warehouse_product_sn_dal lctPdtSnDal = new ivt_warehouse_product_sn_dal();
ivt_transfer_sn_dal tsfSnDal = new ivt_transfer_sn_dal();
foreach (var pdt in pdtList)
{
// 修改成本产品状态
var pdtOld = cstPdtDal.FindById(pdt.id);
pdt.status_id = (int)DicEnum.CONTRACT_COST_PRODUCT_STATUS.PENDING_DISTRIBUTION;
pdt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
pdt.shipping_time = null;
pdt.update_user_id = userId;
cstPdtDal.Update(pdt);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ctt_contract_cost_product>(pdtOld, pdt), pdt.id, userId, DicEnum.OPER_LOG_OBJ_CATE.CTT_CONTRACT_COST_PRODUCT, "成本产品配送");
// 修改成本状态
var cost = costDal.FindById(pdt.contract_cost_id);
if (cost.status_id == (int)DicEnum.COST_STATUS.ALREADY_DELIVERED)
{
var costOld = costDal.FindById(pdt.contract_cost_id);
cost.status_id = (int)DicEnum.COST_STATUS.PENDING_DELIVERY;
cost.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
cost.update_user_id = userId;
costDal.Update(cost);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ctt_contract_cost>(costOld, cost), cost.id, userId, DicEnum.OPER_LOG_OBJ_CATE.CONTRACT_COST, "取消配送修改成本状态");
}
// 新建库存转移信息
ivt_transfer tsf = new ivt_transfer();
tsf.id = tsfDal.GetNextIdCom();
tsf.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
tsf.update_user_id = userId;
tsf.create_time = tsf.update_time;
tsf.create_user_id = userId;
tsf.type_id = (int)DicEnum.INVENTORY_TRANSFER_TYPE.PROJECT;
tsf.product_id = (long)cost.product_id;
tsf.quantity = 0 - pdt.quantity;
if (cost.contract_id != null)
{
tsf.to_account_id = cttDal.FindById((long)cost.contract_id).account_id;
}
else if (cost.project_id != null)
{
tsf.to_account_id = proDal.FindById((long)cost.project_id).account_id;
}
else if (cost.task_id != null)
{
tsf.to_account_id = tskDal.FindById((long)cost.task_id).account_id;
}
tsf.to_contract_id = cost.contract_id;
tsf.to_project_id = cost.project_id;
tsf.to_task_id = cost.task_id;
tsf.from_warehouse_id = (long)pdt.warehouse_id;
tsfDal.Insert(tsf);
OperLogBLL.OperLogAdd <ivt_transfer>(tsf, tsf.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_TRANSFER, "取消配送新建库存转移");
// 保存库存数修改
var lctPdt = dal.FindSignleBySql <ivt_warehouse_product>($"select * from ivt_warehouse_product where product_id={cost.product_id} and warehouse_id={(long)pdt.warehouse_id} and delete_time=0");
if (lctPdt != null)
{
var lctPdtOld = dal.FindById(lctPdt.id);
lctPdt.quantity = lctPdt.quantity + pdt.quantity;
lctPdt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
lctPdt.update_user_id = userId;
dal.Update(lctPdt);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ivt_warehouse_product>(lctPdtOld, lctPdt), lctPdt.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM, "修改库存产品库存数");
var sns = costDal.FindListBySql <string>($"select sn from ctt_contract_cost_product_sn where contract_cost_product_id={pdt.id} and delete_time=0");
if (sns == null || sns.Count == 0)
{
continue;
}
foreach (var sn in sns)
{
ivt_warehouse_product_sn lctPdtSn = new ivt_warehouse_product_sn();
lctPdtSn.id = lctPdtSnDal.GetNextIdCom();
lctPdtSn.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
lctPdtSn.create_user_id = userId;
lctPdtSn.update_time = lctPdtSn.create_time;
lctPdtSn.update_user_id = userId;
lctPdtSn.warehouse_product_id = lctPdt.id;
lctPdtSn.sn = sn;
lctPdtSnDal.Insert(lctPdtSn);
OperLogBLL.OperLogAdd <ivt_warehouse_product_sn>(lctPdtSn, lctPdtSn.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_SN, "取消配送产品新增库存产品串号");
ivt_transfer_sn tsfSn = new ivt_transfer_sn();
tsfSn.id = tsfSnDal.GetNextIdCom();
tsfSn.sn = sn;
tsfSn.transfer_id = tsf.id;
tsfSn.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
tsfSn.create_user_id = userId;
tsfSn.update_time = tsfSn.create_time;
tsfSn.update_user_id = userId;
tsfSnDal.Insert(tsfSn);
OperLogBLL.OperLogAdd <ivt_transfer_sn>(tsfSn, tsfSn.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_TRANSFER_SN, "取消配送产品新增转移产品串号");
}
}
}
return("");
}
/// <summary>
/// 配送
/// </summary>
/// <param name="costPdtIds">成本产品id</param>
/// <param name="isEditSaleOrder">是否修改销售订单状态</param>
/// <param name="userId"></param>
/// <returns></returns>
public string PurchaseShip(string costPdtIds, bool isEditSaleOrder, long userId)
{
ctt_contract_cost_product_dal cstPdtDal = new ctt_contract_cost_product_dal();
var pdtList = cstPdtDal.FindListBySql <ctt_contract_cost_product>($"select * from ctt_contract_cost_product where id in({costPdtIds})");
if (pdtList == null || pdtList.Count == 0)
{
return("");
}
foreach (var pdt in pdtList)
{
if (pdt.status_id != (int)DicEnum.CONTRACT_COST_PRODUCT_STATUS.PENDING_DISTRIBUTION)
{
return("状态为“待配送”的成本产品才能配送");
}
}
ctt_contract_cost_dal costDal = new ctt_contract_cost_dal();
ivt_transfer_dal tsfDal = new ivt_transfer_dal();
ctt_contract_dal cttDal = new ctt_contract_dal();
pro_project_dal proDal = new pro_project_dal();
sdk_task_dal tskDal = new sdk_task_dal();
ivt_warehouse_product_sn_dal lctPdtSnDal = new ivt_warehouse_product_sn_dal();
ivt_transfer_sn_dal tsfSnDal = new ivt_transfer_sn_dal();
foreach (var pdt in pdtList)
{
var pdtOld = cstPdtDal.FindById(pdt.id);
pdt.status_id = (int)DicEnum.CONTRACT_COST_PRODUCT_STATUS.DISTRIBUTION;
pdt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
pdt.shipping_time = pdt.update_time;
pdt.update_user_id = userId;
cstPdtDal.Update(pdt);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ctt_contract_cost_product>(pdtOld, pdt), pdt.id, userId, DicEnum.OPER_LOG_OBJ_CATE.CTT_CONTRACT_COST_PRODUCT, "成本产品配送");
var cost = costDal.FindById(pdt.contract_cost_id);
var cnt = dal.FindSignleBySql <int>($"select count(0) from ctt_contract_cost_product where contract_cost_id={pdt.contract_cost_id} and status_id<>{(int)DicEnum.CONTRACT_COST_PRODUCT_STATUS.DISTRIBUTION} and delete_time=0");
if (cnt == 0) // 产品全部已配送，修改成本状态
{
var costOld = costDal.FindById(pdt.contract_cost_id);
cost.status_id = (int)DicEnum.COST_STATUS.ALREADY_DELIVERED;
cost.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
cost.update_user_id = userId;
costDal.Update(cost);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ctt_contract_cost>(costOld, cost), cost.id, userId, DicEnum.OPER_LOG_OBJ_CATE.CONTRACT_COST, "修改成本状态已配送");
}
ivt_transfer transfer = new ivt_transfer();
transfer.id = tsfDal.GetNextIdCom();
transfer.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
transfer.create_user_id = userId;
transfer.update_time = transfer.create_time;
transfer.update_user_id = userId;
transfer.product_id = (long)cost.product_id;
transfer.type_id = (int)DicEnum.INVENTORY_TRANSFER_TYPE.PROJECT;
transfer.from_warehouse_id = (long)pdt.warehouse_id;
transfer.quantity = pdt.quantity;
if (cost.contract_id != null)
{
transfer.to_account_id = cttDal.FindById((long)cost.contract_id).account_id;
}
else if (cost.project_id != null)
{
transfer.to_account_id = proDal.FindById((long)cost.project_id).account_id;
}
else if (cost.task_id != null)
{
transfer.to_account_id = tskDal.FindById((long)cost.task_id).account_id;
}
transfer.to_contract_id = cost.contract_id;
transfer.to_project_id = cost.project_id;
transfer.to_task_id = cost.task_id;
tsfDal.Insert(transfer);
OperLogBLL.OperLogAdd <ivt_transfer>(transfer, transfer.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_TRANSFER, "产品配送转移库存");
// 保存库存数修改
var lctPdt = dal.FindSignleBySql <ivt_warehouse_product>($"select * from ivt_warehouse_product where product_id={cost.product_id} and warehouse_id={(long)pdt.warehouse_id} and delete_time=0");
if (lctPdt != null)
{
var lctPdtOld = dal.FindById(lctPdt.id);
lctPdt.quantity = lctPdt.quantity - pdt.quantity;
lctPdt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
lctPdt.update_user_id = userId;
dal.Update(lctPdt);
OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <ivt_warehouse_product>(lctPdtOld, lctPdt), lctPdt.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM, "修改库存产品库存数");
var sns = costDal.FindListBySql <string>($"select sn from ctt_contract_cost_product_sn where contract_cost_product_id={pdt.id} and delete_time=0");
if (sns == null || sns.Count == 0)
{
continue;
}
foreach (var sn in sns)
{
var lctPdtSn = lctPdtSnDal.FindSignleBySql <ivt_warehouse_product_sn>($"select * from ivt_warehouse_product_sn where sn='{sn}' and warehouse_product_id={lctPdt.id}");
lctPdtSn.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
lctPdtSn.delete_user_id = userId;
lctPdtSnDal.Update(lctPdtSn);
OperLogBLL.OperLogDelete <ivt_warehouse_product_sn>(lctPdtSn, lctPdtSn.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_SN, "配送产品删除库存产品串号");
ivt_transfer_sn tsfSn = new ivt_transfer_sn();
tsfSn.id = tsfSnDal.GetNextIdCom();
tsfSn.sn = sn;
tsfSn.transfer_id = transfer.id;
tsfSn.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
tsfSn.create_user_id = userId;
tsfSn.update_time = tsfSn.create_time;
tsfSn.update_user_id = userId;
tsfSnDal.Insert(tsfSn);
OperLogBLL.OperLogAdd <ivt_transfer_sn>(tsfSn, tsfSn.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_TRANSFER_SN, "配送产品新增转移产品串号");
}
}
}
return("");
}
