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()));
}
