public void DoAfterFlowSucceed(string formObj, flow_apply apply)
{
o = JObject.Parse(formObj);
string cardNo = (string)o["applier_num"];
string agentNumber = (string)o["agent_man"];
DateTime beginTime = (DateTime)o["from_date"];
DateTime endTime = (DateTime)o["to_date"];
//如果申请了撤销，最后审批成功，需要将apply的success状态改为false，表示此请假流程是无效的
if (apply.user_abort == true)
{
apply.success = false;
}
//如果有代理人，插入代理表
if (!string.IsNullOrEmpty(agentNumber))
{
ei_workAgent agent = new ei_workAgent();
agent.agent_number = agentNumber;
agent.emp_number = cardNo;
agent.begin_time = beginTime;
agent.end_time = endTime;
db.ei_workAgent.InsertOnSubmit(agent);
db.SubmitChanges();
}
}
public string GetThirdAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string salaryType = (string)o["salary_type"];
string depName = (string)o["dep_name"];
if ("月薪".Equals(salaryType))
{
if (depName.Contains("惠州"))
{
return(string.Join(",", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "AH审批" && f.relate_text == "惠州月薪").Select(f => f.relate_value).ToArray())); //AH
}
else if (depName.Contains("惠州仁寿"))
{
return(string.Join(",", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "AH审批" && f.relate_text == "光电仁寿月薪").Select(f => f.relate_value).ToArray())); //AH
}
else
{
return(string.Join(",", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "AH审批" && f.relate_text == "汕尾月薪").Select(f => f.relate_value).ToArray())); //AH
}
}
else if ("计件".Equals(salaryType))
{
return((string)o["produce_minister_num"]); //生产部长
}
else
{
return("");
}
}
//管理部会签
public string managementCountersign(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string deptName = (string)o["dept_name"];
string company = (string)o["company"];
string classification = (string)o["classification"];
bool isShareFee = (bool)o["is_share_fee"];
var result = (from r in db.flow_auditorRelation
where r.bill_type == BILLTYPE &&
r.relate_name == "项目大类" &&
r.relate_text == classification
select r.relate_value).ToList();
//加入部门总经理
result.AddRange(deptManagementAuditor(apply, formJson).Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries));
//分摊部门的总经理也要加入会签
if (isShareFee)
{
result.AddRange(((string)o["share_fee_managers"]).Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries));
}
//2021-04-14 仁寿的需要加上刘蜀鹏审批
if (deptName.Contains("仁寿"))
{
result.Add("171026058");
}
return(string.Join(";", result.Distinct().ToList()));
}
//项目小类负责人验收
public string projectTypeAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string projectType = (string)o["project_type"];
return(string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "项目小类" && f.relate_text == projectType).Select(f => f.relate_value).ToArray()));
}
//采购部审核
public string buyerAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string company = (string)o["company"];
return(string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "采购部审批" && f.relate_text == company).Select(f => f.relate_value).ToArray()));
}
//设备科负责人确认
public string s_equitmentAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return(equitmentAuditor(apply, formJson));
}
return("");
}
//申请人上传设备清单
public string s_applierAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return(apply.create_user);
}
return("");
}
//采购接单
public string s_buyerAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return("190423005"); //蔡学骏
}
return("");
}
//部门总经理
public string deptManagementAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string deptName = (string)o["dept_name"];
string company = (string)o["company"];
return(string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == "XA" && f.relate_name == "部门总经理" && f.relate_text == company + "_" + deptName).Select(f => f.relate_value).ToArray()));
}
//设备管理部确认
public string s_equitmentManagerAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return("131017020"); //李夏衍
}
return("");
}
/// <summary>
/// 获取此生产部门对应的设备部维修人员
/// </summary>
/// <param name="apply"></param>
/// <param name="formJson"></param>
/// <returns></returns>
public string GetRepairers(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string prDepName = (string)o["produce_dep_name"];
var repairers = db.vw_ep_repairers.Where(e => e.pr_dep_name == prDepName).Select(e => e.repairer_num).ToArray();
return(string.Join(";", repairers));
}
//部门总经理
public string DepManager(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
var depName = (string)o["dep_name"];
//var currentMonth = DateTime.Now.ToString("yyyy-MM");
return(db.ei_xcDepTarget.Where(x => x.dep_name == depName).OrderByDescending(x => x.year_month).Select(x => x.manager_no).FirstOrDefault());
}
//部门总经理确认
public string s_deptManagementAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return(deptManagementAuditor(apply, formJson));
}
return("");
}
//审核部确认
public string s_checkerAuditor(flow_apply apply, string formJson)
{
if (isSellProc(formJson))
{
return("190522007"); //陈禹健
}
return("");
}
public void DoAfterFlowFailed(string formObj, flow_apply apply)
{
//如果申请了撤销，最后审批失败，需要将apply的success状态改为true，表示此请假流程是有效的
if (apply.user_abort == true)
{
apply.success = true;
}
}
/// <summary>
/// 市场部总经理,根据不同事业部选择
/// </summary>
/// <param name="apply"></param>
/// <param name="formJson"></param>
/// <returns></returns>
public string GetMarketManager(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string marketName = (string)o["market_name"];
var marketAuditors = db.flow_auditorRelation.Where(f => f.bill_type.Contains("UC") &&
f.relate_name == "市场部总经理" && f.relate_text == marketName).Select(f => f.relate_value).ToArray();
return(string.Join(";", marketAuditors));
}
/// <summary>
/// 事业部长审批，根据不同生产事业部选择
/// 2020-4-24 此环节取消
/// </summary>
/// <param name="apply"></param>
/// <param name="formJson"></param>
/// <returns></returns>
public string GetBusDepMinister(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string busDep = (string)o["bus_dep"];
var busDepAuditors = db.flow_auditorRelation.Where(f => f.bill_type.Contains("UC") &&
f.relate_name == "事业部长" && f.relate_text == busDep).Select(f => f.relate_value).ToArray();
return(string.Join(";", busDepAuditors));
}
/// <summary>
/// 市场管理部审批，如果不是电子的，到晓哗处理，否则跳过
/// </summary>
/// <param name="apply"></param>
/// <param name="formJson"></param>
/// <returns></returns>
public string GetMarketAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string company = (string)o["company"];
var companyAuditors = db.flow_auditorRelation.Where(f => f.bill_type.Contains("UC") &&
f.relate_name == "市场管理部" && f.relate_text == company).Select(f => f.relate_value).ToArray();
return(string.Join(";", companyAuditors));
}
//总裁办审批
public string CEO(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
if ((bool)o["need_ceo_confirm"])
{
return("00031304"); //王雅婷
}
return("");
}
//AH审核人
public string GetAHAuditor(flow_apply apply, string formJson)
{
var auditors = db.flow_auditorRelation.Where(f => f.bill_type == "IE" && f.relate_name == "AH部").Select(f => f.relate_value).ToArray();
if (auditors.Count() == 0)
{
return("");
}
return(string.Join(";", auditors));
}
public void DoAfterFlowSucceed(string formObj, flow_apply app)
{
var o = JObject.Parse(formObj);
string accountName = (string)o["k3_account_name"];
string stockNumber = (string)o["k3_stock_num"];
string cardNumber = (string)o["applier_num"];
//设置管理员权限到K3
db.SetK3StockAdmin(accountName, stockNumber, cardNumber);
}
//营运部审批
public string Operation(flow_apply apply, string formJson)
{
//o = JObject.Parse(formJson);
//var total = (int)o["current_month_total"];
//var target = (int)o["current_month_target"];
//if (total > target) {
return("200921024"); //佐健
//}
//return "";
}
/// <summary>
/// 行政部审批
/// </summary>
/// <param name="apply"></param>
/// <param name="formJson"></param>
/// <returns></returns>
public string GetAdministrationAuditor(flow_apply apply, string formJson)
{
//o = JObject.Parse(formJson);
//bool isSend = ((string)o["send_or_receive"] == "寄件");
//bool isProduct = ((string)o["content_type"] == "产品" || (string)o["content_type"] == "原材料");
//if (isSend && isProduct) {
// return string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "行政部审批").Select(f => f.relate_value).ToArray());
//}
return(""); //2021-1-21 锡标说不需要经过行政部
}
//办事处审批 2020-9-9 营业申请改为客服申请，提交后抄送给客服即可，所以不需办事处审批
public string GetAgencyAuditor(flow_apply apply, string formJson)
{
return("");
//o = JObject.Parse(formJson);
//string agencyName = (string)o["agency_name"];
//var auditors = db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE
// && f.relate_name == "办事处审批人" && f.relate_text == agencyName).Select(f => f.relate_value).ToArray();
//if (auditors.Count() == 0) return "";
//return string.Join(";", auditors);
}
//获取本宿舍区的维修工
public string GetRepairers(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string areaName = (string)o["area_name"];
var repairmans = db.vw_dp_repairman.Where(v => v.area_name == areaName);
if (repairmans.Count() > 0)
{
return(repairmans.First().repairman_card_number);
}
return("");
}
//申请人确认
public string ApplierConfrim(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
if ("挽留成功".Equals((string)o["group_leader_choise"]))
{
return(apply.create_user);
}
else
{
return("");
}
}
//仓管审核，根据仓库地址获取
public string GetStockAuditor(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string contentType = (string)o["content_type"];
string stockAddr = (string)o["stock_addr"];
if ("原材料".Equals(contentType) && !string.IsNullOrEmpty(stockAddr))
{
return(string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "仓管审批" && f.relate_text == stockAddr).Select(f => f.relate_value).ToArray()));
}
return("");
}
public string GetClassLeader(flow_apply app, string formObj)
{
var o = JObject.Parse(formObj);
int infoId = (int)o["eqInfo_id"];
var leader = (from i in db.ei_mtEqInfo
join c in db.ei_mtClass on i.class_id equals c.id
where i.id == infoId
select c.leader_number).FirstOrDefault();
return(leader);
}
//现场维修的，需要申请人搬电脑到IT部处理
public string GetApplierIfNeed(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
string applierNumber = (string)o["applier_num"];
string repairWay = (string)o["repair_way"];
if ("现场维修".Equals(repairWay))
{
return(applierNumber);
}
return("");
}
// 信息管理部经理
public string GetICManager(flow_apply apply, string formJson)
{
o = JObject.Parse(formJson);
int priority = (int)o["priority"];
//总裁办优先级为5，部长级别为4，经理级别为3，其他为1
if (priority > 1)
{
return(string.Join(";", db.flow_auditorRelation.Where(f => f.bill_type == BILLTYPE && f.relate_name == "信息管理部经理").Select(f => f.relate_value).ToArray()));
}
return("");
}
