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