// 单据退回
public String returnDocument()
{
String docCode = Request.Params["docCode"];
UserInfo user = (UserInfo)Session["user"];
return(ApprovalFlowManage.returnDocument("net_sales", docCode, user));
}
private string approval()
{
string id = Request.Form["docCode"];
string approvalResult = Request.Form["approvalResult"];
UserInfo userInfo = (UserInfo)Session["user"];
string msg = ApprovalFlowManage.ApproveDocument("demand_apply_report", id, userInfo, approvalResult, "",
"http://yelioa.top//mDemandApplyReportApproval.aspx?type=0&docCode=" + id, "http://yelioa.top//mDemandApplyReportAppRoval.aspx?type=1&docCode=" + id, "http://yelioa.top/mDemandApplyReport.aspx",
"AirlZ8lfY50d1KGDklHPQcLV2RUFAdrhD-WXU23cA-w", "DemandApplyReport", "1000013");
if (msg == "审批流程结束")
{
if (!ApprovalFlowManage.EndDemandApprove(id).Contains("操作成功"))
{
msg += ",添加审批时间失败";
}
// 把数据添加到货需日表中
string insertSql = string.Format("insert into purchase_daily_report (docNo,batchNo,date,code,purchaseNumber) " +
"values ('{0}','',now(),(select productCode code from demand_apply_report where id = '{0}'),(select deliverNumber purchaseNumber from demand_apply_report where id = '{0}'))", id);
SqlHelper.Exce(insertSql);
}
JObject jObject = new JObject();
jObject.Add("msg", jObject);
return(jObject.ToString());
}
private string returnReimburse()
{
string docCode = Request.Form["docCode"];
UserInfo userInfo = (UserInfo)Session["user"];
ApprovalFlowManage.returnDocument("yl_reimburse", docCode, userInfo);
return(null);
}
private String submitNetSalesNumOfReportSales()
{
String docCode = Request.Form["docCode"];
UserInfo user = (UserInfo)Session["user"];
return(ApprovalFlowManage.SubmitDocument("net_sales", docCode, user,
"http://yelioa.top/mNetSalesApproval.aspx?type=others", "http://yelioa.top/mNetSalesApproval.aspx?type=mine",
"PyO4Il3bIxyuFquBAGrrr76GVcUbIN5NPpxNGAja-4U", "netSales", "1000002"));
}
// 开始审批
private String beginApproval()
{
UserInfo user = (UserInfo)Session["user"];
String approvalResult = Request.Form["ApprovalResult"].ToString();
String approvalOpinions = Request.Form["ApprovalOpinions"].ToString();
String docCodes = Request.Form["docCodes[]"] != null ?
Request.Form["docCodes[]"].ToString() : Request.Form["docCodes"].ToString();
String[] docCodeArray = docCodes.Split(',');
String netSalesNum = Request.Form["netSalesNum"].ToString();
if (docCodeArray.Length < 1)
{
return("单据为空，无法进行审批");
}
string msg = "";
for (int i = 0; i < docCodeArray.Length; i++)
{
String docCode = docCodeArray[i];
String returnMsg = ApprovalFlowManage.ApproveDocument("net_sales", docCode, user, approvalResult, approvalOpinions,
"http://yelioa.top/mNetSalesApproval.aspx?type=mine", "http://yelioa.top/mNetSalesApproval.aspx?type=his", "http://yelioa.top/mNetSalesUpload.aspx",
"PyO4Il3bIxyuFquBAGrrr76GVcUbIN5NPpxNGAja-4U", "netSales", "1000002");
if (i != 0)
{
msg += ",";
}
if (returnMsg.Contains("出错"))
{
msg += ("单号为" + docCode + "的单据审批出错");
}
else if (returnMsg.Contains("结束"))
{
// 审批流程结束后，需要把纯销数据更新到flow_statistic表中
string tempMsg = NetSalesInfoSrv.updateNetSalesAndStockAfterApproval(docCode);
if ("更新成功".Equals(tempMsg))
{
msg += ("单号为" + docCode + "的单据审批流程结束");
}
else
{
msg += ("单号为" + docCode + "的单据审批流程结束失败！");
}
}
else if ("当前用户无审批权限！".Equals(returnMsg))
{
msg += ("单号为" + docCode + "的单据已被其他人审批，请知悉！");
}
else
{
msg += ("单号为" + docCode + "的单据审批成功");
}
}
return(msg);
}
private string approval()
{
string id = Request.Form["docCode"];
string approvalResult = Request.Form["approvalResult"];
UserInfo userInfo = (UserInfo)Session["user"];
string msg = ApprovalFlowManage.ApproveDocument("deliver_apply_report", id, userInfo, approvalResult, "",
"http://yelioa.top//mDeliverApplyReportAppRoval.aspx?type=0&docCode=" + id, "http://yelioa.top//mDeliverApplyReportAppRoval.aspx?type=1&docCode=" + id, "http://yelioa.top/mDeliverApplyReport.aspx",
"vvsnJs9JYf8AisLWOE4idJbdR1QGc7roIcUtN6P2Lhc", "DeliverApplyReport", "1000009");
if (msg == "审批流程结束")
{
if (!ApprovalFlowManage.EndDeliverApprove(id).Contains("操作成功"))
{
msg += ",添加审批时间失败";
}
}
JObject jObject = new JObject();
jObject.Add("msg", jObject);
return(jObject.ToString());
}
private string approve()
{
UserInfo userInfo = (UserInfo)Session["user"];
string type = Request.Form["type"];
string result = Request.Form["result"];
string opinion = Request.Form["opinion"];
string docCode = Request.Form["docCode"];
JObject jobject = new JObject
{
{ "msg", "ok" },
{ "code", 200 },
};
// 首先判断是否有权限审批 防止重复点击
string sql = string.Format("select 1 from {1} t1 left join approval_approver t2 on t1.docCode = t2.docCode and (t1.level = t2.level) " +
"left join users t3 on t2.approverId = t3.userId where t2.approverId = '{0}' and t1.status = '审批中' and t1.docCode = '{2}'", userInfo.userId.ToString(), type, docCode);
DataSet ds = SqlHelper.Find(sql);
if (ds.Tables[0].Rows.Count == 0)
{
jobject["msg"] = "没有权限审批";
jobject["code"] = 500;
return(jobject.ToString());
}
string msg = ApprovalFlowManage.ApproveDocument(type, docCode, userInfo, result, opinion,
"http://yelioa.top/mCompanyFee.aspx", "http://yelioa.top/mCompanyFeeApproval.aspx",
"http://yelioa.top/mCompanyFee.aspx", "vbmKxak1-a5Ty1cEBJzUFa1OR9f0V4Yh5j0sJq2-e9o", "mCompanyFeeApproval", "1000023");
jobject["msg"] = msg;
return(jobject.ToString());
}
private string approvalReimburse()
{
string docCode = Request.Form["docCode"];
string ApprovalResult = Request.Form["ApprovalResult"];
string ApprovalOpinions = Request.Form["ApprovalOpinions"];
UserInfo userInfo = (UserInfo)Session["user"];
string sql = "select * from yl_reimburse where id = " + docCode;
DataTable dt = SqlHelper.Find(sql).Tables[0];
string code = dt.Rows[0]["code"].ToString();
// 查询这一级的审批人是否是该用户
DataSet checkApproverDt = ReimbursementManage.checkApprover(code, userInfo.userId.ToString());
string msg = "";
if (checkApproverDt == null || checkApproverDt.Tables[0] == null ||
checkApproverDt.Tables[0].Columns.Count == 0 || checkApproverDt.Tables[0].Rows.Count == 0)
{
msg = "当前用户无审批权限";
return(JsonHelper.SerializeObject(msg));
}
//// 若提交时间超过当月25号 则不允许审批
// DateTime submitTime = Convert.ToDateTime(dt.Rows[0]["apply_time"]);
// DateTime theTime = Convert.ToDateTime(DateTime.Now.Year + "-" + DateTime.Now.Month + "-25" + " 00:00:00");
// if (submitTime > theTime)
// {
// msg = "该单据超过25号提交，暂无法审批！";
// return JsonHelper.SerializeObject(msg);
// }
//if (ApprovalResult == "同意" && dt.Rows[0]["IsOverBudget"].ToString() != "1")
//{
// JObject j = ReimbursementManage.IsOverBudget(dt.Rows[0]["fee_department"].ToString(), dt.Rows[0]["fee_detail"].ToString(), Convert.ToDouble(dt.Rows[0]["fee_amount"].ToString()), DateTime.Now);
// if (msg.Contains("预算余额不足"))
// {
// return JsonHelper.SerializeObject(msg);
// }
//}
if (ApprovalResult == "同意" && dt.Rows[0]["isOverBudget"].ToString() != "1")
{
JObject res = ReimbursementManage.IsOverBudget(dt.Rows[0]["fee_department"].ToString(), dt.Rows[0]["fee_detail"].ToString(), Convert.ToDouble(dt.Rows[0]["fee_amount"].ToString())
, Convert.ToDateTime(dt.Rows[0]["apply_time"].ToString()));
if (res == null || Convert.ToDouble(res["budget"]) < Convert.ToDouble(res["hasApprove"]) + Convert.ToDouble(dt.Rows[0]["fee_amount"].ToString()))
{
return(JsonHelper.SerializeObject("预算余额不足"));
}
}
msg = ApprovalFlowManage.ApproveDocument("yl_reimburse", docCode, userInfo, ApprovalResult, ApprovalOpinions,
"http://yelioa.top/mMySubmittedReimburse.aspx?docCode=" + code, "http://yelioa.top/mMobileReimbursement.aspx?docCode=" + code, "http://yelioa.top/mMySubmittedReimburse.aspx?docCode=" + code, "UM0i5TXSIqQIOWk-DmUlfTqBqvZAfbZdGGDKiFZ-nRk", "yl_reimburse", "1000006");
if ("审批流程结束".Equals(msg) || "审批拒绝！".Equals(msg))
{
// 清除approval_process表中内容
MobileReimburseManage.clearApprovalProcess(docCode);
// 更新审批时间
MobileReimburseManage.updateApprovalTimeAndResultAndOpinion(docCode, ApprovalResult, ApprovalOpinions);
// 删除关联差旅申请
sql += string.Format("delete from wf_form_差旅申请 where reimburseCode = '{0}';", code);
// 删除关联借款单 并把借款单的金额还原
dt = SqlHelper.Find(string.Format("select * from yl_reimburse_loan where ReimburseCode = '{0}'", code)).Tables[0];
sql += string.Format("delete from yl_reimburse_loan where ReimburseCode = '{0}';", code);
foreach (DataRow dr in dt.Rows)
{
decimal amount = Decimal.Parse(dr["amount"].ToString());
string tempCode = dr["docCode"].ToString();
sql += string.Format("update wf_form_借款单 set remainAmount = remainAmount + {0} where docCode = '{1}';", amount, tempCode);
}
SqlHelper.Exce(sql);
}
return(JsonHelper.SerializeObject(msg));
}
public static string insertDemandApplyReport(string hospitalName, string netSales, string stock,
string productName, string agentName, string spec, string unit, string applyNumber, string remark, UserInfo userInfo, List <string> approverList, List <string> informerList)
{
// 通过产品名 规格 单位来确定产品代码
DataSet productDs = DemandApplyReportSrv.findProductCode(productName, spec, unit);
string productCode = "";
if (productDs != null && productDs.Tables[0].Rows.Count > 0)
{
productCode = productDs.Tables[0].Rows[0][0].ToString();
}
// 通过医院名来确定医院代码
DataSet hospitalDs = DemandApplyReportSrv.findHospitalCode(hospitalName);
string hospitalCode = "";
if (hospitalDs != null && hospitalDs.Tables[0].Rows.Count > 0)
{
hospitalCode = hospitalDs.Tables[0].Rows[0][0].ToString();
}
// 通过代理商名称来确定代理商编码
DataSet agentDs = DeliverApplyReportSrv.findAgentCode(agentName);
string agentCode = "";
if (agentDs != null && agentDs.Tables[0].Rows.Count > 0)
{
agentCode = agentDs.Tables[0].Rows[0][0].ToString();
}
string data = DemandApplyReportSrv.insertDemandApplyReport(hospitalCode, productCode, agentCode, applyNumber, remark, userInfo, netSales, stock);
string id = JsonHelper.DeserializeJsonToObject <JObject>(data)["Id"].ToString();
// 新增审批人到审批流程表中
List <JObject> list = new List <JObject>();
for (int i = 0; i < approverList.Count; i++)
{
JObject jO = new JObject();
jO.Add("index", i);
jO.Add("userId", approverList[i]);
list.Add(jO);
}
MobileReimburseSrv.insertApprovalProcess(id, list, "demand_apply_report");
DataSet maxIdDt = DemandApplyReportSrv.findMaxId();
string docCode = maxIdDt.Tables[0].Rows[0][0].ToString();
// 审批单提交
ApprovalFlowManage.SubmitDocument("demand_apply_report", docCode, userInfo,
"http://yelioa.top//mDemandApplyReportAppRoval.aspx?type=0&docCode=" + docCode, "http://yelioa.top//mDemandApplyReportAppRoval.aspx?type=1&docCode=" + docCode,
"AirlZ8lfY50d1KGDklHPQcLV2RUFAdrhD-WXU23cA-w", "DemandApplyReport", "1000013");
// 新增知悉人到表
DemandApplyReportSrv.insertInformer(docCode, informerList);
return("提交成功");
}
//public static string findSpecAndUnit(string name)
//{
// DataSet ds = DeliverApplyReportSrv.findSpecAndUnit(name);
// if (ds == null || ds.Tables[0].Rows.Count == 0)
// return null;
// DataTable specDt = new DataTable();
// specDt.Columns.Add("value", Type.GetType("System.String"));
// specDt.Columns.Add("target", Type.GetType("System.String"));
// DataTable unitDt = new DataTable();
// unitDt.Columns.Add("value", Type.GetType("System.String"));
// unitDt.Columns.Add("target", Type.GetType("System.String"));
// List<string> specList = new List<string>();
// List<string> unitList = new List<string>();
// foreach (DataRow row in ds.Tables[0].Rows)
// {
// if (row["specification"] != null && !specList.Contains(row["specification"].ToString()))
// {
// DataRow specDr = specDt.NewRow();
// specDr["value"] = row["specification"];
// specDr["target"] = row["specification"];
// specDt.Rows.Add(specDr);
// specList.Add(row["specification"].ToString());
// }
// if (row["unit"] != null && !unitList.Contains(row["unit"].ToString()))
// {
// DataRow unitDr = unitDt.NewRow();
// unitDr["value"] = row["unit"];
// unitDr["target"] = row["unit"];
// unitDt.Rows.Add(unitDr);
// unitList.Add(row["unit"].ToString());
// }
// }
// JObject jObject = new JObject();
// jObject.Add("specJson", JsonHelper.DataTable2Json(specDt));
// jObject.Add("unitJson", JsonHelper.DataTable2Json(unitDt));
// return jObject.ToString();
//}
public static string insertDeliverApplyReport(string deliverType, string hospitalName,
string productName, string agentName, string spec, string unit, string applyNumber, string remark, UserInfo userInfo,
List <string> approverList, List <string> informerList, List <string> uploadFileUrlsList,
string stock, string netSales, string period, string isStockReceiptTogether, string deliverAddress, string deliverName, string deliverPhone)
{
// 通过产品名 规格 单位来确定产品代码
DataSet productDs = DeliverApplyReportSrv.findProductCode(productName, spec, unit);
string productCode = "";
if (productDs != null && productDs.Tables[0].Rows.Count > 0)
{
productCode = productDs.Tables[0].Rows[0][0].ToString();
}
// 通过医院名来确定医院代码
DataSet hospitalDs = DeliverApplyReportSrv.findHospitalCode(hospitalName);
string hospitalCode = "";
if (hospitalDs != null && hospitalDs.Tables[0].Rows.Count > 0)
{
hospitalCode = hospitalDs.Tables[0].Rows[0][0].ToString();
}
// 通过代理商名称来确定代理商编码
DataSet agentDs = DeliverApplyReportSrv.findAgentCode(agentName);
string agentCode = "";
if (agentDs != null && agentDs.Tables[0].Rows.Count > 0)
{
agentCode = agentDs.Tables[0].Rows[0][0].ToString();
}
string data = DeliverApplyReportSrv.insertDeliverApplyReport(deliverType, hospitalCode, productCode, agentCode, applyNumber,
remark, userInfo, stock, netSales, period, isStockReceiptTogether, deliverAddress, deliverName, deliverPhone);
string id = JsonHelper.DeserializeJsonToObject <JObject>(data)["Id"].ToString();
// 新增审批人到审批流程表中
List <JObject> list = new List <JObject>();
if (Double.Parse(applyNumber) > ((Double.Parse(netSales) / 30 * Double.Parse(period)) - Double.Parse(stock)))
{
approverList.Insert(1, "100000645");
}
for (int i = 0; i < approverList.Count; i++)
{
JObject jO = new JObject();
jO.Add("index", i);
jO.Add("userId", approverList[i]);
list.Add(jO);
}
MobileReimburseSrv.insertApprovalProcess(id, list, "deliver_apply_report");
// 审批单提交
ApprovalFlowManage.SubmitDocument("deliver_apply_report", id, userInfo,
"http://yelioa.top//mDeliverApplyReportAppRoval.aspx?type=0&docCode=" + id, "http://yelioa.top//mDeliverApplyReportAppRoval.aspx?type=1&docCode=" + id,
"vvsnJs9JYf8AisLWOE4idJbdR1QGc7roIcUtN6P2Lhc", "DeliverApplyReport", "1000009");
// 新增知悉人到表
DeliverApplyReportSrv.insertInformer(id, informerList);
if (uploadFileUrlsList != null && uploadFileUrlsList.Count > 0)
{
DeliverApplyReportSrv.insertAttachement(id, uploadFileUrlsList);
}
//// 新增一条记录到审批记录表中
//DeliverApplyReportSrv.insertDeliverAppyReportRecord("0", userInfo.wechatUserId, userInfo.wechatUserId, "发货申请单提交", "");
//// 给待审批人发送消息
//WxNetSalesHelper wxNetSalesHelper = new WxNetSalesHelper();
//wxNetSalesHelper.GetJsonAndSendWxMsg(approverIds, "请及时审批 提交人为:" + userInfo.userName
// + "的发货申请单,谢谢!", "http://yelioa.top/mNetSalesApproval.aspx?type=others");
//// 给提交人发送消息
//wxNetSalesHelper.GetJsonAndSendWxMsg(userInfo.wechatUserId, "您的发货申请单已提交，请点击查看", "http://yelioa.top/mNetSalesApproval.aspx?type=mine");
return("提交人");
}
