public string DoTKAction(decimal tkmoney, int id)
{
string lycResult = "";
try
{
using (FamilyCaiWuDBEntities db2 = new FamilyCaiWuDBEntities())
{
Apply_Sub s = db2.Apply_Sub.Where(c => c.ID == id).SingleOrDefault();
if (s == null)
{
throw new Exception("此记账信息已不存在，无法执行退款操作！");
}
if (s.InOutType != "out" || s.CashOrBank != 1)
{
throw new Exception("此记账信息不是【银行支出记账】，无法执行退款操作！");
}
if (s.UserBankID == null || s.UserBankID.Value == 0)
{
throw new Exception("此记账信息不是【银行记账】，无法执行退款操作！");
}
if (tkmoney == s.iMoney)
{
throw new Exception("退款金额与原记账金额相同，请直接执行删除操作！");
}
if (tkmoney > s.iMoney)
{
throw new Exception("退款金额大于原记账金额，无法执行退款操作！");
}
//1. 修改原记账信息的 备注、记账金额字段
decimal newMoney = s.iMoney - tkmoney;
s.CAdd = s.CAdd + ";原记账金额：" + s.iMoney + " 元，现在退款：" + tkmoney + " 元，最终记账金额是：" + newMoney + " 元;";
s.iMoney = newMoney;
//2. 修改对应的银行余额信息
UserBank ub = db2.UserBanks.Where(c => c.ID == s.UserBankID.Value).SingleOrDefault();
if (ub == null)
{
throw new Exception("此记账信息中的银行信息已不存在，无法执行退款操作！");
}
ub.NowMoney = ub.NowMoney + tkmoney;
//3. 修改记账主信息的支出合计
Apply_Main m = db2.Apply_Main.Where(c => c.ID == s.ApplyMain_BillCode).SingleOrDefault();
if (m != null)
{
m.ApplyOutMoney = m.ApplyOutMoney - tkmoney;
}
db2.SaveChanges();
}
lycResult = WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "退款成功！", "ApplyInfoListNav", "", CallBackType.none, "");
}
catch (Exception ex)
{
lycResult = WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "退款失败！" + ex.Message, "", "", CallBackType.none, "");
}
return(lycResult);
}
public string AddUserMenuPower()
{
try
{
int UserID = 0;
int.TryParse(Request.Form["UserID"], out UserID);
string sysModelIDs = Request.Form["checkedModelList"] ?? "";
int[] idList = WebComm.GetIntArrayByString(sysModelIDs);
List <UserModelPower> removeList = db.UserModelPowers.Where(m => m.userID == UserID).ToList();
foreach (var item in removeList)
{
db.UserModelPowers.Remove(item);
}
foreach (int id in idList)
{
UserModelPower mpAdd = new UserModelPower()
{
userID = UserID, modelID = id, modelButtonID = 0
};
db.UserModelPowers.Add(mpAdd);
}
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "配置成功", "", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "配置失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
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, ""));
}
}
public string DeleteConfirmed(int id)
{
try
{
string sql = "exec proc_DeleteAccouting " + id.ToString() + " ";
LycSQLHelper.ExecuteCommand(CommandType.Text, sql);
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功！", "ApplySubListNav", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string Edit(SysModel sysmodel)
{
try
{
db.Entry(sysmodel).State = EntityState.Modified;
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string EditUser(User user)
{
try
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "用户更新失败！" + ex.Message, "", "", CallBackType.none, ""));
}
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "用户信息已更新！", "userList", "", CallBackType.closeCurrent, ""));
}
public string Create(SysModel sysmodel)
{
try
{
sysmodel.IsFlag = true;
db.SysModels.Add(sysmodel);
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string UpdateAdd(Apply_Sub sub)
{
try
{
Apply_Sub updateSub = db.Apply_Sub.Find(sub.ID);
updateSub.CAdd = sub.CAdd;
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功！", "ApplyInfoListNav", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string DeleteConfirmed()
{
try
{
string ids = Request["ids"] ?? "";
int[] idList = WebComm.GetIntArrayByString(ids);
foreach (int item in idList)
{
Bank bank = db.Banks.Find(item);
db.Banks.Remove(bank);
}
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "bankMainList", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string Create(Bank bank)
{
try
{
if (ModelState.IsValid)
{
db.Banks.Add(bank);
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加银行成功！", "bankMainList", "", CallBackType.none, ""));
}
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "验证失败！" + ex.Message, "", "", CallBackType.none, ""));
}
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "验证失败！", "", "", CallBackType.none, ""));
}
public string Edit(UserBank userbank)
{
try
{
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
userbank.BankID = Convert.ToInt32(Request.Form["search_bank.BankID"]);
userbank.BankName = Request.Form["search_bank.BankName"];
userbank.UserID = loginUser.ID;
userbank.UserName = loginUser.cUserName;
db.Entry(userbank).State = EntityState.Modified;
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "userBankList", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string DeleteConfirmed()
{
try
{
string ids = Request["ids"] ?? "";
int[] idList = WebComm.GetIntArrayByString(ids);
foreach (int id in idList)
{
SysModel bank = db.SysModels.Find(id);
bank.IsFlag = false;
db.Entry(bank).State = EntityState.Modified;
}
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string Create(UserBank userbank)
{
try
{
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
userbank.BankID = Convert.ToInt32(Request.Form["search_bank.BankID"]);
userbank.BankName = Request.Form["search_bank.BankName"];
userbank.UserID = loginUser.ID;
userbank.UserName = loginUser.cUserName;
userbank.CreateDate = DateTime.Now;
db.UserBanks.Add(userbank);
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "userBankList", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
public string DeleteConfirmed()
{
try
{
string ids = Request["ids"] ?? "";
int[] idList = WebComm.GetIntArrayByString(ids);
foreach (var item in idList)
{
User user = db.Users.Find(item);
db.Users.Remove(user);
}
db.SaveChanges();
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "用户删除失败," + ex.Message, "", "", CallBackType.none, ""));
}
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "用户信息已删除", "", "", CallBackType.none, ""));
}
public string CreateUser(User user)
{
int newUserCode = db.Users.Max(u => u.cUserCode);
newUserCode++;
user.cUserCode = newUserCode;
try
{
if (ModelState.IsValid)
{
user.cUserFlag = true;
user.dCreateDate = DateTime.Now;
db.Users.Add(user);
db.SaveChanges();
}
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, ex.Message + ex.InnerException, "", "", CallBackType.none, ""));
}
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "保存成功", "userList", "", CallBackType.none, ""));
}
public string DeleteConfirmed()
{
try
{
string ids = Request["ids"] ?? "";
int[] idList = WebComm.GetIntArrayByString(ids);
foreach (int item in idList)
{
UserBank bank = db.UserBanks.Find(item);
if (db.Apply_Sub.Where(u => u.UserBankID == bank.ID).Count() > 0 || db.Apply_Sub_CashChange.Where(u => u.InUserBankID == bank.ID || u.OutUserBankID == bank.ID).Count() > 0)
{
continue;
}
db.UserBanks.Remove(bank);
}
db.SaveChanges();
return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "userBankList", "", CallBackType.none, ""));
}
catch (Exception ex)
{
return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败！" + ex.Message, "", "", CallBackType.none, ""));
}
}
