//现金记账API public string DoCashAccounting(int userID, string ApplyDate, int FlowTypeID, string feeItemID, string feeItemName, string money, string cAdd, string location) { string result = "{}"; try { //获取记账日期 string applyDate = ApplyDate; //获取流动资金类型 FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == FlowTypeID).Single(); string flowTypeID = ffType.ID.ToString(); //获取流动资金类型名称 string flowTypeName = ffType.Name; //获取类型 string InOutType = ffType.InOutType; //获取资金 string iMoney = money; string isJieKuan = flowTypeName.Contains("借") == true ? "Y" : "N"; //参数设置 SqlParameter[] sp1 = new SqlParameter[] { new SqlParameter { ParameterName = "@applyDate", Value = applyDate }, new SqlParameter { ParameterName = "@flowTypeID", Value = flowTypeID }, new SqlParameter { ParameterName = "@flowTypeName", Value = flowTypeName }, new SqlParameter { ParameterName = "@InOutType", Value = InOutType }, new SqlParameter { ParameterName = "@FeeItemID", Value = feeItemID }, new SqlParameter { ParameterName = "@FeeItemName", Value = feeItemName }, new SqlParameter { ParameterName = "@iMoney", Value = iMoney }, new SqlParameter { ParameterName = "@UserID", Value = userID }, new SqlParameter { ParameterName = "@BJieKuan", Value = isJieKuan }, new SqlParameter { ParameterName = "@BHuanKuan", Value = "N" }, new SqlParameter { ParameterName = "@CAdd", Value = cAdd }, new SqlParameter { ParameterName = "@CSouce", Value = APPLY_DATASOURCE_IOSAPP }, new SqlParameter { ParameterName = "@CLocation", Value = location ?? "" } }; //执行存储过程 bool success = this.ExecStoredProcedure("proc_AddCashAccouting", sp1); if (success == true) { result = WebComm.ReturnJsonForExterior(true, "现金记账成功!", "{}"); } else { result = WebComm.ReturnJsonForExterior(false, "现金记账失败!", "{}"); } } catch (Exception ex) { result = WebComm.ReturnJsonForExterior(false, "现金记账失败!" + ex.Message, "{}"); } return(result); }
//内部转账API public string DoZhuanZhang(int userID, string ApplyDate, int FlowTypeID, string feeItemID, string feeItemName, string money, string inUBID, string outUBID, string cAdd, string location) { string result = "{}"; try { //获取记账日期 string applyDate = ApplyDate; //获取流动资金类型 FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == FlowTypeID).Single(); string flowTypeID = ffType.ID.ToString(); //获取流动资金类型名称 string flowTypeName = ffType.Name; //获取类型 string InOutType = ffType.InOutType; //获取资金 string iMoney = money; //获取入账银行信息 string inUserBankID = inUBID; //获取出账银行信息 string outUserBankID = outUBID; //参数设置 SqlParameter[] sp3 = new SqlParameter[] { new SqlParameter { ParameterName = "@applyDate", Value = applyDate }, new SqlParameter { ParameterName = "@flowTypeID", Value = flowTypeID }, new SqlParameter { ParameterName = "@flowTypeName", Value = flowTypeName }, new SqlParameter { ParameterName = "@InOutType", Value = InOutType }, new SqlParameter { ParameterName = "@iMoney", Value = iMoney }, new SqlParameter { ParameterName = "@UserID", Value = userID }, new SqlParameter { ParameterName = "@InUserBankID", Value = inUserBankID }, new SqlParameter { ParameterName = "@OutUserBankID", Value = outUserBankID }, new SqlParameter { ParameterName = "@CAdd", Value = cAdd }, new SqlParameter { ParameterName = "@CSouce", Value = APPLY_DATASOURCE_IOSAPP }, new SqlParameter { ParameterName = "@CLocation", Value = location ?? "" } }; //执行存储过程 bool success = this.ExecStoredProcedure("proc_CashChange", sp3); if (success) { result = WebComm.ReturnJsonForExterior(true, "转账记账成功!", "{}"); } else { result = WebComm.ReturnJsonForExterior(true, "转账记账失败!", "{}"); } } catch (Exception ex) { result = WebComm.ReturnJsonForExterior(false, "转账记账失败!" + ex.Message, "{}"); } return(result); }