public static string updateActualFee(ArrayList list) { ArrayList codeList = new ArrayList(); ArrayList actualFeeList = new ArrayList(); foreach (Dictionary <string, string> dict in list) { if (dict != null) { codeList.Add(dict["Id"].ToString()); actualFeeList.Add(dict["ApprovalNumber"].ToString()); } else { codeList.Add(""); actualFeeList.Add(""); } } string res = OperationDeliverSrv.updateActualFee(list); OperationDeliverSrv.UpdateOperationApprovalTime(codeList); // 插入一条数据到销售日表中 OperationDeliverSrv.insertSalesData(codeList); string[] msgs = res.Split(';'); DataTable dtUser = ReimbursementSrv.GetUserNameAndWxUserId(); WxCommon wx = new WxCommon("DeliverApplyReport", "vvsnJs9JYf8AisLWOE4idJbdR1QGc7roIcUtN6P2Lhc", "1000009", ""); for (int i = 0; i < msgs.Length - 1; i++) { SqlExceRes sqlRes = new SqlExceRes(msgs[i]); if (sqlRes.Result == SqlExceRes.ResState.Success) { Dictionary <string, string> dict = (Dictionary <string, string>)list[i]; string WxUserId = ""; foreach (DataRow row in dtUser.Rows) { if (row["userName"].ToString() == dict["ApprovalName"]) { WxUserId = row["wechatUserId"].ToString(); break; } } if (!string.IsNullOrEmpty(WxUserId)) { // 发送审批的消息给提交者 wx.SendWxMsg(WxUserId, "审批通知", "您编号为" + codeList[i] + "的发货单据已被运营部进行实发数量复审,审批人为:" + dict["ApprovalName"] + ",实发数量为" + actualFeeList[i] + ",请知悉" , "http://yelioa.top//mDeliverApplyReportAppRoval.aspx?type=0&docCode=" + codeList[i]); } } } return(res); }
public static DataTable getApprovalRecordCount(string code) { DataSet ds = ReimbursementSrv.getApprovalRecordCount(code); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static DataTable getApproverByCode(string docCode) { DataSet ds = ReimbursementSrv.getApproverByCode(docCode); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static DataTable findByCode(string code) { DataSet ds = ReimbursementSrv.findByCond(code, null, null, null, null, null, null, null, null, null, null, null, null); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static DataTable findByCond(string applystarttm, string applyendtm, string starttm, string endtm, string applyName, string depart, string fee_depart, string fee_detail , string account_status, string status, string sortName, string sortOrder) { DataSet ds = ReimbursementSrv.findByCond(null, applystarttm, applyendtm, starttm, endtm, applyName, depart, fee_depart, fee_detail, account_status, status, sortName, sortOrder); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static string batchInsertReimburse(Dictionary <string, object> dict) { string msg = ReimbursementSrv.batchInsertReimburse(dict); if (msg.Contains("操作成功")) { return("成功"); } else { return("失败"); } }
public static string updateActualFee(List <Dictionary <string, object> > list) { string res = ReimbursementSrv.updateActualFee(list); //string[] msgs = res.Split(';'); //DataTable dtUser = ReimbursementSrv.GetUserNameAndWxUserId(); //WxCommon wx = new WxCommon("mMobileReimbursement", // "UM0i5TXSIqQIOWk-DmUlfTqBqvZAfbZdGGDKiFZ-nRk", // "1000006", // ""); //for (int i = 0; i < msgs.Length - 1; i++) //{ // SqlExceRes sqlRes = new SqlExceRes(msgs[i]); // if (sqlRes.Result == SqlExceRes.ResState.Success) // { // //Dictionary<string, string> dict = (Dictionary<string, string>)list[i]; // //string WxUserId = SqlHelper.Find("select wechatUserId from users where userName = '******'").Tables[0].Rows[0][0].ToString(); // //foreach (DataRow row in dtUser.Rows) // //{ // // if (row["userName"].ToString() == dict["name"]) // // { // // WxUserId = row["wechatUserId"].ToString(); // // break; // // } // //} // //if (!string.IsNullOrEmpty(WxUserId)) // //{ // // // 发送审批的消息给提交者 // // wx.SendWxMsg(WxUserId, "审批通知", "您编号为:" + codeList[i] + "的审批单据已被财务进行金额复审,审批人为:" // // + dict["approver"] + ",财务已付款" + actualFeeList[i] + "元,请知悉" // // , "http://yelioa.top/mMySubmittedReimburse.aspx?docCode=" + codeList[i]); // //} // } //} return(res); }
public static DataSet checkApprover(string code, string userId) { return(ReimbursementSrv.checkApprover(userId, code)); }
public static DataSet GetDocumnetsInfosByCode(string DocCode, string name) { return(ReimbursementSrv.GetDocumnetsInfosByCode(DocCode, name)); }
public static DataSet GetDocumnetsInfosToBeSubmitedByMe(string userName, string keyword) { return(ReimbursementSrv.GetDocumnetsInfosToBeSubmitedByMe(userName, keyword)); }
public static DataSet GetDocumnetsInfosRelatedToMe(string userId, string keyword) { return(ReimbursementSrv.GetDocumnetsInfosRelatedToMe(userId, keyword)); }
public static string recordAccountEvent(DataTable dt) { return(ReimbursementSrv.recordAccountEvent(dt)); }
public static DataSet GetInfos(string name, string keyword, int year, int month) { return(ReimbursementSrv.GetInfos(name, keyword, year, month)); }
/// <summary> /// 财务单据审批 /// </summary> /// <param name="list"> /// list元素为Dictionary<string,string>,其中key包含: /// 单据编号,code /// 审批人,approver /// 审批结果,ApprovalResult /// 审批意见,ApprovalOpinions /// 审批时间,approval_time /// 提交人, name /// </param> /// <returns> /// /// </returns> public static string Approval(ArrayList list) { // 记录code 因为下一步不更新code会把code删除 ArrayList codeList = new ArrayList(); foreach (Dictionary <string, string> dict in list) { if (dict != null) { codeList.Add(dict["code"].ToString()); } else { codeList.Add(""); } } string res = ReimbursementSrv.Approval(list); string[] msgs = res.Split(';'); DataTable dtUser = ReimbursementSrv.GetUserNameAndWxUserId(); WxCommon wx = new WxCommon("mMobileReimbursement", "UM0i5TXSIqQIOWk-DmUlfTqBqvZAfbZdGGDKiFZ-nRk", "1000006", ""); for (int i = 0; i < msgs.Length - 1; i++) { SqlExceRes sqlRes = new SqlExceRes(msgs[i]); if (sqlRes.Result == SqlExceRes.ResState.Success) { Dictionary <string, string> dict = (Dictionary <string, string>)list[i]; string WxUserId = ""; foreach (DataRow row in dtUser.Rows) { if (row["userName"].ToString() == dict["name"]) { WxUserId = row["wechatUserId"].ToString(); break; } } if (!string.IsNullOrEmpty(WxUserId)) { // 发送审批的消息给提交者 wx.SendWxMsg(WxUserId, "审批通知", "您编号为:" + codeList[i] + "的审批单据已被财务审批,审批人为:" + dict["account_approver"] + ",结果为:" + dict["account_result"] + ",意见为:" + dict["account_opinion"] + ",请知悉" , "http://yelioa.top/mMySubmittedReimburse.aspx?docCode=" + codeList[i]); } // 审批拒绝的需要把关联的发票一起拒绝 if ("拒绝" == dict["account_result"].ToString()) { string sql = string.Format("update yl_reimburse_detail set status = '拒绝', opinion = '关联的移动报销单据被拒绝' where code like '%{0}%'", codeList[i]); // 删除关联差旅申请 sql += string.Format("delete from wf_form_差旅申请 where reimburseCode = '{0}';", codeList[i]); // 删除关联借款单 并把借款单的金额还原 DataTable dt = SqlHelper.Find(string.Format("select * from yl_reimburse_loan where ReimburseCode = '{0}'", codeList[i])).Tables[0]; sql += string.Format("delete from yl_reimburse_loan where ReimburseCode = '{0}';", codeList[i]); 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(res); }