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, ""));
}
}
