/// <summary>
///
/// </summary>
/// <param name="dal"></param>
/// <param name="userGroupFun"></param>
/// <param name="user"></param>
/// <returns></returns>
public static bool Create(IDal dal, CUserGroupFun userGroupFun, string user)
{
int i;
dal.Execute("INSERT INTO tUserGroupFun( GroupCode ,FunCode ,Queriable ,Creatable ,Changable ,Deletable ,Checkable , BuildUser,EditUser) VALUES ( @GroupCode , @FunCode ,@Queriable ,@Creatable ,@Changable ,@Deletable ,@Checkable,@BuildUser,@EditUser )", out i,
dal.CreateParameter("@GroupCode", userGroupFun.GroupCode.Trim()),
dal.CreateParameter("@FunCode", userGroupFun.FunCode.Trim()),
dal.CreateParameter("@Queriable", userGroupFun.Queriable),
dal.CreateParameter("@Creatable", userGroupFun.Creatable),
dal.CreateParameter("@Changable", userGroupFun.Changable),
dal.CreateParameter("@Deletable", userGroupFun.Deletable),
dal.CreateParameter("@Checkable", userGroupFun.Checkable),
dal.CreateParameter("@BuildUser", user),
dal.CreateParameter("@EditUser", user));
if (i == 0)
{
return(false);
}
var dt = dal.Select("SELECT Id FROM tUserGroupFun WHERE GroupCode=@GroupCode AND FunCode=@FunCode", out i,
dal.CreateParameter("@GroupCode", userGroupFun.GroupCode),
dal.CreateParameter("@FunCode", userGroupFun.FunCode));
if (i == 0)
{
return(false);
}
userGroupFun.Id = Convert.ToInt16(dt.Rows[0]["Id"]);
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="dal"></param>
/// <param name="userGroupFun"></param>
/// <param name="user"></param>
/// <returns></returns>
public static bool Update(IDal dal, CUserGroupFun userGroupFun, string user)
{
int i;
dal.Execute("UPDATE tUserGroupFun SET Changable=@Changable,Checkable=@Checkable,Deletable=@Deletable,Queriable=@Queriable,Creatable=@Creatable WHERE Id=@Id", out i,
dal.CreateParameter("@Changable", userGroupFun.Changable),
dal.CreateParameter("@Checkable", userGroupFun.Checkable),
dal.CreateParameter("@Deletable", userGroupFun.Deletable),
dal.CreateParameter("@Queriable", userGroupFun.Queriable),
dal.CreateParameter("@Creatable", userGroupFun.Creatable),
dal.CreateParameter("@Id", userGroupFun.Id)
);
return(i != 0 || Create(dal, userGroupFun, user));
}
