public static string LastValue(string userId, string operate, string value, string machin_name, string screen_size, string browser_type, string browser_version)
{
try
{
var parameter = new
{
Operate = operate,
UserID = HttpContext.Current.User.Identity.Name,
Value = value,
MachinName = machin_name,
ScreenSize = screen_size,
BrowserType = browser_type,
BrowserVersion = browser_version
};
return(CommonExecute <string> .ValueOfT(SP + " @Operate, @UserID,@Value,@MachinName,@ScreenSize,@BrowserType,@BrowserVersion", parameter));
}
catch (Exception ex)
{
string myEx = ex.Message;
return(null);
}
finally
{ }
}
private static string GetProfile(string pType)
{
try
{
var parameter = new
{
Operate = pType,
UserID = LoginUserId, // HttpContext.Current.User.Identity.Name
};
return(CommonExecute <string> .ValueOfT("dbo.SIC_sys_LoginUserProfile @Operate, @UserID", parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
private static void LastValue(string operate, string value)
{
try
{
var parameter = new
{
Operate = operate,
UserID = HttpContext.Current.User.Identity.Name,
Value = value
};
string result = CommonExecute <string> .ValueOfT(SP + " @Operate, @UserID, @Value", parameter);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
private static string LastValue(string operate)
{
try
{
var parameter = new
{
Operate = operate,
UserID = HttpContext.Current.User.Identity.Name
};
return(CommonExecute <string> .ValueOfT(SP + " @Operate, @UserID", parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
finally
{ }
}
public T ValueOfT(string sp, object parameter)
{
return CommonExecute<T>.ValueOfT( sp, parameter);
}
public List<T> ListOfT(string db, string sp, object parameter)
{
return CommonExecute<T>.ListOfT(db, sp, parameter);
}
public string EditResult(string db, string sp, object parameter, string DapperCommandType)
{
return(CommonExecute <string> .ValueOfT(db, sp, parameter, DapperCommandType));
}
public string EditResult(string db, string sp, object parameter)
{
// return GeneralValue.CommonValue<string>(db,sp, parameter);
return(CommonExecute <string> .ValueOfT(db, sp, parameter));
}
public string EditResult(string sp, object parameter)
{
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
public T ValueOfT(string db, string sp, object parameter, string DapperCommandType)
{
return(CommonExecute <T> .ValueOfT(db, sp, parameter, DapperCommandType));
}
public T ValueOfT(string db, string sp, object parameter)
{
// return GeneralValue.CommonValue<T>(db, sp, parameter);
return(CommonExecute <T> .ValueOfT(db, sp, parameter));
}
public List <T> ListOfT(string db, string sp, object parameter)
{
// return GeneralList.CommonList<T>(db, sp, parameter);
return(CommonExecute <T> .ListOfT(db, sp, parameter));
}
public List <T> ListOfT(string sp, object parameter, string DapperCommandType)
{
return(CommonExecute <T> .ListOfT(sp, parameter, DapperCommandType));
}
public static string UserAccessScope(string userId)
{
return(CommonExecute <string> .ValueOfT("dbo.SIC_sys_LoginUserProfile @Operate, @UserID", new { Operate = "Scope", UserID = userId }));
}
