public static bool UpdateRightUser(RightUser rightUser, out string msg)
{
var lstData = RightUserDal.QueryRightUserByUserId(rightUser.UserId);
if (lstData != null)
{
foreach (var info in lstData)
{
if (info.Sysid == rightUser.Sysid)
{
continue;
}
msg = "工号不能重复";
return(false);
}
}
if (!RightUserDal.Update(rightUser))
{
msg = "更新用户信息保存失败";
return(false);
}
msg = "操作成功";
return(true);
}
public static bool Delete(RightUser rightUser)
{
using (var conn = new SqlConnection(Conn.getConn()))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (var trans = conn.BeginTransaction())
{
//1、删除用户信息
var result = Delete(rightUser, conn, trans);
if (!result)
{
trans.Rollback();
return(false);
}
//2、删除当前用户对应的用户分组信息
RightLkUserGroupDal.DeleteByUserSysid(new RightLkUserGroup {
UserSysid = rightUser.Sysid
}, conn, trans);
trans.Commit();
}
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
return(true);
}
public static bool Delete(RightUser rightUser)
{
using (var conn = new SqlConnection(Conn.getConn()))
{
if (conn.State != ConnectionState.Open)
conn.Open();
using (var trans = conn.BeginTransaction())
{
//1、删除用户信息
var result = Delete(rightUser, conn, trans);
if (!result)
{
trans.Rollback();
return false;
}
//2、删除当前用户对应的用户分组信息
RightLkUserGroupDal.DeleteByUserSysid(new RightLkUserGroup { UserSysid = rightUser.Sysid }, conn, trans);
trans.Commit();
}
if (conn.State != ConnectionState.Closed)
conn.Close();
}
return true;
}
//新增数据
/// <summary>
/// 新增数据
/// </summary>
/// <returns></returns>
internal override bool Add()
{
EditEntity = null;
pageViewMain.SelectedPage = pageEdit;
UI.ClearUi(pageEdit);
UI.ReadOnlyUi(pageEdit, false);
return true;
}
public static bool Delete(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_USER
WHERE SYSID=@Sysid
";
return(Dapper.Save(rightUser, sql, conn, trans));
}
public static bool Insert(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_USER(SYSID,USER_ID,USER_NAME,USER_PWD,DEPARTMENT,EMAIL,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,RECORD_STATUS,RESV01,RESV02,RESV03,RESV04,RESV05,RESV06,RESV07,RESV08,RESV09,RESV10)
VALUES(@Sysid,@UserId,@UserName,@UserPwd,@Department,@Email,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy,CONVERT(NVARCHAR(50),GETDATE(),121),@ModifiedBy,@RecordStatus,@Resv01,@Resv02,@Resv03,@Resv04,@Resv05,@Resv06,@Resv07,@Resv08,@Resv09,@Resv10)
";
return Dapper.Save(rightUser, sql, conn, trans);
}
public static bool Insert(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_USER(SYSID,USER_ID,USER_NAME,USER_PWD,DEPARTMENT,EMAIL,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,RECORD_STATUS,RESV01,RESV02,RESV03,RESV04,RESV05,RESV06,RESV07,RESV08,RESV09,RESV10)
VALUES(@Sysid,@UserId,@UserName,@UserPwd,@Department,@Email,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy,CONVERT(NVARCHAR(50),GETDATE(),121),@ModifiedBy,@RecordStatus,@Resv01,@Resv02,@Resv03,@Resv04,@Resv05,@Resv06,@Resv07,@Resv08,@Resv09,@Resv10)
";
return(Dapper.Save(rightUser, sql, conn, trans));
}
public static bool Delete(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_USER
WHERE SYSID=@Sysid
";
return Dapper.Save(rightUser, sql, conn, trans);
}
public static bool Update(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
UPDATE T_RIGHT_USER
SET USER_ID=@UserId,USER_NAME=@UserName,USER_PWD=@UserPwd,DEPARTMENT=@Department,,EMAIL=@Email,CREATED_BY=@CreatedBy,MODIFIED_ON=CONVERT(NVARCHAR(50),GETDATE(),121),MODIFIED_BY=@ModifiedBy,RECORD_STATUS=@RecordStatus,RESV01=@Resv01,RESV02=@Resv02,RESV03=@Resv03,RESV04=@Resv04,RESV05=@Resv05,RESV06=@Resv06,RESV07=@Resv07,RESV08=@Resv08,RESV09=@Resv09,RESV10=@Resv10
WHERE SYSID=@Sysid
";
return(Dapper.Save(rightUser, sql, conn, trans));
}
public static bool InsertRightUser(RightUser rightUser, out string msg)
{
var lstData = RightUserDal.QueryRightUserByUserId(rightUser.UserId);
if (lstData != null && lstData.Count > 0)
{
msg = "工号不能重复";
return false;
}
if (!RightUserDal.Insert(rightUser))
{
msg = "增加用户信息保存失败";
return false;
}
msg = "操作成功";
return true;
}
public static bool InsertRightUser(RightUser rightUser, out string msg)
{
var lstData = RightUserDal.QueryRightUserByUserId(rightUser.UserId);
if (lstData != null && lstData.Count > 0)
{
msg = "工号不能重复";
return(false);
}
if (!RightUserDal.Insert(rightUser))
{
msg = "增加用户信息保存失败";
return(false);
}
msg = "操作成功";
return(true);
}
//删除数据
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
internal override bool Delete()
{
if (EditEntity == null)
{
UI.ShowWarn("请选择待删除数据");
return false;
}
if (!UI.Confirm("确定要删除吗？"))
return false;
if (!RightUserBll.DeleteRightUser(EditEntity))
{
UI.ShowError("删除失败");
return false;
}
EditEntity = null;
UI.ClearUi(pageEdit);
return true;
}
//设置选中的实体
/// <summary>
/// 设置选中的实体
/// </summary>
private void SetSelectedEntity()
{
if (grdQueryResult.SelectedRows == null ||
grdQueryResult.SelectedRows.Count <= 0)
return;
EditEntity = grdQueryResult.SelectedRows[0].DataBoundItem as RightUser;
InitEditForm();
}
public static bool DeleteRightUser(RightUser rightUser)
{
return(RightUserDal.Delete(rightUser));
}
public static bool UpdateRightUser(RightUser rightUser, out string msg)
{
var lstData = RightUserDal.QueryRightUserByUserId(rightUser.UserId);
if (lstData != null)
{
foreach (var info in lstData)
{
if (info.Sysid == rightUser.Sysid)
continue;
msg = "工号不能重复";
return false;
}
}
if (!RightUserDal.Update(rightUser))
{
msg = "更新用户信息保存失败";
return false;
}
msg = "操作成功";
return true;
}
//用编辑框数据填充实体
/// <summary>
/// 用编辑框数据填充实体
/// </summary>
private void BuildEntity()
{
if (CurrentOperationStatus == OperationStatus.New)
{
EditEntity = new RightUser
{
Sysid = Sysid.NewId(""),
UserPwd = CryptoHelper.ToMd5("123456"),
CreatedBy = GloableData.Instance.UserId
};
}
else if (CurrentOperationStatus == OperationStatus.Edit)
{
if (UI.GetValue(chkIsChangePassword) == "1")
{
EditEntity.UserPwd = CryptoHelper.ToMd5("123456");
}
}
EditEntity.ModifiedBy = GloableData.Instance.UserId;
EditEntity.Department = UI.GetValue(ddlDepName);
EditEntity.UserId = UI.GetUpperValue(txtUserId);
EditEntity.UserName = UI.GetValue(txtUserName);
EditEntity.Email = UI.GetValue(txtEmail);
EditEntity.RecordStatus = UI.GetValue(chkIsEnable);
}
public static bool Update(RightUser rightUser, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
UPDATE T_RIGHT_USER
SET USER_ID=@UserId,USER_NAME=@UserName,USER_PWD=@UserPwd,DEPARTMENT=@Department,,EMAIL=@Email,CREATED_BY=@CreatedBy,MODIFIED_ON=CONVERT(NVARCHAR(50),GETDATE(),121),MODIFIED_BY=@ModifiedBy,RECORD_STATUS=@RecordStatus,RESV01=@Resv01,RESV02=@Resv02,RESV03=@Resv03,RESV04=@Resv04,RESV05=@Resv05,RESV06=@Resv06,RESV07=@Resv07,RESV08=@Resv08,RESV09=@Resv09,RESV10=@Resv10
WHERE SYSID=@Sysid
";
return Dapper.Save(rightUser, sql, conn, trans);
}
public static bool DeleteRightUser(RightUser rightUser)
{
return RightUserDal.Delete(rightUser);
}