public string GetFlowType(int typeID)
{
//typeID=0查询现金的资金类型，为1时查询银行相关的
string result = "{}";
string obj = "";
try
{
if (typeID == 0)
{
obj = JsonConvert.SerializeObject(WebComm.GetFundFlowTypeList_Cash().Where(c => c.InOutType == "in" || c.InOutType == "out"));
}
else if (typeID == 1)
{
obj = JsonConvert.SerializeObject(WebComm.GetFundFlowTypeList_Bank().Where(c => c.InOutType == "in" || c.InOutType == "out"));
}
else
{
obj = JsonConvert.SerializeObject(WebComm.GetFundFlowTypeList_Bank().Where(c => c.InOutType != "in" && c.InOutType != "out"));
}
result = WebComm.ReturnJsonForExterior(true, "获取资金类型成功！", obj);
}
catch (Exception ex)
{
result = WebComm.ReturnJsonForExterior(false, "获取资金类型失败！" + ex.Message, null);
}
return(result);
}
public string DoCashAccounting(int userID, string ApplyDate, int FlowTypeID, string feeItemID, string feeItemName, string money, string cAdd)
{
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";
//获取备注信息
string sql = "exec proc_AddCashAccouting '" + applyDate + "'," + flowTypeID + ",'" + flowTypeName + "','" + InOutType + "'," + feeItemID + ",'" + feeItemName + "'," + iMoney + "," + userID.ToString() + ",'" + isJieKuan + "','N','" + cAdd + "'";
LycSQLHelper.ExecuteCommand(CommandType.Text, sql);
result = WebComm.ReturnJsonForExterior(true, "现金记账成功！", "{}");
}
catch (Exception ex)
{
result = WebComm.ReturnJsonForExterior(false, "现金记账失败！" + ex.Message, "{}");
}
return(result);
}
public string GetUserBankList(int userID)
{
string result = "{}";
try
{
var list = from lu in db.UserBanks
where lu.UserID == userID
select new
{
userBankID = lu.ID,
bankID = lu.BankID,
bankName = lu.BankName,
bankType = lu.BankCardType,
money = lu.NowMoney,
cardNo = lu.BankNo
};
result = WebComm.ReturnJsonForExterior(true, "获取银行账户成功！", JsonConvert.SerializeObject(list));
}
catch (Exception ex)
{
result = WebComm.ReturnJsonForExterior(false, "获取银行账户失败！" + ex.Message, "{}");
}
return(result);
}
public string GetUserBankList(int userID, string bankName, string bankNo, string bankCardType, int pageSize, int currentPage)
{
string jsonResult = "";
try
{
//根据查询条件筛选数据
var userBankList = db.UserBanks.Where(c => c.UserID == userID).AsQueryable();
if (!string.IsNullOrEmpty(bankName))
{
userBankList = userBankList.Where(c => c.BankName.Contains(bankName));
}
if (!string.IsNullOrEmpty(bankNo))
{
userBankList = userBankList.Where(c => c.BankNo.Contains(bankNo));
}
if (!string.IsNullOrEmpty(bankCardType))
{
userBankList = userBankList.Where(c => c.BankCardType.Contains(bankCardType));
}
int records = userBankList.Count();
//将分页查询后的数据组织为可json序列化的对象
var jsonObj = new
{
pagesize = pageSize,
totalRecords = records,
currentpage = currentPage,
rows = (from list in userBankList.OrderBy(c => c.BankID).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList()
select new
{
bankid = list.BankID,
bankname = list.BankName,
bankno = list.BankNo,
bankcardtype = list.BankCardType,
nowMoney = list.NowMoney
}
).ToArray()
};
if (records > 0)
{
jsonResult = WebComm.ReturnJsonForExterior(true, "获取数据成功！", JsonConvert.SerializeObject(jsonObj));
}
else
{
jsonResult = WebComm.ReturnJsonForExterior(false, "获取数据失败！", null);
}
}
catch (Exception ex)
{
jsonResult = WebComm.ReturnJsonForExterior(false, "获取数据错误！" + ex.Message, null);
}
return(jsonResult);
}
public string GetFeeItem()
{
string result = "{}";
try
{
result = WebComm.ReturnJsonForExterior(true, "获取费用科目成功！", JsonConvert.SerializeObject(WebComm.GetFeeItemListByXml().Where(c => c.IsLast == true)));
}
catch (Exception ex)
{
result = WebComm.ReturnJsonForExterior(false, "获取费用科目失败！" + ex.Message, null);
}
return(result);
}
public string DoZhuanZhang(int userID, string ApplyDate, int FlowTypeID,
string feeItemID, string feeItemName, string money,
string inUBID, string outUBID, string cAdd)
{
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;
//获取备注信息
string sql = "exec proc_CashChange '" + applyDate + "'," + flowTypeID + ",'" + flowTypeName + "','" + InOutType + "'," + iMoney + "," + userID.ToString() + "," + inUserBankID + "," + outUserBankID + ",'" + cAdd + "'";
LycSQLHelper.ExecuteCommand(CommandType.Text, sql);
result = WebComm.ReturnJsonForExterior(true, "转账记账成功！", "{}");
}
catch (Exception ex)
{
result = WebComm.ReturnJsonForExterior(false, "转账记账失败！" + ex.Message, "{}");
}
return(result);
}
public string UserLogin(int userCode, string userPwd)
{
string jsonResult = "";
FamilyManagerWeb.Models.User user = db.Users.Where(c => c.cUserCode == userCode && c.cUserPwd == userPwd).SingleOrDefault();
string jsonObj = "";
if (user != null && user.cUserFlag == true)
{
jsonObj = "{\"userID\":" + user.ID + ",\"userCode\":\"" + user.cUserCode + "\",\"userName\":\"" + user.cUserName + "\",\"userPwd\":\"" + userPwd + "\"}";
jsonResult = WebComm.ReturnJsonForExterior(true, "登陆成功！", jsonObj);
}
else if (user == null)
{
jsonResult = WebComm.ReturnJsonForExterior(false, "用户名或密码错误！", null);
}
else
{
jsonResult = WebComm.ReturnJsonForExterior(false, "用户已无效！", null);
}
return(jsonResult);
}