public ActionResult SubmitUserForm(string KeyValue, Base_User base_user, Base_Employee base_employee, string BuildFormJson) { string ModuleId = DESEncrypt.Decrypt(CookieHelper.GetCookie("ModuleId")); IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { string Message = KeyValue == "" ? "新增成功。" : "编辑成功。"; if (!string.IsNullOrEmpty(KeyValue)) { //原来无权限修改本人信息 - 改为可以 //if (KeyValue == ManageProvider.Provider.Current().UserId) //{ // throw new Exception("无权限编辑本人信息"); //} base_user.Modify(KeyValue); //base_employee.Modify(KeyValue); database.Update(base_user, isOpenTrans); //database.Update(base_employee, isOpenTrans); } else //新建用户 { base_user.Create(); base_user.SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")); //定义为上级id base_user.InnerUser = ManageProvider.Provider.Current().InnerUser + 1; //用户层级 base_user.DepartmentId = ManageProvider.Provider.Current().UserName; //上级用户姓名 base_user.CompanyId = ManageProvider.Provider.Current().Account; //上级用户帐号 base_user.Code = ManageProvider.Provider.Current().UserId; //上级用户的id database.Insert(base_user, isOpenTrans); //权限分配-复制上级权限 CopyUserRight(ManageProvider.Provider.Current().UserId, base_user.UserId, isOpenTrans); Base_DataScopePermissionBll.Instance.AddScopeDefault(ModuleId, ManageProvider.Provider.Current().UserId, base_user.UserId, isOpenTrans); } Base_FormAttributeBll.Instance.SaveBuildForm(BuildFormJson, base_user.UserId, ModuleId, isOpenTrans); database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = Message }.ToString())); } catch (Exception ex) { database.Rollback(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
public ActionResult SubmitUserForm(string KeyValue, Base_User base_user, Base_Employee base_employee, string BuildFormJson) { string ModuleId = DESEncrypt.Decrypt(CookieHelper.GetCookie("ModuleId")); IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { string Message = KeyValue == "" ? "新增成功。" : "编辑成功。"; if (!string.IsNullOrEmpty(KeyValue)) { if (KeyValue == ManageProvider.Provider.Current().UserId) { throw new Exception("无权限编辑本人信息"); } base_user.Modify(KeyValue); base_employee.Modify(KeyValue); database.Update(base_user, isOpenTrans); database.Update(base_employee, isOpenTrans); } else { base_user.Create(); base_user.SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")); base_employee.Create(); base_employee.EmployeeId = base_user.UserId; base_employee.UserId = base_user.UserId; database.Insert(base_user, isOpenTrans); database.Insert(base_employee, isOpenTrans); Base_DataScopePermissionBll.Instance.AddScopeDefault(ModuleId, ManageProvider.Provider.Current().UserId, base_user.UserId, isOpenTrans); } Base_FormAttributeBll.Instance.SaveBuildForm(BuildFormJson, base_user.UserId, ModuleId, isOpenTrans); database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = Message }.ToString())); } catch (Exception ex) { database.Rollback(); database.Close(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
public ActionResult SubmitProductForm(string keyValue, ProductEntity product, string buildFormJson) { string moduleId = DESEncrypt.Decrypt(CookieHelper.GetCookie("ModuleId")); IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { string message = keyValue == "" ? "新增成功。" : "编辑成功。"; if (!string.IsNullOrEmpty(keyValue)) { if (keyValue == ManageProvider.Provider.Current().UserId) { throw new Exception("无权限编辑本人信息"); } product.Modify(keyValue); database.Update(product, isOpenTrans); } else { product.Create(); product.SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <ProductEntity>("SortCode")); database.Insert(product, isOpenTrans); BaseDataScopePermissionBLL.Instance.AddScopeDefault(moduleId, ManageProvider.Provider.Current().UserId, product.ProductId, isOpenTrans); } Base_FormAttributeBll.Instance.SaveBuildForm(buildFormJson, product.ProductId, moduleId, isOpenTrans); database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = message }.ToString())); } catch (Exception ex) { database.Rollback(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
public ActionResult SortManage() { ViewBag.SortCode = BaseFactory.BaseHelper().GetSortCode <Base_DataDictionary>("SortCode").ToString(); return(View()); }
public ActionResult SubmitUserForm(string KeyValue, BaseUser Baseuser, BaseEmployee Baseemployee, string BuildFormJson) { string ModuleId = DESEncrypt.Decrypt(WebHelper.GetCookie("ModuleId")); IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { var old = database.FindEntity <BaseEmployee>(Baseuser.Code); string message = KeyValue == "" ? "新增成功。" : "编辑成功。"; if (string.IsNullOrEmpty(Baseemployee.DefaultShift)) { Baseemployee.DefaultShift = "A01"; } //if (Baseemployee.IsDimission == 1) { } //if (Baseemployee.IsDimission == 0) Baseemployee.DimissionDate = DateTime.Now; Baseemployee.IsShift = Request.Params["IsShift"] == "1"; if (!string.IsNullOrEmpty(KeyValue)) { Baseuser.Modify(KeyValue); Baseemployee.Modify(KeyValue); Baseemployee.EmpNo = Baseuser.UserId; database.Update(Baseuser, isOpenTrans); database.Update(Baseemployee, isOpenTrans); } else { Baseemployee.IsShift = Request.Params["IsShift"] == "1"; Baseuser.Create(); Baseuser.CompanyId = new RepositoryFactory <BaseDepartment>().Repository().FindEntity(Baseuser.DepartmentId).CompanyId; Baseuser.SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <BaseUser>("SortCode")); Baseemployee.Create(); Baseemployee.EmpNo = Baseuser.UserId; database.Insert(Baseuser, isOpenTrans); database.Insert(Baseemployee, isOpenTrans); BaseDataScopePermissionBll.Instance.AddScopeDefault(ModuleId, ManageProvider.Provider.Current().UserId, Baseuser.UserId, isOpenTrans); } BaseFormAttributeBll.Instance.SaveBuildForm(BuildFormJson, Baseuser.UserId, ModuleId, isOpenTrans); if (old.CardNo != Baseemployee.CardNo) { StringBuilder sql = new StringBuilder("INSERT INTO [EastRiver].[dbo].[WhiteCardTask] ([card_id] ,[card_Sn],[emp_id],[emp_fname],[flag],[clock_id],[cardtype],[cardtypecode],[areacode],[opdate],[operator],[ExecuteDate],[RealCardNo],[timebound])" + $" VALUES (@CARD_NO, '', @EMP_NO, @EMP_NAME, 1, 2, 1, '8669', '0000', GETDATE(), 'Admin', null, '', '')"); List <DbParameter> parameter = new List <DbParameter> { DbFactory.CreateDbParameter("@CARD_NO", Baseemployee.CardNo), DbFactory.CreateDbParameter("@EMP_NO", Baseemployee.EmpNo), DbFactory.CreateDbParameter("@EMP_NAME", Baseemployee.RealName) }; database.ExecuteBySql(sql, parameter.ToArray(), isOpenTrans); } database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = message }.ToString())); } catch (Exception ex) { database.Rollback(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
public ActionResult SubmitUserForm(string KeyValue, Ho_PartnerUser model, string BuildFormJson) { IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { string Message = KeyValue == "" ? "新增成功。" : "编辑成功。"; if (!string.IsNullOrEmpty(KeyValue)) { var userList = database.FindList <Base_User>(" and Account = '" + model.Account + "'"); if (model.UserRole == "运营商")//选择了运营商才添加 { if (userList.Count < 1) { //如果添加运营商,则要往后台用户表添加一个帐号 var user = new Base_User() { Account = model.Account, Password = "******", RealName = model.Name, Mobile = model.Account, SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")), InnerUser = 3, DepartmentId = "运营商", CompanyId = KeyValue, //把用户编号记录 Code = "bd548d5b-1783-4582-9007-bb5c87803679" }; user.Create(); user.Password = model.Password; database.Insert(user, isOpenTrans); //权限分配-复制上级权限-bd548d5b-1783-4582-9007-bb5c87803679(此用户不能删除) CopyUserRight("bd548d5b-1783-4582-9007-bb5c87803679", user.UserId, isOpenTrans); } else { //修改后台用户信息 userList[0].Account = model.Account; userList[0].RealName = model.Name; userList[0].ModifyDate = DateTime.Now; database.Update(userList[0]); } } else { if (userList.Count > 0) { //删除已有后台用户 database.Delete <Base_User>(userList[0].UserId); } } model.Modify(KeyValue); var IsOk = database.Update(model, isOpenTrans); Base_SysLogBll.Instance.WriteLog(KeyValue, OperationType.Update, IsOk > 0 ? "成功" : "失败", "用户" + Message); } else //新建 { //检测手机号和身份证号的唯一性 var accountIsMobile = database.FindEntityByWhere <Ho_PartnerUser>(" and Account='" + model.Account + "'"); if (accountIsMobile != null && accountIsMobile.Number != null) { return(Content(new JsonMessage { Success = false, Code = "1", Message = "手机号码已存在" }.ToString())); } if (!string.IsNullOrEmpty(model.CardCode)) { var accountIsCardCode = database.FindEntityByWhere <Ho_PartnerUser>(" and CardCode='" + model.CardCode + "'"); if (accountIsCardCode != null && accountIsCardCode.Number != null) { return(Content(new JsonMessage { Success = false, Code = "1", Message = "身份证号码已存在" }.ToString())); } } model.Password = PasswordHash.CreateHash(model.Password); model.Create(); var IsOk = database.Insert(model, isOpenTrans); if (model.UserRole == "运营商")//选择了运营商才添加 { //如果添加运营商,则要往后台用户表添加一个帐号 var user = new Base_User() { Account = model.Account, Password = model.Password, RealName = model.Name, Mobile = model.Account, SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")), InnerUser = 3, DepartmentId = "运营商", CompanyId = model.Number, Code = "bd548d5b-1783-4582-9007-bb5c87803679" }; user.Create(); database.Insert(user, isOpenTrans); //权限分配-复制上级权限-bd548d5b-1783-4582-9007-bb5c87803679(此用户不能删除) CopyUserRight("bd548d5b-1783-4582-9007-bb5c87803679", user.UserId, isOpenTrans); } Base_SysLogBll.Instance.WriteLog(KeyValue, OperationType.Update, IsOk > 0 ? "成功" : "失败", "用户" + Message); } database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = Message }.ToString())); } catch (Exception ex) { database.Rollback(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
/// <summary> /// 返回显示顺序号 /// </summary> /// <returns></returns> public virtual ActionResult SortCode() { string strCode = BaseFactory.BaseHelper().GetSortCode <TEntity>("SortCode").ToString(); return(Content(strCode)); }
/// <summary> /// 验证对象值不能重复 /// </summary> /// <param name="tablename">实体类</param> /// <param name="fieldname">属性字段</param> /// <param name="fieldvalue">属性字段值</param> /// <param name="keyfield">主键字段</param> /// <param name="keyvalue">主键字段值</param> /// <returns></returns> public ActionResult FieldExist(string tablename, string fieldname, string fieldvalue, string keyfield, string keyvalue) { bool IsOk = BaseFactory.BaseHelper().FieldExist(tablename, fieldname, fieldvalue, keyfield, keyvalue); return(Content(IsOk.ToString().ToLower())); }