public static bool Delete(RightFunctionGroup rightFunctionGroup)
{
using (var conn = new SqlConnection(Conn.getConn()))
{
if (conn.State != ConnectionState.Open)
conn.Open();
using (var trans = conn.BeginTransaction())
{
//1、删除功能组
var result = Delete(rightFunctionGroup, conn, trans);
if (!result)
{
trans.Rollback();
return false;
}
//2、删除当前组对应的功能分组信息
RightLkFunctionGroupDal.DeleteByGroupSysid(new RightLkFunctionGroup { GroupSysid = rightFunctionGroup.Sysid }, conn, trans);
//3、删除当前组对应的权限分配信息
RightDal.DeleteByFunctionGroupSysid(new Right { FunctionGroupSysid = rightFunctionGroup.Sysid }, conn, trans);
trans.Commit();
}
if (conn.State != ConnectionState.Closed)
conn.Close();
}
return true;
}
public static bool Insert(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_FUNCTION_GROUP(SYSID,GROUP_NAME,SEQUENCE,GROUP_NAME_CN,GROUP_NAME_US,GROUP_NAME_TW,GROUP_NAME_EN,GROUP_NAME_GE,GROUP_NAME_VI,GROUP_NAME_JP,GROUP_NAME_KO,GROUP_NAME_FR,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,RECORD_STATUS)
VALUES(@Sysid,@GroupName,@Sequence,@GroupNameCn,@GroupNameUs,@GroupNameTw,@GroupNameEn,@GroupNameGe,@GroupNameVi,@GroupNameJp,@GroupNameKo,@GroupNameFr,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy,CONVERT(NVARCHAR(50),GETDATE(),121),@ModifiedBy,@RecordStatus)
";
return Dapper.Save(rightFunctionGroup, sql, conn, trans);
}
public static bool Delete(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_FUNCTION_GROUP
WHERE SYSID=@Sysid
";
return Dapper.Save(rightFunctionGroup, sql, conn, trans);
}
public static bool Delete(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
DELETE FROM T_RIGHT_FUNCTION_GROUP
WHERE SYSID=@Sysid
";
return(Dapper.Save(rightFunctionGroup, sql, conn, trans));
}
public static bool Insert(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
INSERT INTO T_RIGHT_FUNCTION_GROUP(SYSID,GROUP_NAME,SEQUENCE,GROUP_NAME_CN,GROUP_NAME_US,GROUP_NAME_TW,GROUP_NAME_EN,GROUP_NAME_GE,GROUP_NAME_VI,GROUP_NAME_JP,GROUP_NAME_KO,GROUP_NAME_FR,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,RECORD_STATUS)
VALUES(@Sysid,@GroupName,@Sequence,@GroupNameCn,@GroupNameUs,@GroupNameTw,@GroupNameEn,@GroupNameGe,@GroupNameVi,@GroupNameJp,@GroupNameKo,@GroupNameFr,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy,CONVERT(NVARCHAR(50),GETDATE(),121),@ModifiedBy,@RecordStatus)
";
return(Dapper.Save(rightFunctionGroup, sql, conn, trans));
}
public static List <RightFunctionGroup> QueryMutileRightFunctionGroup(RightFunctionGroup rightFunctionGroup)
{
const string sql = @"
SELECT SYSID AS Sysid,GROUP_NAME AS GroupName,SEQUENCE AS Sequence,CREATED_ON AS CreatedOn,CREATED_BY AS CreatedBy,MODIFIED_ON AS ModifiedOn,MODIFIED_BY AS ModifiedBy,RECORD_STATUS AS RecordStatus
FROM T_RIGHT_FUNCTION_GROUP WITH(NOLOCK)
WHERE 1 = 1
AND GROUP_NAME = @GroupName " ;
return(Dapper.Query <RightFunctionGroup>(sql, rightFunctionGroup));
}
public static bool Update(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
UPDATE T_RIGHT_FUNCTION_GROUP
SET GROUP_NAME=@GroupName,SEQUENCE=@Sequence,GROUP_NAME_CN=@GroupNameCn,GROUP_NAME_US=@GroupNameUs,GROUP_NAME_TW=@GroupNameTw,GROUP_NAME_EN=@GroupNameEn,GROUP_NAME_GE=@GroupNameGe,GROUP_NAME_VI=@GroupNameVi,GROUP_NAME_JP=@GroupNameJp,GROUP_NAME_KO=@GroupNameKo,GROUP_NAME_FR=@GroupNameFr,CREATED_BY=@CreatedBy,MODIFIED_ON=CONVERT(NVARCHAR(50),GETDATE(),121),MODIFIED_BY=@ModifiedBy,RECORD_STATUS=@RecordStatus
WHERE SYSID=@Sysid
";
return(Dapper.Save(rightFunctionGroup, sql, conn, trans));
}
//新增数据
/// <summary>
/// 新增数据
/// </summary>
/// <returns></returns>
internal override bool Add()
{
EditEntity = null;
pageViewMain.SelectedPage = pageEditData;
UI.ClearUi(pageEditData);
UI.ReadOnlyUi(pageEditData, false);
var rightFunctionGroups = RightFunctionGroupBll.QueryAll();
if (rightFunctionGroups != null && rightFunctionGroups.Count > 0)
UI.SetValue(txtSequence, rightFunctionGroups.Count.ToString());
return true;
}
public static bool InsertRightFunctionGroup(RightFunctionGroup rightFunctionGroup, out string msg)
{
var rightFunctionGroups = RightFunctionGroupDal.QueryMutileRightFunctionGroup(rightFunctionGroup);
if (rightFunctionGroups != null && rightFunctionGroups.Count > 0)
{
msg = string.Format("名称{0}的记录已经存在", rightFunctionGroup.GroupName);
return false;
}
if (!RightFunctionGroupDal.Insert(rightFunctionGroup))
{
msg = "新增失败";
return false;
}
msg = "新增成功";
return true;
}
public static bool InsertRightFunctionGroup(RightFunctionGroup rightFunctionGroup, out string msg)
{
var rightFunctionGroups = RightFunctionGroupDal.QueryMutileRightFunctionGroup(rightFunctionGroup);
if (rightFunctionGroups != null && rightFunctionGroups.Count > 0)
{
msg = string.Format("名称{0}的记录已经存在", rightFunctionGroup.GroupName);
return(false);
}
if (!RightFunctionGroupDal.Insert(rightFunctionGroup))
{
msg = "新增失败";
return(false);
}
msg = "新增成功";
return(true);
}
public static bool UpdateRightFunctionGroup(RightFunctionGroup rightFunctionGroup, out string msg)
{
var rightFunctionGroups = RightFunctionGroupDal.QueryMutileRightFunctionGroup(rightFunctionGroup);
if (rightFunctionGroups != null && rightFunctionGroups.Count > 0)
{
if (rightFunctionGroups.FindAll(p => p.Sysid != rightFunctionGroup.Sysid).Count > 0)
{
msg = string.Format("名称{0}的记录已经存在", rightFunctionGroup.GroupName);
return false;
}
}
if (!RightFunctionGroupDal.Update(rightFunctionGroup))
{
msg = "修改失败";
return false;
}
msg = "修改成功";
return true;
}
public static bool UpdateRightFunctionGroup(RightFunctionGroup rightFunctionGroup, out string msg)
{
var rightFunctionGroups = RightFunctionGroupDal.QueryMutileRightFunctionGroup(rightFunctionGroup);
if (rightFunctionGroups != null && rightFunctionGroups.Count > 0)
{
if (rightFunctionGroups.FindAll(p => p.Sysid != rightFunctionGroup.Sysid).Count > 0)
{
msg = string.Format("名称{0}的记录已经存在", rightFunctionGroup.GroupName);
return(false);
}
}
if (!RightFunctionGroupDal.Update(rightFunctionGroup))
{
msg = "修改失败";
return(false);
}
msg = "修改成功";
return(true);
}
public static bool Delete(RightFunctionGroup rightFunctionGroup)
{
using (var conn = new SqlConnection(Conn.getConn()))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (var trans = conn.BeginTransaction())
{
//1、删除功能组
var result = Delete(rightFunctionGroup, conn, trans);
if (!result)
{
trans.Rollback();
return(false);
}
//2、删除当前组对应的功能分组信息
RightLkFunctionGroupDal.DeleteByGroupSysid(new RightLkFunctionGroup {
GroupSysid = rightFunctionGroup.Sysid
}, conn, trans);
//3、删除当前组对应的权限分配信息
RightDal.DeleteByFunctionGroupSysid(new Right {
FunctionGroupSysid = rightFunctionGroup.Sysid
}, conn, trans);
trans.Commit();
}
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
return(true);
}
public static List<RightFunctionGroup> QueryMutileRightFunctionGroup(RightFunctionGroup rightFunctionGroup)
{
const string sql = @"
SELECT SYSID AS Sysid,GROUP_NAME AS GroupName,SEQUENCE AS Sequence,CREATED_ON AS CreatedOn,CREATED_BY AS CreatedBy,MODIFIED_ON AS ModifiedOn,MODIFIED_BY AS ModifiedBy,RECORD_STATUS AS RecordStatus
FROM T_RIGHT_FUNCTION_GROUP WITH(NOLOCK)
WHERE 1 = 1
AND GROUP_NAME = @GroupName ";
return Dapper.Query<RightFunctionGroup>(sql, rightFunctionGroup);
}
public static bool DeleteRightFunctionGroup(RightFunctionGroup rightFunctionGroup)
{
return RightFunctionGroupDal.Delete(rightFunctionGroup);
}
public static bool Update(RightFunctionGroup rightFunctionGroup, SqlConnection conn, SqlTransaction trans)
{
const string sql = @"
UPDATE T_RIGHT_FUNCTION_GROUP
SET GROUP_NAME=@GroupName,SEQUENCE=@Sequence,GROUP_NAME_CN=@GroupNameCn,GROUP_NAME_US=@GroupNameUs,GROUP_NAME_TW=@GroupNameTw,GROUP_NAME_EN=@GroupNameEn,GROUP_NAME_GE=@GroupNameGe,GROUP_NAME_VI=@GroupNameVi,GROUP_NAME_JP=@GroupNameJp,GROUP_NAME_KO=@GroupNameKo,GROUP_NAME_FR=@GroupNameFr,CREATED_BY=@CreatedBy,MODIFIED_ON=CONVERT(NVARCHAR(50),GETDATE(),121),MODIFIED_BY=@ModifiedBy,RECORD_STATUS=@RecordStatus
WHERE SYSID=@Sysid
";
return Dapper.Save(rightFunctionGroup, sql, conn, trans);
}
//设置选中的实体
/// <summary>
/// 设置选中的实体
/// </summary>
private void SetSelectedEntity()
{
if (grdQueryResult.SelectedRows == null ||
grdQueryResult.SelectedRows.Count <= 0)
return;
EditEntity = grdQueryResult.SelectedRows[0].DataBoundItem as RightFunctionGroup;
InitEditForm();
}
//用编辑框数据填充实体
/// <summary>
/// 用编辑框数据填充实体
/// </summary>
private void BuildEntity()
{
if (CurrentOperationStatus == OperationStatus.New)
EditEntity = new RightFunctionGroup
{
Sysid = Sysid.NewId(""),
CreatedBy = GloableData.Instance.UserId
};
EditEntity.ModifiedBy = GloableData.Instance.UserId;
EditEntity.GroupName = UI.GetValue(txtFuncGroupName);
EditEntity.Sequence = UI.GetInt(txtSequence);
EditEntity.RecordStatus = UI.GetValue(chkIsEnable);
}
//删除数据
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
internal override bool Delete()
{
if (EditEntity == null)
{
UI.ShowWarn("请选择待删除数据");
return false;
}
if (!UI.Confirm("确定要删除吗？"))
return false;
if (!RightFunctionGroupBll.DeleteRightFunctionGroup(EditEntity))
{
UI.ShowError("删除失败");
return false;
}
EditEntity = null;
UI.ClearUi(pageEditData);
return true;
}
public static bool DeleteRightFunctionGroup(RightFunctionGroup rightFunctionGroup)
{
return(RightFunctionGroupDal.Delete(rightFunctionGroup));
}