public string DoBankAccounting()
{
try
{
/***校验数据完整性***/
if (Session[SessionList.FamilyManageUser.ToString()] == null)
{
return(WebComm.ReturnLogOutPage());
}
if (Request.Form["FlowTypeID"] == "" || Request.Form["FlowTypeID"] == "-1")
{
throw new Exception("请选择资金流动类型！");
}
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
//获取记账日期
string applyDate = Request.Form["ApplyDate"];
//获取流动资金类型
FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == Convert.ToInt32(Request.Form["FlowTypeID"])).Single();
string flowTypeID = ffType.ID.ToString();
//获取流动资金类型名称
string flowTypeName = ffType.Name;
//获取类型
string InOutType = ffType.InOutType;
//获取费用项目
string feeItemID = Request.Form["search_Fee.FeeItemID"] == "" ? "0" : Request.Form["search_Fee.FeeItemID"];
string feeItemName = Request.Form["search_Fee.FeeItemName"] == "" ? "" : Request.Form["search_Fee.FeeItemName"];
//获取资金
string iMoney = Request.Form["NowMoney"];
string isJieKuan = flowTypeName.Contains("借") == true ? "Y" : "N";
//获取入账银行信息
string inUserBankID = Request.Form["In_bank.UserBankID"] == "" ? "0" : Request.Form["In_bank.UserBankID"];
//获取出账银行信息
string outUserBankID = Request.Form["Out_bank.UserBankID"] == "" ? "0" : Request.Form["Out_bank.UserBankID"];
//获取备注信息
string cAdd = Request.Form["cAdd"];
string sql = "exec proc_AddBankAccouting '" + applyDate + "'," + flowTypeID + ",'" + flowTypeName + "','" + InOutType + "'," + feeItemID + ",'" + feeItemName + "'," + iMoney + "," + loginUser.ID.ToString() + "," + inUserBankID + "," + outUserBankID + ",'" + isJieKuan + "','N','" + cAdd + "','PCWeb',''";
LycSQLHelper.ExecuteCommand(CommandType.Text, sql);
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "记账成功！", "", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "记账失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
//现金记账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);
}
