//现金记账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);
}
