public static void DeleteSubGroup(string scode)
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
sp.Add("@S_CODE", typeof(System.String), scode);
sp.ExecuteNonQuery("spDeleteFASubGroup");
}
public static DataTable ListGroup()
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
DataSet ds = sp.Execute("spListFAGroup");
return(ds.Tables[0]);
}
internal Account(SPAccess SPAccess, global::SPAccess.UserIdentity userIdentity)
: base(SPAccess)
{
this.userIdentity = userIdentity;
group = new Group(this.SPAccess, userIdentity.GroupIdentity.First());
}
private SPContext(SPAccess SPAccess)
{
_Current = this;
this.SPAccess = SPAccess;
this.CookieManager = new CookieManager(this);
LoadAllPermission();
}
public static DataTable GetGroup(string acode)
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
sp.Add("@A_CODE", typeof(System.String), acode);
DataSet ds = sp.Execute("spGetFAGroup");
return(ds.Tables[0]);
}
public static DataTable GetJournal(String JId)
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
sp.Add("@J_ID", typeof(System.String), JId);
DataSet ds = sp.Execute("spGetJMaster");
return(ds.Tables[0]);
}
public static void UpdateGroup(string acode, string adesc, string type, decimal curbal)
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
sp.Add("@A_CODE", typeof(System.String), acode);
sp.Add("@A_DESC", typeof(System.String), adesc);
sp.Add("@A_TYPE", typeof(System.String), type);
sp.Add("@A_CURRB", typeof(System.Decimal), curbal);
sp.ExecuteNonQuery("spUpdateFAGroup");
}
public static void UpdateSubGroup(string scode, string sdesc, string stype, decimal opbal, string drcr, string flag)
{
SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
sp.Add("@S_CODE", typeof(System.String), scode);
sp.Add("@S_DESC", typeof(System.String), sdesc);
sp.Add("@S_TYPE", typeof(System.String), stype);
sp.Add("@S_OPBAL", typeof(System.String), opbal);
sp.Add("@S_DRCR", typeof(System.String), drcr);
sp.Add("@S_FLAG", typeof(System.String), flag);
sp.ExecuteNonQuery("spUpdateFASubGroup");
}
public bool Login(string Username, string Password)
{
try
{
var session = SPAccess.LoginByUser(Username, Password);
CookieManager.Token = session.Token;
}
catch (Exception ex)
{
#if DEBUG
throw ex;
#endif
}
return(false);
}
/// <summary>
/// Hàm xử lý đăng xuất phiên làm việc hiện tại
/// </summary>
/// <returns></returns>
public bool Logout()
{
try
{
if (SPAccess.Logout(Session))
{
SessionCache.Remove(CookieManager.Token);
CookieManager.Token = "Việt Nam Vô Địch!";
return(true);
}
}
catch (Exception ex)
{
#if DEBUG
throw ex;
#endif
}
return(false);
}
internal Group(SPAccess SPAccess, global::SPAccess.GroupIdentity groupIdentity)
: base(SPAccess)
{
this.groupIdentity = groupIdentity;
}
internal Session(SPAccess SPAccess, global::SPAccess.Session session)
: base(SPAccess)
{
this.session = session;
this.account = new Account(this.SPAccess, session.UserIdentity);
}
internal SPModel(SPAccess SPAccess)
{
this.SPAccess = SPAccess;
}
internal Permission(SPAccess SPAccess, PermissionIdentity perm)
: base(SPAccess)
{
permissionIdentity = perm;
}
