/// <summary>
/// 删除还款
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void DelRepayment(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("repayment", "delete", userFromCookie.Id))
{
string ids = context.Request.Params["id"].Trim(',');
if (repaymentBll.DeleteRepaymentList(ids))
{
userOperateLog.OperateInfo = "删除还款费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "删除成功，还款费用主键：" + ids;
context.Response.Write("{\"msg\":\"删除成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "删除还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "删除失败";
context.Response.Write("{\"msg\":\"删除失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "删除还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"];
try
{
DriveMgr.Model.User userFromCookie = DriveMgr.Common.UserHelper.GetUser(context); //获取cookie里的用户对象
userOperateLog = new Model.UserOperateLog();
userOperateLog.UserIp = context.Request.UserHostAddress;
userOperateLog.UserName = userFromCookie.UserId;
switch (action)
{
case "search":
GetExpensesOfOneYear(context);
break;
case "getIncomeTableData":
GetExpensesTableData(context);
break;
default:
context.Response.Write("{\"msg\":\"参数错误！\",\"success\":false}");
break;
}
}
catch (Exception ex)
{
context.Response.Write("{\"msg\":\"" + DriveMgr.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}");
userOperateLog.OperateInfo = "出账统计功能异常";
userOperateLog.IfSuccess = false;
userOperateLog.Description = DriveMgr.Common.JsonHelper.StringFilter(ex.Message);
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
}
/// <summary>
/// 把DataRow行转成实体类对象
/// </summary>
private void DataRowToModel(DriveMgr.Model.User model, DataRow dr)
{
if (!DBNull.Value.Equals(dr["Id"]))
{
model.Id = int.Parse(dr["Id"].ToString());
}
if (!DBNull.Value.Equals(dr["UserId"]))
{
model.UserId = dr["UserId"].ToString();
}
if (!DBNull.Value.Equals(dr["UserName"]))
{
model.UserName = dr["UserName"].ToString();
}
if (!DBNull.Value.Equals(dr["UserPwd"]))
{
model.UserPwd = dr["UserPwd"].ToString();
}
if (!DBNull.Value.Equals(dr["IsAble"]))
{
model.IsAble = bool.Parse(dr["IsAble"].ToString());
}
if (!DBNull.Value.Equals(dr["IfChangePwd"]))
{
model.IfChangePwd = bool.Parse(dr["IfChangePwd"].ToString());
}
if (!DBNull.Value.Equals(dr["AddDate"]))
{
model.AddDate = Convert.ToDateTime(dr["AddDate"]);
}
if (!DBNull.Value.Equals(dr["Description"]))
{
model.Description = dr["Description"].ToString();
}
}
/// <summary>
/// 添加车辆信息
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddVehicle(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("vehicle", "add", userFromCookie.Id))
{
string ui_vehicle_LicencePlateNum_add = context.Request.Params["ui_vehicle_LicencePlateNum_add"] ?? "";
string ui_vehicle_Owner_add = context.Request.Params["ui_vehicle_Owner_add"] ?? "";
string ui_vehicle_Brands_add = context.Request.Params["ui_vehicle_Brands_add"] ?? "";
string ui_vehicle_CarModel_add = context.Request.Params["ui_vehicle_CarModel_add"] ?? "";
string ui_vehicle_BuyPrice_add = context.Request.Params["ui_vehicle_BuyPrice_add"] ?? "";
string ui_vehicle_BuyDate_add = context.Request.Params["ui_vehicle_BuyDate_add"] ?? "";
string ui_vehicle_Remark_add = context.Request.Params["ui_vehicle_Remark_add"] ?? "";
string ui_vehicle_Status_add = context.Request.Params["ui_vehicle_Status_add"] ?? "";
DriveMgr.Model.VehicleModel vehicleAdd = new Model.VehicleModel();
vehicleAdd.LicencePlateNum = ui_vehicle_LicencePlateNum_add.Trim();
vehicleAdd.Owner = ui_vehicle_Owner_add.Trim();
vehicleAdd.Brands = ui_vehicle_Brands_add.Trim();
vehicleAdd.CarModel = ui_vehicle_CarModel_add.Trim();
if (!string.IsNullOrEmpty(ui_vehicle_BuyPrice_add.Trim()))
{
vehicleAdd.BuyPrice = decimal.Parse(ui_vehicle_BuyPrice_add);
}
if (!string.IsNullOrEmpty(ui_vehicle_BuyDate_add.Trim()))
{
vehicleAdd.BuyDate = DateTime.Parse(ui_vehicle_BuyDate_add);
}
vehicleAdd.Remark = ui_vehicle_Remark_add.Trim();
vehicleAdd.Status = Int32.Parse(ui_vehicle_Status_add);
vehicleAdd.CreateDate = DateTime.Now;
vehicleAdd.CreatePerson = userFromCookie.UserId;
vehicleAdd.UpdatePerson = userFromCookie.UserId;
vehicleAdd.UpdateDate = DateTime.Now;
if (vehicleBll.AddVehicle(vehicleAdd))
{
userOperateLog.OperateInfo = "添加车辆信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，车辆：" + ui_vehicle_LicencePlateNum_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加车辆信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加车辆信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加场地出租信息
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddSiteRental(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("siteRental_local", "pay", userFromCookie.Id))
{
int payid = Int32.Parse(context.Request.Params["payid"] ?? "-1");
string ui_siteRental_RentObject_add = context.Request.Params["ui_siteRental_RentObject_pay"] ?? "";
string ui_siteRental_RentDate_add = context.Request.Params["ui_siteRental_RentDate_pay"] ?? "";
string ui_siteRental_LicencePlateNum_add = context.Request.Params["ui_siteRental_LicencePlateNum_pay"] ?? "";
string ui_siteRental_PriceConfig_add = context.Request.Params["ui_siteRental_PriceConfig_pay"] ?? "";
string ui_siteRental_Longer_add = context.Request.Params["ui_siteRental_Longer_pay"] ?? "";
string ui_siteRental_TotalPrice_add = context.Request.Params["ui_siteRental_TotalPrice_pay"] ?? "";
string ui_siteRental_Remark_add = context.Request.Params["ui_siteRental_Remark_pay"] ?? "";
DriveMgr.Model.SiteRentalLocalModel siteRentalAdd = new Model.SiteRentalLocalModel();
siteRentalAdd.StudentsID = payid; //学员ID
if (string.IsNullOrEmpty(ui_siteRental_PriceConfig_add.Trim()))
{
siteRentalAdd.VehicleId = null;
}
else
{
siteRentalAdd.VehicleId = Int32.Parse(ui_siteRental_LicencePlateNum_add.Trim());
}
siteRentalAdd.PriceConfigID = Int32.Parse(ui_siteRental_PriceConfig_add.Trim());
siteRentalAdd.Longer = decimal.Parse(ui_siteRental_Longer_add.Trim());
siteRentalAdd.TotalPrice = decimal.Parse(ui_siteRental_TotalPrice_add.Trim());
siteRentalAdd.RentDate = DateTime.Parse(ui_siteRental_RentDate_add.Trim());
siteRentalAdd.Remark = ui_siteRental_Remark_add.Trim();
siteRentalAdd.CreateDate = DateTime.Now;
siteRentalAdd.CreatePerson = userFromCookie.UserId;
siteRentalAdd.UpdatePerson = userFromCookie.UserId;
siteRentalAdd.UpdateDate = DateTime.Now;
if (siteRentalBll.AddSiteRental(siteRentalAdd))
{
userOperateLog.OperateInfo = payid + "添加场地出租信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，场地出租信息：" + ui_siteRental_LicencePlateNum_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加场地出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加场地出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加物品
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddGoods(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("goods", "add", userFromCookie.Id))
{
string ui_goods_GoodsName_add = context.Request.Params["ui_goods_GoodsName_add"] ?? "";
int ui_goods_GoodsCategory_add = Int32.Parse(context.Request.Params["ui_goods_GoodsCategory_add"]);
int ui_goods_MinQuantity_add = Int32.Parse(context.Request.Params["ui_goods_MinQuantity_add"]);
int ui_goods_MaxQuantity_add = Int32.Parse(context.Request.Params["ui_goods_MaxQuantity_add"]);
int ui_goods_RealQuantity_add = Int32.Parse(context.Request.Params["ui_goods_RealQuantity_add"]);
string ui_goods_Specification_add = context.Request.Params["ui_goods_Specification_add"] ?? "";
string ui_goods_Remark_add = context.Request.Params["ui_goods_Remark_add"] ?? "";
DriveMgr.Model.GoodsModel goodsAdd = new Model.GoodsModel();
goodsAdd.GoodsName = ui_goods_GoodsName_add.Trim();
goodsAdd.GoodsCategoryID = ui_goods_GoodsCategory_add;
goodsAdd.MinQuantity = ui_goods_MinQuantity_add;
goodsAdd.MaxQuantity = ui_goods_MaxQuantity_add;
goodsAdd.RealQuantity = ui_goods_RealQuantity_add;
goodsAdd.Specification = ui_goods_Specification_add.Trim();
goodsAdd.Remark = ui_goods_Remark_add.Trim();
goodsAdd.CreateDate = DateTime.Now;
goodsAdd.CreatePerson = userFromCookie.UserId;
goodsAdd.UpdatePerson = userFromCookie.UserId;
goodsAdd.UpdateDate = DateTime.Now;
if (!goodsBll.IsExistGoods(goodsAdd.GoodsName))
{
if (goodsBll.AddGoods(goodsAdd))
{
userOperateLog.OperateInfo = "添加物品";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，物品：" + ui_goods_GoodsName_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加物品";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
context.Response.Write("{\"msg\":\"该物品已经存在！\",\"success\":true}");
}
}
else
{
userOperateLog.OperateInfo = "添加物品";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加用户
/// </summary>
public int AddUser(Model.User user)
{
DriveMgr.Model.User userCompare = dal.GetUserByUserId(user.UserId);
if (userCompare != null)
{
throw new Exception("已经存在此用户！");
}
return(dal.AddUser(user));
}
/// <summary>
/// 编辑车辆
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditSiteRental(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("siteRental", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.SiteRentalModel siteRentalEdit = siteRentalBll.GetSiteRentalModel(id);
string ui_siteRental_RentObject_edit = context.Request.Params["ui_siteRental_RentObject_edit"] ?? "";
string ui_siteRental_RentDate_edit = context.Request.Params["ui_siteRental_RentDate_edit"] ?? "";
string ui_siteRental_LicencePlateNum_edit = context.Request.Params["ui_siteRental_LicencePlateNum_edit"] ?? "";
string ui_siteRental_PriceConfig_edit = context.Request.Params["ui_siteRental_PriceConfig_edit"] ?? "";
string ui_siteRental_Longer_edit = context.Request.Params["ui_siteRental_Longer_edit"] ?? "";
string ui_siteRental_TotalPrice_edit = context.Request.Params["ui_siteRental_TotalPrice_edit"] ?? "";
string ui_siteRental_Remark_edit = context.Request.Params["ui_siteRental_Remark_edit"] ?? "";
siteRentalEdit.RentObject = ui_siteRental_RentObject_edit.Trim();
if (string.IsNullOrEmpty(ui_siteRental_LicencePlateNum_edit.Trim()))
{
siteRentalEdit.VehicleId = null;
}
else
{
siteRentalEdit.VehicleId = Int32.Parse(ui_siteRental_LicencePlateNum_edit.Trim());
}
siteRentalEdit.PriceConfigID = Int32.Parse(ui_siteRental_PriceConfig_edit.Trim());
siteRentalEdit.Longer = decimal.Parse(ui_siteRental_Longer_edit.Trim());
siteRentalEdit.TotalPrice = decimal.Parse(ui_siteRental_TotalPrice_edit.Trim());
siteRentalEdit.RentDate = DateTime.Parse(ui_siteRental_RentDate_edit.Trim());
siteRentalEdit.Remark = ui_siteRental_Remark_edit.Trim();
siteRentalEdit.UpdatePerson = userFromCookie.UserId;
siteRentalEdit.UpdateDate = DateTime.Now;
if (siteRentalBll.UpdateSiteRental(siteRentalEdit))
{
userOperateLog.OperateInfo = "修改场地出租信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，场地出租信息主键：" + siteRentalEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改场地出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改场地出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加车辆出租信息
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddVehicleRental(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("vehicleRental", "add", userFromCookie.Id))
{
string ui_vehicleRental_StudentName_add = context.Request.Params["ui_vehicleRental_StudentName_add"] ?? "";
//string ui_vehicleRental_StudentCode_add = context.Request.Params["ui_vehicleRental_StudentCode_add"] ?? "";
//string ui_vehicleRental_CoachName_add = context.Request.Params["ui_vehicleRental_CoachName_add"] ?? "";
string ui_vehicleRental_RentDate_add = context.Request.Params["ui_vehicleRental_RentDate_add"] ?? "";
string ui_vehicleRental_LicencePlateNum_add = context.Request.Params["ui_vehicleRental_LicencePlateNum_add"] ?? "";
string ui_vehicleRental_PriceConfig_add = context.Request.Params["ui_vehicleRental_PriceConfig_add"] ?? "";
string ui_vehicleRental_Longer_add = context.Request.Params["ui_vehicleRental_Longer_add"] ?? "";
string ui_vehicleRental_TotalPrice_add = context.Request.Params["ui_vehicleRental_TotalPrice_add"] ?? "";
string ui_vehicleRental_Remark_add = context.Request.Params["ui_vehicleRental_Remark_add"] ?? "";
DriveMgr.Model.VehicleRentalModel vehicleRentalAdd = new Model.VehicleRentalModel();
//vehicleRentalAdd.StudentCode = ui_vehicleRental_StudentName_add.Trim();
vehicleRentalAdd.StudentName = ui_vehicleRental_StudentName_add.Trim();
//vehicleRentalAdd.CoachName = ui_vehicleRental_CoachName_add.Trim();
vehicleRentalAdd.VehicleId = Int32.Parse(ui_vehicleRental_LicencePlateNum_add.Trim());
vehicleRentalAdd.PriceConfigID = Int32.Parse(ui_vehicleRental_PriceConfig_add.Trim());
vehicleRentalAdd.Longer = decimal.Parse(ui_vehicleRental_Longer_add.Trim());
vehicleRentalAdd.TotalPrice = decimal.Parse(ui_vehicleRental_TotalPrice_add.Trim());
vehicleRentalAdd.RentDate = DateTime.Parse(ui_vehicleRental_RentDate_add.Trim());
vehicleRentalAdd.Remark = ui_vehicleRental_Remark_add.Trim();
vehicleRentalAdd.CreateDate = DateTime.Now;
vehicleRentalAdd.CreatePerson = userFromCookie.UserId;
vehicleRentalAdd.UpdatePerson = userFromCookie.UserId;
vehicleRentalAdd.UpdateDate = DateTime.Now;
if (vehicleRentalBll.AddVehicleRental(vehicleRentalAdd))
{
userOperateLog.OperateInfo = "添加车辆出租信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，车辆出租信息：" + ui_vehicleRental_LicencePlateNum_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加车辆出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加车辆出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑车辆
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditVehicleRental(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("vehicleRental", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.VehicleRentalModel vehicleRentalEdit = vehicleRentalBll.GetVehicleRentalModel(id);
string ui_vehicleRental_StudentName_edit = context.Request.Params["ui_vehicleRental_StudentName_edit"] ?? "";
//string ui_vehicleRental_StudentCode_edit = context.Request.Params["ui_vehicleRental_StudentCode_edit"] ?? "";
//string ui_vehicleRental_CoachName_edit = context.Request.Params["ui_vehicleRental_CoachName_edit"] ?? "";
string ui_vehicleRental_RentDate_edit = context.Request.Params["ui_vehicleRental_RentDate_edit"] ?? "";
string ui_vehicleRental_LicencePlateNum_edit = context.Request.Params["ui_vehicleRental_LicencePlateNum_edit"] ?? "";
string ui_vehicleRental_PriceConfig_edit = context.Request.Params["ui_vehicleRental_PriceConfig_edit"] ?? "";
string ui_vehicleRental_Longer_edit = context.Request.Params["ui_vehicleRental_Longer_edit"] ?? "";
string ui_vehicleRental_TotalPrice_edit = context.Request.Params["ui_vehicleRental_TotalPrice_edit"] ?? "";
string ui_vehicleRental_Remark_edit = context.Request.Params["ui_vehicleRental_Remark_edit"] ?? "";
vehicleRentalEdit.StudentName = ui_vehicleRental_StudentName_edit.Trim();
//vehicleRentalEdit.StudentCode = ui_vehicleRental_StudentName_edit.Trim();
//vehicleRentalEdit.CoachName = ui_vehicleRental_CoachName_edit.Trim();
vehicleRentalEdit.VehicleId = Int32.Parse(ui_vehicleRental_LicencePlateNum_edit.Trim());
vehicleRentalEdit.PriceConfigID = Int32.Parse(ui_vehicleRental_PriceConfig_edit.Trim());
vehicleRentalEdit.Longer = decimal.Parse(ui_vehicleRental_Longer_edit.Trim());
vehicleRentalEdit.TotalPrice = decimal.Parse(ui_vehicleRental_TotalPrice_edit.Trim());
vehicleRentalEdit.RentDate = DateTime.Parse(ui_vehicleRental_RentDate_edit.Trim());
vehicleRentalEdit.Remark = ui_vehicleRental_Remark_edit.Trim();
vehicleRentalEdit.UpdatePerson = userFromCookie.UserId;
vehicleRentalEdit.UpdateDate = DateTime.Now;
if (vehicleRentalBll.UpdateVehicleRental(vehicleRentalEdit))
{
userOperateLog.OperateInfo = "修改车辆出租信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，车辆出租信息主键：" + vehicleRentalEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改车辆出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改车辆出租信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加学费
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddTuition(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("tuition", "add", userFromCookie.Id))
{
string ui_tuition_LocalType_add = context.Request.Params["ui_tuition_LocalType_add"] ?? "";
string ui_tuition_Costs_add = context.Request.Params["ui_tuition_Costs_add"] ?? "";
string ui_tuition_Remark_add = context.Request.Params["ui_tuition_Remark_add"] ?? "";
DriveMgr.Model.TuitionModel tuitionAdd = new Model.TuitionModel();
tuitionAdd.Costs = decimal.Parse(ui_tuition_Costs_add);
tuitionAdd.LocalType = Int32.Parse(ui_tuition_LocalType_add);
tuitionAdd.Remark = ui_tuition_Remark_add.Trim();
tuitionAdd.CreateDate = DateTime.Now;
tuitionAdd.CreatePerson = userFromCookie.UserId;
tuitionAdd.UpdatePerson = userFromCookie.UserId;
tuitionAdd.UpdateDate = DateTime.Now;
if (!tuitionBll.IsExistTuition(tuitionAdd.LocalType.Value))
{
if (tuitionBll.AddTuition(tuitionAdd))
{
userOperateLog.OperateInfo = "添加学费";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，学费：" + ui_tuition_Costs_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加学费";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
context.Response.Write("{\"msg\":\"该信息已经存在！\",\"success\":true}");
}
}
else
{
userOperateLog.OperateInfo = "添加学费";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑物品
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditGoods(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("goods", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.GoodsModel goodsEdit = goodsBll.GetGoodsModel(id);
string ui_goods_GoodsName_edit = context.Request.Params["ui_goods_GoodsName_edit"] ?? "";
int ui_goods_GoodsCategory_edit = Int32.Parse(context.Request.Params["ui_goods_GoodsCategory_edit"]);
int ui_goods_MinQuantity_edit = Int32.Parse(context.Request.Params["ui_goods_MinQuantity_edit"]);
int ui_goods_MaxQuantity_edit = Int32.Parse(context.Request.Params["ui_goods_MaxQuantity_edit"]);
int ui_goods_RealQuantity_edit = Int32.Parse(context.Request.Params["ui_goods_RealQuantity_edit"]);
string ui_goods_Specification_edit = context.Request.Params["ui_goods_Specification_edit"] ?? "";
string ui_goods_Remark_edit = context.Request.Params["ui_goods_Remark_edit"] ?? "";
goodsEdit.GoodsName = ui_goods_GoodsName_edit.Trim();
goodsEdit.GoodsCategoryID = ui_goods_GoodsCategory_edit;
goodsEdit.MinQuantity = ui_goods_MinQuantity_edit;
goodsEdit.MaxQuantity = ui_goods_MaxQuantity_edit;
goodsEdit.RealQuantity = ui_goods_RealQuantity_edit;
goodsEdit.Specification = ui_goods_Specification_edit.Trim();
goodsEdit.Remark = ui_goods_Remark_edit.Trim();
goodsEdit.UpdatePerson = userFromCookie.UserId;
goodsEdit.UpdateDate = DateTime.Now;
if (goodsBll.UpdateGoods(goodsEdit))
{
userOperateLog.OperateInfo = "修改物品";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，物品主键：" + goodsEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改物品";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改物品";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加车辆维护信息
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddVehiclMaintenance(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("vehiclMaintenance", "add", userFromCookie.Id))
{
string ui_vehiclMaintenance_LicencePlateNum_add = context.Request.Params["ui_vehiclMaintenance_LicencePlateNum_add"] ?? "";
string ui_vehiclMaintenance_MaintenanceType_add = context.Request.Params["ui_vehiclMaintenance_MaintenanceType_add"] ?? "";
string ui_vehiclMaintenance_MaintenPerson_add = context.Request.Params["ui_vehiclMaintenance_MaintenPerson_add"] ?? "";
string ui_vehiclMaintenance_MaintenCosts_add = context.Request.Params["ui_vehiclMaintenance_MaintenCosts_add"] ?? "";
string ui_vehiclMaintenance_MaintenDate_add = context.Request.Params["ui_vehiclMaintenance_MaintenDate_add"] ?? "";
string ui_vehiclMaintenance_Remark_add = context.Request.Params["ui_vehiclMaintenance_Remark_add"] ?? "";
DriveMgr.Model.VehiclMaintenanceModel vehiclMaintenanceAdd = new Model.VehiclMaintenanceModel();
vehiclMaintenanceAdd.VehicleId = Int32.Parse(ui_vehiclMaintenance_LicencePlateNum_add.Trim());
vehiclMaintenanceAdd.MaintenanceType = Int32.Parse(ui_vehiclMaintenance_MaintenanceType_add.Trim());
vehiclMaintenanceAdd.MaintenPerson = ui_vehiclMaintenance_MaintenPerson_add.Trim();
vehiclMaintenanceAdd.MaintenCosts = decimal.Parse(ui_vehiclMaintenance_MaintenCosts_add);
vehiclMaintenanceAdd.MaintenDate = DateTime.Parse(ui_vehiclMaintenance_MaintenDate_add);
vehiclMaintenanceAdd.Remark = ui_vehiclMaintenance_Remark_add.Trim();
vehiclMaintenanceAdd.CreateDate = DateTime.Now;
vehiclMaintenanceAdd.CreatePerson = userFromCookie.UserId;
vehiclMaintenanceAdd.UpdatePerson = userFromCookie.UserId;
vehiclMaintenanceAdd.UpdateDate = DateTime.Now;
if (vehiclMaintenanceBll.AddVehiclMaintenance(vehiclMaintenanceAdd))
{
userOperateLog.OperateInfo = "添加车辆维护信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，车辆维护信息：" + ui_vehiclMaintenance_LicencePlateNum_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加车辆维护信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加车辆维护信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"];
try
{
DriveMgr.Model.User userFromCookie = DriveMgr.Common.UserHelper.GetUser(context); //获取cookie里的用户对象
userOperateLog = new Model.UserOperateLog();
userOperateLog.UserIp = context.Request.UserHostAddress;
userOperateLog.UserName = userFromCookie.UserId;
switch (action)
{
case "search":
SearchPriceConfig(context);
break;
case "getAll":
string aa = priceConfigBll.GetPriceConfigDT(0);
context.Response.Write(priceConfigBll.GetPriceConfigDT(0));
break;
case "add":
AddPriceConfig(userFromCookie, context);
break;
case "edit":
EditPriceConfig(userFromCookie, context);
break;
case "delete":
DelPriceConfig(userFromCookie, context);
break;
default:
context.Response.Write("{\"msg\":\"参数错误！\",\"success\":false}");
break;
}
}
catch (Exception ex)
{
context.Response.Write("{\"msg\":\"" + DriveMgr.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}");
userOperateLog.OperateInfo = "用户功能异常";
userOperateLog.IfSuccess = false;
userOperateLog.Description = DriveMgr.Common.JsonHelper.StringFilter(ex.Message);
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
}
/// <summary>
/// 添加业务招待费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddBusinessEntertain(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("businessEntertain", "add", userFromCookie.Id))
{
string ui_businessEntertain_EntertainObject_add = context.Request.Params["ui_businessEntertain_EntertainObject_add"] ?? "";
string ui_businessEntertain_EntertainUse_add = context.Request.Params["ui_businessEntertain_EntertainUse_add"] ?? "";
string ui_businessEntertain_Transactor_add = context.Request.Params["ui_businessEntertain_Transactor_add"] ?? "";
string ui_businessEntertain_EntertainAmount_add = context.Request.Params["ui_businessEntertain_EntertainAmount_add"] ?? "";
string ui_businessEntertain_TransactDate_add = context.Request.Params["ui_businessEntertain_TransactDate_add"] ?? "";
string ui_businessEntertain_Remark_add = context.Request.Params["ui_businessEntertain_Remark_add"] ?? "";
DriveMgr.Model.BusinessEntertainModel businessEntertainAdd = new Model.BusinessEntertainModel();
businessEntertainAdd.EntertainObject = ui_businessEntertain_EntertainObject_add.Trim();
businessEntertainAdd.EntertainUse = ui_businessEntertain_EntertainUse_add.Trim();
businessEntertainAdd.Transactor = ui_businessEntertain_Transactor_add.Trim();
businessEntertainAdd.EntertainAmount = decimal.Parse(ui_businessEntertain_EntertainAmount_add);
businessEntertainAdd.TransactDate = DateTime.Parse(ui_businessEntertain_TransactDate_add);
businessEntertainAdd.Remark = ui_businessEntertain_Remark_add.Trim();
businessEntertainAdd.CreateDate = DateTime.Now;
businessEntertainAdd.CreatePerson = userFromCookie.UserId;
businessEntertainAdd.UpdatePerson = userFromCookie.UserId;
businessEntertainAdd.UpdateDate = DateTime.Now;
if (businessEntertainBll.AddBusinessEntertain(businessEntertainAdd))
{
userOperateLog.OperateInfo = "添加业务招待费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，招待对象：" + ui_businessEntertain_EntertainObject_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加业务招待费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加业务招待费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑业务招待费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditBusinessEntertain(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("businessEntertain", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.BusinessEntertainModel businessEntertainEdit = businessEntertainBll.GetBusinessEntertainModel(id);
string ui_businessEntertain_EntertainObject_edit = context.Request.Params["ui_businessEntertain_EntertainObject_edit"] ?? "";
string ui_businessEntertain_EntertainUse_edit = context.Request.Params["ui_businessEntertain_EntertainUse_edit"] ?? "";
string ui_businessEntertain_Transactor_edit = context.Request.Params["ui_businessEntertain_Transactor_edit"] ?? "";
string ui_businessEntertain_EntertainAmount_edit = context.Request.Params["ui_businessEntertain_EntertainAmount_edit"] ?? "";
string ui_businessEntertain_TransactDate_edit = context.Request.Params["ui_businessEntertain_TransactDate_edit"] ?? "";
string ui_businessEntertain_Remark_edit = context.Request.Params["ui_businessEntertain_Remark_edit"] ?? "";
businessEntertainEdit.EntertainObject = ui_businessEntertain_EntertainObject_edit.Trim();
businessEntertainEdit.EntertainUse = ui_businessEntertain_EntertainUse_edit.Trim();
businessEntertainEdit.Transactor = ui_businessEntertain_Transactor_edit.Trim();
businessEntertainEdit.EntertainAmount = decimal.Parse(ui_businessEntertain_EntertainAmount_edit);
businessEntertainEdit.TransactDate = DateTime.Parse(ui_businessEntertain_TransactDate_edit);
businessEntertainEdit.Remark = ui_businessEntertain_Remark_edit.Trim();
businessEntertainEdit.UpdatePerson = userFromCookie.UserId;
businessEntertainEdit.UpdateDate = DateTime.Now;
if (businessEntertainBll.UpdateBusinessEntertain(businessEntertainEdit))
{
userOperateLog.OperateInfo = "修改业务招待费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，业务招待费用主键：" + businessEntertainEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改业务招待费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改业务招待费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 用户登录
/// </summary>
public Model.User UserLogin(string loginId, string loginPwd)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("select top 1 Id,UserId,UserName,UserPwd,IsAble,IfChangePwd,AddDate,Description from tbUser ");
sbSql.Append("where UserId=@UserId and UserPwd=@UserPwd");
SqlParameter[] paras =
{
new SqlParameter("@UserId", loginId),
new SqlParameter("@UserPwd", loginPwd)
};
DriveMgr.Model.User user = null;
DataTable dt = DriveMgr.Common.SqlHelper.GetDataTable(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, sbSql.ToString(), paras);
if (dt.Rows.Count > 0)
{
user = new Model.User();
//DataRowToModel(user, dt.Rows[0]);
//只取部分属性写入cookie（防止某些列特别长，例如description，导致cookie过长）：
if (!DBNull.Value.Equals(dt.Rows[0]["Id"]))
{
user.Id = int.Parse(dt.Rows[0]["Id"].ToString());
}
if (!DBNull.Value.Equals(dt.Rows[0]["UserId"]))
{
user.UserId = dt.Rows[0]["UserId"].ToString();
}
if (!DBNull.Value.Equals(dt.Rows[0]["UserName"]))
{
user.UserName = dt.Rows[0]["UserName"].ToString();
}
if (!DBNull.Value.Equals(dt.Rows[0]["UserPwd"]))
{
user.UserPwd = dt.Rows[0]["UserPwd"].ToString();
}
if (!DBNull.Value.Equals(dt.Rows[0]["IsAble"]))
{
user.IsAble = bool.Parse(dt.Rows[0]["IsAble"].ToString());
}
if (!DBNull.Value.Equals(dt.Rows[0]["IfChangePwd"]))
{
user.IfChangePwd = bool.Parse(dt.Rows[0]["IfChangePwd"].ToString());
}
return(user);
}
return(user);
}
/// <summary>
/// 编辑车辆
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditVehiclMaintenance(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("vehiclMaintenance", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.VehiclMaintenanceModel vehiclMaintenanceEdit = vehiclMaintenanceBll.GetVehiclMaintenanceModel(id);
string ui_vehiclMaintenance_LicencePlateNum_edit = context.Request.Params["ui_vehiclMaintenance_LicencePlateNum_edit"] ?? "";
string ui_vehiclMaintenance_MaintenanceType_edit = context.Request.Params["ui_vehiclMaintenance_MaintenanceType_edit"] ?? "";
string ui_vehiclMaintenance_MaintenPerson_edit = context.Request.Params["ui_vehiclMaintenance_MaintenPerson_edit"] ?? "";
string ui_vehiclMaintenance_MaintenCosts_edit = context.Request.Params["ui_vehiclMaintenance_MaintenCosts_edit"] ?? "";
string ui_vehiclMaintenance_MaintenDate_edit = context.Request.Params["ui_vehiclMaintenance_MaintenDate_edit"] ?? "";
string ui_vehiclMaintenance_Remark_edit = context.Request.Params["ui_vehiclMaintenance_Remark_edit"] ?? "";
vehiclMaintenanceEdit.VehicleId = Int32.Parse(ui_vehiclMaintenance_LicencePlateNum_edit.Trim());
vehiclMaintenanceEdit.MaintenanceType = Int32.Parse(ui_vehiclMaintenance_MaintenanceType_edit.Trim());
vehiclMaintenanceEdit.MaintenPerson = ui_vehiclMaintenance_MaintenPerson_edit.Trim();
vehiclMaintenanceEdit.MaintenCosts = decimal.Parse(ui_vehiclMaintenance_MaintenCosts_edit);
vehiclMaintenanceEdit.MaintenDate = DateTime.Parse(ui_vehiclMaintenance_MaintenDate_edit);
vehiclMaintenanceEdit.Remark = ui_vehiclMaintenance_Remark_edit.Trim();
vehiclMaintenanceEdit.UpdatePerson = userFromCookie.UserId;
vehiclMaintenanceEdit.UpdateDate = DateTime.Now;
if (vehiclMaintenanceBll.UpdateVehiclMaintenance(vehiclMaintenanceEdit))
{
userOperateLog.OperateInfo = "修改车辆维护信息";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，车辆维护信息主键：" + vehiclMaintenanceEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改车辆维护信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改车辆维护信息";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加物资类别
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddGoodsCategory(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("goodsCategory", "add", userFromCookie.Id))
{
string ui_goodsCategory_CategoryName_add = context.Request.Params["ui_goodsCategory_CategoryName_add"] ?? "";
string ui_goodsCategory_Remark_add = context.Request.Params["ui_goodsCategory_Remark_add"] ?? "";
DriveMgr.Model.GoodsCategoryModel goodsCategoryAdd = new Model.GoodsCategoryModel();
goodsCategoryAdd.CategoryName = ui_goodsCategory_CategoryName_add.Trim();
goodsCategoryAdd.Remark = ui_goodsCategory_Remark_add.Trim();
goodsCategoryAdd.CreateDate = DateTime.Now;
goodsCategoryAdd.CreatePerson = userFromCookie.UserId;
goodsCategoryAdd.UpdatePerson = userFromCookie.UserId;
goodsCategoryAdd.UpdateDate = DateTime.Now;
if (!goodsCategoryBll.IsExistGoodsCategory(goodsCategoryAdd.CategoryName))
{
if (goodsCategoryBll.AddGoodsCategory(goodsCategoryAdd))
{
userOperateLog.OperateInfo = "添加物资类别";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，物资类别：" + ui_goodsCategory_CategoryName_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加物资类别";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
context.Response.Write("{\"msg\":\"该物资类别已经存在！\",\"success\":true}");
}
}
else
{
userOperateLog.OperateInfo = "添加物资类别";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加办公费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddOffice(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("office", "add", userFromCookie.Id))
{
string ui_office_OfficeUse_add = context.Request.Params["ui_office_OfficeUse_add"] ?? "";
string ui_office_TagPerson_add = context.Request.Params["ui_office_TagPerson_add"] ?? "";
string ui_office_OfficeAmount_add = context.Request.Params["ui_office_OfficeAmount_add"] ?? "";
string ui_office_UseDate_add = context.Request.Params["ui_office_UseDate_add"] ?? "";
string ui_office_Remark_add = context.Request.Params["ui_office_Remark_add"] ?? "";
DriveMgr.Model.OfficeModel officeAdd = new Model.OfficeModel();
officeAdd.OfficeUse = ui_office_OfficeUse_add.Trim();
officeAdd.TagPerson = ui_office_TagPerson_add.Trim();
officeAdd.OfficeAmount = decimal.Parse(ui_office_OfficeAmount_add);
officeAdd.UseDate = DateTime.Parse(ui_office_UseDate_add);
officeAdd.Remark = ui_office_Remark_add.Trim();
officeAdd.CreateDate = DateTime.Now;
officeAdd.CreatePerson = userFromCookie.UserId;
officeAdd.UpdatePerson = userFromCookie.UserId;
officeAdd.UpdateDate = DateTime.Now;
if (officeBll.AddOffice(officeAdd))
{
userOperateLog.OperateInfo = "添加办公费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，办公用途：" + ui_office_OfficeUse_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加办公费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加办公费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加还款费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddRepayment(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("repayment", "add", userFromCookie.Id))
{
string ui_repayment_Bank_add = context.Request.Params["ui_repayment_Bank_add"] ?? "";
string ui_repayment_RepaymentPerson_add = context.Request.Params["ui_repayment_RepaymentPerson_add"] ?? "";
string ui_repayment_RepaymentAmount_add = context.Request.Params["ui_repayment_RepaymentAmount_add"] ?? "";
string ui_repayment_RepaymentDate_add = context.Request.Params["ui_repayment_RepaymentDate_add"] ?? "";
string ui_repayment_Remark_add = context.Request.Params["ui_repayment_Remark_add"] ?? "";
DriveMgr.Model.RepaymentModel repaymentAdd = new Model.RepaymentModel();
repaymentAdd.Bank = ui_repayment_Bank_add.Trim();
repaymentAdd.RepaymentPerson = ui_repayment_RepaymentPerson_add.Trim();
repaymentAdd.RepaymentAmount = decimal.Parse(ui_repayment_RepaymentAmount_add);
repaymentAdd.RepaymentDate = DateTime.Parse(ui_repayment_RepaymentDate_add);
repaymentAdd.Remark = ui_repayment_Remark_add.Trim();
repaymentAdd.CreateDate = DateTime.Now;
repaymentAdd.CreatePerson = userFromCookie.UserId;
repaymentAdd.UpdatePerson = userFromCookie.UserId;
repaymentAdd.UpdateDate = DateTime.Now;
if (repaymentBll.AddRepayment(repaymentAdd))
{
userOperateLog.OperateInfo = "添加还款费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，还款银行：" + ui_repayment_Bank_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加贷款费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddLoan(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("loan", "add", userFromCookie.Id))
{
string ui_loan_Bank_add = context.Request.Params["ui_loan_Bank_add"] ?? "";
string ui_loan_Lenders_add = context.Request.Params["ui_loan_Lenders_add"] ?? "";
string ui_loan_LoanAmount_add = context.Request.Params["ui_loan_LoanAmount_add"] ?? "";
string ui_loan_LoanDate_add = context.Request.Params["ui_loan_LoanDate_add"] ?? "";
string ui_loan_Remark_add = context.Request.Params["ui_loan_Remark_add"] ?? "";
DriveMgr.Model.LoanModel loanAdd = new Model.LoanModel();
loanAdd.Bank = ui_loan_Bank_add.Trim();
loanAdd.Lenders = ui_loan_Lenders_add.Trim();
loanAdd.LoanAmount = decimal.Parse(ui_loan_LoanAmount_add);
loanAdd.LoanDate = DateTime.Parse(ui_loan_LoanDate_add);
loanAdd.Remark = ui_loan_Remark_add.Trim();
loanAdd.CreateDate = DateTime.Now;
loanAdd.CreatePerson = userFromCookie.UserId;
loanAdd.UpdatePerson = userFromCookie.UserId;
loanAdd.UpdateDate = DateTime.Now;
if (loanBll.AddLoan(loanAdd))
{
userOperateLog.OperateInfo = "添加贷款费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，贷款银行：" + ui_loan_Bank_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加贷款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加贷款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加差旅费用
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddTravel(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("travel", "add", userFromCookie.Id))
{
string ui_travel_TravelUse_add = context.Request.Params["ui_travel_TravelUse_add"] ?? "";
string ui_travel_TravelPerson_add = context.Request.Params["ui_travel_TravelPerson_add"] ?? "";
string ui_travel_TravelAmount_add = context.Request.Params["ui_travel_TravelAmount_add"] ?? "";
string ui_travel_TraveDate_add = context.Request.Params["ui_travel_TraveDate_add"] ?? "";
string ui_travel_Remark_add = context.Request.Params["ui_travel_Remark_add"] ?? "";
DriveMgr.Model.TravelModel travelAdd = new Model.TravelModel();
travelAdd.TravelUse = ui_travel_TravelUse_add.Trim();
travelAdd.TravelPerson = ui_travel_TravelPerson_add.Trim();
travelAdd.TravelAmount = decimal.Parse(ui_travel_TravelAmount_add);
travelAdd.TraveDate = DateTime.Parse(ui_travel_TraveDate_add);
travelAdd.Remark = ui_travel_Remark_add.Trim();
travelAdd.CreateDate = DateTime.Now;
travelAdd.CreatePerson = userFromCookie.UserId;
travelAdd.UpdatePerson = userFromCookie.UserId;
travelAdd.UpdateDate = DateTime.Now;
if (travelBll.AddTravel(travelAdd))
{
userOperateLog.OperateInfo = "添加差旅费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，差旅用途：" + ui_travel_TravelUse_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加差旅费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加差旅费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 添加单价配置
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void AddPriceConfig(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("priceConfig", "add", userFromCookie.Id))
{
string ui_priceConfig_PriceTypeName_add = context.Request.Params["ui_priceConfig_PriceTypeName_add"] ?? "";
string ui_priceConfig_ConfigType_add = context.Request.Params["ui_priceConfig_ConfigType_add"] ?? "";
string ui_priceConfig_Price_add = context.Request.Params["ui_priceConfig_Price_add"] ?? "";
string ui_priceConfig_Remark_add = context.Request.Params["ui_priceConfig_Remark_add"] ?? "";
string test = context.Request.Params["ccTest"] ?? "";
DriveMgr.Model.PriceConfigModel priceConfigAdd = new Model.PriceConfigModel();
priceConfigAdd.PriceTypeName = ui_priceConfig_PriceTypeName_add.Trim();
priceConfigAdd.Price = decimal.Parse(ui_priceConfig_Price_add);
priceConfigAdd.ConfigType = Int32.Parse(ui_priceConfig_ConfigType_add);
priceConfigAdd.Remark = ui_priceConfig_Remark_add.Trim();
priceConfigAdd.CreateDate = DateTime.Now;
priceConfigAdd.CreatePerson = userFromCookie.UserId;
priceConfigAdd.UpdatePerson = userFromCookie.UserId;
priceConfigAdd.UpdateDate = DateTime.Now;
if (priceConfigBll.AddPriceConfig(priceConfigAdd))
{
userOperateLog.OperateInfo = "添加单价配置";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，单价配置：" + ui_priceConfig_PriceTypeName_add.Trim();
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加单价配置";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加单价配置";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑还款
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditRepayment(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("repayment", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.RepaymentModel repaymentEdit = repaymentBll.GetRepaymentModel(id);
string ui_repayment_Bank_edit = context.Request.Params["ui_repayment_Bank_edit"] ?? "";
string ui_repayment_RepaymentPerson_edit = context.Request.Params["ui_repayment_RepaymentPerson_edit"] ?? "";
string ui_repayment_RepaymentAmount_edit = context.Request.Params["ui_repayment_RepaymentAmount_edit"] ?? "";
string ui_repayment_RepaymentDate_edit = context.Request.Params["ui_repayment_RepaymentDate_edit"] ?? "";
string ui_repayment_Remark_edit = context.Request.Params["ui_repayment_Remark_edit"] ?? "";
repaymentEdit.Bank = ui_repayment_Bank_edit.Trim();
repaymentEdit.RepaymentPerson = ui_repayment_RepaymentPerson_edit.Trim();
repaymentEdit.RepaymentAmount = decimal.Parse(ui_repayment_RepaymentAmount_edit);
repaymentEdit.RepaymentDate = DateTime.Parse(ui_repayment_RepaymentDate_edit);
repaymentEdit.Remark = ui_repayment_Remark_edit.Trim();
repaymentEdit.UpdatePerson = userFromCookie.UserId;
repaymentEdit.UpdateDate = DateTime.Now;
if (repaymentBll.UpdateRepayment(repaymentEdit))
{
userOperateLog.OperateInfo = "修改还款费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，还款费用主键：" + repaymentEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改还款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑贷款
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditLoan(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("loan", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.LoanModel loanEdit = loanBll.GetLoanModel(id);
string ui_loan_Bank_edit = context.Request.Params["ui_loan_Bank_edit"] ?? "";
string ui_loan_Lenders_edit = context.Request.Params["ui_loan_Lenders_edit"] ?? "";
string ui_loan_LoanAmount_edit = context.Request.Params["ui_loan_LoanAmount_edit"] ?? "";
string ui_loan_LoanDate_edit = context.Request.Params["ui_loan_LoanDate_edit"] ?? "";
string ui_loan_Remark_edit = context.Request.Params["ui_loan_Remark_edit"] ?? "";
loanEdit.Bank = ui_loan_Bank_edit.Trim();
loanEdit.Lenders = ui_loan_Lenders_edit.Trim();
loanEdit.LoanAmount = decimal.Parse(ui_loan_LoanAmount_edit);
loanEdit.LoanDate = DateTime.Parse(ui_loan_LoanDate_edit);
loanEdit.Remark = ui_loan_Remark_edit.Trim();
loanEdit.UpdatePerson = userFromCookie.UserId;
loanEdit.UpdateDate = DateTime.Now;
if (loanBll.UpdateLoan(loanEdit))
{
userOperateLog.OperateInfo = "修改贷款费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，贷款费用主键：" + loanEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改贷款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改贷款费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑差旅
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditTravel(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("travel", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.TravelModel travelEdit = travelBll.GetTravelModel(id);
string ui_travel_TravelUse_edit = context.Request.Params["ui_travel_TravelUse_edit"] ?? "";
string ui_travel_TravelPerson_edit = context.Request.Params["ui_travel_TravelPerson_edit"] ?? "";
string ui_travel_TravelAmount_edit = context.Request.Params["ui_travel_TravelAmount_edit"] ?? "";
string ui_travel_TraveDate_edit = context.Request.Params["ui_travel_TraveDate_edit"] ?? "";
string ui_travel_Remark_edit = context.Request.Params["ui_travel_Remark_edit"] ?? "";
travelEdit.TravelUse = ui_travel_TravelUse_edit.Trim();
travelEdit.TravelPerson = ui_travel_TravelPerson_edit.Trim();
travelEdit.TravelAmount = decimal.Parse(ui_travel_TravelAmount_edit);
travelEdit.TraveDate = DateTime.Parse(ui_travel_TraveDate_edit);
travelEdit.Remark = ui_travel_Remark_edit.Trim();
travelEdit.UpdatePerson = userFromCookie.UserId;
travelEdit.UpdateDate = DateTime.Now;
if (travelBll.UpdateTravel(travelEdit))
{
userOperateLog.OperateInfo = "修改差旅费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，差旅费用主键：" + travelEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改差旅费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改差旅费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 编辑办公
/// </summary>
/// <param name="userFromCookie"></param>
/// <param name="context"></param>
private void EditOffice(DriveMgr.Model.User userFromCookie, HttpContext context)
{
if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("office", "edit", userFromCookie.Id))
{
int id = Convert.ToInt32(context.Request.Params["id"]);
DriveMgr.Model.OfficeModel officeEdit = officeBll.GetOfficeModel(id);
string ui_office_OfficeUse_edit = context.Request.Params["ui_office_OfficeUse_edit"] ?? "";
string ui_office_TagPerson_edit = context.Request.Params["ui_office_TagPerson_edit"] ?? "";
string ui_office_OfficeAmount_edit = context.Request.Params["ui_office_OfficeAmount_edit"] ?? "";
string ui_office_UseDate_edit = context.Request.Params["ui_office_UseDate_edit"] ?? "";
string ui_office_Remark_edit = context.Request.Params["ui_office_Remark_edit"] ?? "";
officeEdit.OfficeUse = ui_office_OfficeUse_edit.Trim();
officeEdit.TagPerson = ui_office_TagPerson_edit.Trim();
officeEdit.OfficeAmount = decimal.Parse(ui_office_OfficeAmount_edit);
officeEdit.UseDate = DateTime.Parse(ui_office_UseDate_edit);
officeEdit.Remark = ui_office_Remark_edit.Trim();
officeEdit.UpdatePerson = userFromCookie.UserId;
officeEdit.UpdateDate = DateTime.Now;
if (officeBll.UpdateOffice(officeEdit))
{
userOperateLog.OperateInfo = "修改办公费用";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，办公费用主键：" + officeEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改办公费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改办公费用";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
/// <summary>
/// 根据id获取用户
/// </summary>
public Model.User GetUserById(string id)
{
string sql = "select * from tbUser where Id = @Id";
DriveMgr.Model.User user = null;
DataTable dt = DriveMgr.Common.SqlHelper.GetDataTable(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, sql, new SqlParameter("@Id", id));
if (dt.Rows.Count > 0)
{
user = new DriveMgr.Model.User();
DataRowToModel(user, dt.Rows[0]);
return(user);
}
else
{
return(null);
}
}
/// <summary>
/// 根据用户id判断用户是否可用
/// </summary>
public Model.User CheckLoginByUserId(string userId)
{
string sql = "select top 1 Id,UserId,UserName,UserPwd,IsAble,IfChangePwd,AddDate,Description from tbUser where UserId=@UserId";
DriveMgr.Model.User user = null;
DataTable dt = DriveMgr.Common.SqlHelper.GetDataTable(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, sql, new SqlParameter("@UserId", userId));
if (dt.Rows.Count > 0)
{
user = new DriveMgr.Model.User();
DataRowToModel(user, dt.Rows[0]);
return(user);
}
else
{
return(null);
}
}
