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
{ }
}
public static string NotificationeTemplatePersonal(string operate, string userID, string category, string noticeType, string noticeArea, string noticeGo, string noticeFrom, string purpose, string templateType, string subject, string template, string autoNotice)
{
try
{
var parameter = new
{
Operate = operate,
UserID = HttpContext.Current.User.Identity.Name,
Category = category,
NoticeType = noticeType,
NoticeArea = noticeArea,
NoticeGo = noticeGo,
NoticeFrom = noticeFrom,
Purpose = purpose,
TemplateType = templateType,
Subject = subject,
Template = template,
AutoNotice = autoNotice
};
string sp = GetSP("NotificationeTemplatePersonalSaveAuto");
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string DbTable(string action, string className)
{
var parameter = new
{
Action = action,
ClassName = className
};
string sp = "dbo.EPA_sys_StoreProcedureName";
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
public static string GetValue(string sp, object parameter)
{
try
{
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string NotificationeMailSave(object parameter)
{
try
{
string sp = GetSP("NotificationeMailSave");
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string NotificationeMailUser(string objType, EmailNoticePara parameter)
{
try
{
parameter.NoticeType = objType;
string sp = GetSP("NotificationeUserEmail");
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
private static string GetProfile(string pType)
{
try
{
var parameter = new
{
Operate = pType,
UserID = HttpContext.Current.User.Identity.Name
};
return(CommonExecute <string> .ValueOfT("dbo.EPA_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
{ }
}
public static string NotificationeMail(string operate, string userID, string schoolyear, string schoolcode, string employeeId, string sessionID, string noticeType, string noticeArea)
{
var parameter = new EmailNoticePara()
{
Operate = operate,
UserID = userID,
SchoolYear = schoolyear,
SchoolCode = schoolcode,
EmployeeID = employeeId,
SessionID = sessionID,
NoticeType = noticeType,
NoticeArea = noticeArea
};
string sp = GetSP("NotificationeMail");
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
public static string FeedBackeMail(string operate, string userID, string noticType)
{
try
{
var parameter = new
{
Operate = operate,
UserID = HttpContext.Current.User.Identity.Name,
NoticeType = noticType
};
string sp = GetSP("FeedBackeMail");
return(CommonExecute <string> .ValueOfT(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
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 static string UserLoginRole(string userId)
{
return(CommonExecute <string> .ValueOfT("dbo.EPA_sys_LoginUserProfile @Operate, @UserID", new { Operate = "Role", UserID = userId }));
}