public static DataSet Category(string operate, string userID)
{
string SP = "dbo.EPA_sys_CategoryList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, "", "");
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet UserRoleManagement(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_ApplicationRole";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Domain(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_DomainList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SystemItems(string operate, string userID, string category, string itemType)
{
string SP = "dbo.EPA_sys_SystemItemsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, itemType);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SchoolInformation(string operate, string userID, string category, string area, string IDs)
{
string SP = "dbo.EPA_ORG_SchoolsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static string SchoolDistrict(string operate, string userID, string category, string area, string IDs, string districtCode, string districtName, string comments, string active)
{
string SP = "dbo.EPA_ORG_DistrictList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, districtCode, districtName, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Category(string operate, string userID, string IDs, string code, string name, string comments, string active)
{
string SP = "dbo.EPA_sys_CategoryList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, "", "", IDs, code, name, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static DataSet LookFors(string operate, string userID, string category, string area, string competencyID)
{
string SP = "dbo.EPA_sys_DomainCompetencyLookForsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@competencyID", competencyID);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static string Domain(string operate, string userID, string category, string area, string IDs, string domainCode, string domainName, string comments, string active)
{
string SP = "dbo.EPA_sys_DomainList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, domainCode, domainName, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string UserRoleManagement(string operate, string userID, string category, string area, string IDs, string roleCode, string roleName, string comments, string active)
{
string SP = "dbo.EPA_sys_ApplicationRole";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, roleCode, roleName, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static DataSet CommentsBank(string operate, string userID, string category, string area, string type, string owner)
{
string SP = "dbo.EPA_sys_CommentsBankList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 30, "@Type", type);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 30, "@Owner", owner);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static string UsersManagement(string operate, string userID, string category, string area, string IDs, string userCode, string userName, string userRole, string comments, string active)
{
string SP = "dbo.EPA_sys_ApplicationUsers";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[10];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, userCode, userName, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 100, "@UserRole", userRole);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string SystemItems(string operate, string userID, string category, string itemType, string IDs, string code, string name, string comments, string active, string steps, string keyPoint)
{
string SP = "dbo.EPA_sys_SystemItemsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[11];
SetupThisParameters(ref myPara, operate, userID, category, itemType, IDs, code, name, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 50, "@Orders", steps);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 50, "@KeyPoint", keyPoint);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Statements(string action, string userID, string schoolyear, string schoolcode, string category, string area, string IDs, string statement, string topic, string startDate, string endDate)
{
string SP = "dbo.EPA_sys_Statement";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[11];
myBaseParametersC.SetupBaseParameters(ref myPara, action, userID, category, area, schoolyear, schoolcode, IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 2500, "@Statement", statement);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Subject", topic);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 10, "@StartDate", startDate);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 10, "@EndDate", endDate);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string UsersManagementMultipleSchool(string operate, string userID, string category, string area, string schoolyear, string IDs, string principalID, string schoolcode, string comments, string active)
{
string SP = "dbo.EPA_sys_ApplicationUsersMultipleSchool";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[10];
myBaseParametersC.SetupBaseParameters(ref myPara, operate, userID, category, area, schoolyear, schoolcode, IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 30, "@PrincipalID", principalID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string Competency(string operate, string userID, string category, string area, string IDs, string code, string name, string comments, string active, string TPA, string NTP, string LTO)
{
string SP = "dbo.EPA_sys_DomainCompetencyList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[12];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, code, name, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@TPA", TPA);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 1, "@NTP", NTP);
SetSQLParameter.setParameterArray(myPara, DbType.String, 11, 1, "@LTO", LTO);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string RegionAreaList(string operate, string userID, string category, string area, string IDs, string regionCode, string regionName, string comments, string active, string district, string superID, string officer)
{
string SP = "dbo.EPA_ORG_RegionAreaList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[12];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, regionCode, regionName, comments, active);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 30, "@District", district);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 30, "@SuperID", superID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 11, 30, "@Officer", officer);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static string LookFors(string operate, string userID, string category, string area, string competencyID, string IDs, string code, string name, string comments, string active)
{
string SP = "dbo.EPA_sys_DomainCompetencyLookForsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[10];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@competencyID", competencyID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 20, "@Code", code);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 100, "@Name", name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
private static void LastValue(string operate, string value)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[3];
myBaseParameters.SetupBaseParameters(ref myPara, operate, HttpContext.Current.User.Identity.Name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 50, "@Value", value);
SetSQLParameter.getMyDataValue(SP, myPara);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
private static DataSet myListReader2(string operate, string userID, string vPara1)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[3];
myBaseParametersL.SetupBaseParameters(ref myPara, operate, userID, vPara1);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
private static string LastValue(string operate)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[2];
myBaseParameters.SetupBaseParameters(ref myPara, operate, HttpContext.Current.User.Identity.Name);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
finally
{ }
}
public static string Tips(string _aID, string _cID, string _pID, string _iID)
{
try
{
string _SP = "dbo.EPA_sys_TitleTips";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersA.SetupBaseParameters(ref myPara, "UPA", _aID, _cID, _pID, _iID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ return("" + ex.Message); }
finally
{ }
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string title, string subTitle)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[7];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 200, "@Title", HttpContext.Current.Server.HtmlDecode(title));
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 500, "@SubTitle", HttpContext.Current.Server.HtmlDecode(subTitle));
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string Tips(string _UserID, string _aID, string _cID, string _pID, string _iID, string _value)
{
try
{
string _SP = "dbo.EPA_sys_TitleTips";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 200, "@Value", _value);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ return("Fail - " + ex.Message); }
finally
{ }
}
public static void Items(string _UserID, string _aID, string _mID, string _Type, string _cID, string _gID, string _iID, string _tID, string _value)
{
try
{
string _SP = "dbo.EPA_sys_Menus";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[9];
SetupThisParameters(ref myPara, _UserID, _aID, _mID, _Type, _cID, _gID, _iID, _tID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 500, "@Value", HttpContext.Current.Server.HtmlDecode(_value));
SetSQLParameter.getMyDataValue(_SP, myPara);
}
catch (Exception ex)
{ var em = ex.Message; }
finally
{ }
}
public static string Content(string operate, string userID, string categoryID, string areaID, string itemCode, string helpType)
{
try
{
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, categoryID, areaID, itemCode);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 10, "@HelpType", helpType);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string NameLong(string _UserID, string _aID, string _cID, string _pID, string _iID)
{
try
{
string _SP = "dbo.EPA_sys_Title2";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[5];
myBaseParametersA.SetupBaseParameters(ref myPara, _UserID, _aID, _cID, _pID, _iID);
return(SetSQLParameter.getMyDataValue(_SP, myPara));
}
catch (Exception ex)
{ var em = ex.Message;
return(""); }
finally
{ }
}
public static string NotificationeTemplatePersonal(string operate, string userID, string category, string noticType, string noticeArea, string noticeGo, string noticeFrom, string purpose)
{
try
{
string sp = "dbo.EPA_Appr_AppraisalProcess_NotificationTemplatePersonal";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[8];
SetupThisParameters(ref myPara, operate, userID, category, noticType, noticeArea, noticeGo, noticeFrom, purpose);
return(SetSQLParameter.getMyDataValue(sp, myPara));
}
catch (Exception ex)
{
var em = ex.Message;
return("");
}
}
public static string CommentsBank(string operate, string userID, string category, string area, string type, string owner, string IDs, string domainID, string shared, string comments, string active)
{
string SP = "dbo.EPA_sys_CommentsBankList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[11];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 30, "@Type", type);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 30, "@Owner", owner);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 10, "@DomainID", domainID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 50, "@Shared", shared);
SetSQLParameter.setParameterArray(myPara, DbType.String, 9, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 10, 1, "@Active", active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}