public static DataSet Statements(string action, string userID, string schoolyear, string schoolcode, string category, string area, string IDs)
{
string SP = "dbo.EPA_sys_Statement";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[7];
myBaseParametersC.SetupBaseParameters(ref myPara, action, userID, category, area, schoolyear, schoolcode, IDs);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Category(string operate, string userID)
{
string SP = "dbo.EPA_sys_CategoryList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, "", "");
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet SystemItems(string operate, string userID, string category, string itemType)
{
string SP = "dbo.EPA_sys_SystemItemsList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, itemType);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet UsersManagement(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_ApplicationUsers";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet UsersManagementMultipleSchool(string operate, string userID, string category, string area, string schoolyear)
{
string SP = "dbo.EPA_sys_ApplicationUsersMultipleSchool";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[5];
myBaseParametersC.SetupBaseParameters(ref myPara, operate, userID, category, area, schoolyear);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static string Statements(string action, string userID, string schoolyear, string schoolcode, string category, string area)
{
string SP = "dbo.EPA_sys_Statement";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersC.SetupBaseParameters(ref myPara, action, userID, category, area, schoolyear, schoolcode);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static DataSet SchoolDistrict(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_ORG_DistrictList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet Competency(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_sys_DomainCompetencyList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static DataSet RegionAreaList(string operate, string userID, string category, string area)
{
string SP = "dbo.EPA_ORG_RegionAreaList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[4];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
return(SetSQLParameter.getMyDataSet(SP, myPara));
}
public static void SetupBaseParameters(ref MyADO.MyParameterDB[] myPara, string userID, string _aID, string _cID, string _pID, string _iID)
{
SetSQLParameter.setParameterArray(myPara, DbType.String, 0, 30, "@UserID", userID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 1, 30, "@ApplID", _aID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 30, "@CategoryID", _cID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 3, 30, "@PageID", _pID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 30, "@ItemID", _iID);
}
public static string Category(string operate, string userID, string IDs, string code, string name, string comments, string active)
{
string SP = "dbo.EPA_sys_CategoryList";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, "", "", IDs, code, name, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
public static DataSet SchoolInformation(string operate, string userID, string category, string area, string IDs)
{
string SP = "dbo.EPA_ORG_SchoolsList";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, roleCode, roleName, 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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.MyParameterDB[9];
SetupThisParameters(ref myPara, operate, userID, category, area, IDs, districtCode, districtName, comments, active);
return(SetSQLParameter.getMyDataValue(SP, myPara));
}
private static void SetupThisParameters(ref myCommon.MyParameterDB[] myPara, string action, string userID, string category, string area, string IDs, string code, string name, string comments, string active)
{
myBaseParametersB.SetupBaseParameters(ref myPara, action, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@Code", code);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 100, "@Name", name);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 250, "@Comments", comments);
SetSQLParameter.setParameterArray(myPara, DbType.String, 8, 1, "@Active", active);
}
public static string SchoolInformation(string operate, string userID, string category, string area, string IDs, string code)
{
string SP = "dbo.EPA_ORG_SchoolsList";
MyADO.MyParameterDB[] myPara = new MyADO.MyParameterDB[6];
myBaseParametersB.SetupBaseParameters(ref myPara, operate, userID, category, area);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 10, "@IDs", IDs);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@Code", code);
return(SetSQLParameter.getMyDataValue(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";
myCommon.MyParameterDB[] myPara = new myCommon.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 DataSet CommentsBank(string operate, string userID, string category, string area, string type, string owner)
{
string SP = "dbo.EPA_sys_CommentsBankList";
myCommon.MyParameterDB[] myPara = new myCommon.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));
}
private static void SetupThisParameters(ref MyADO.MyParameterDB[] myPara, string operate, string userID, string category, string noticType, string noticArea, string noticeGo, string noticeFrom, string purpose)
{
myBaseParameters.SetupBaseParameters(ref myPara, operate, userID);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 2, 10, "@Category", category);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 3, 30, "@NoticeType", noticType);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 4, 10, "@NoticeArea", noticArea);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 5, 15, "@NoticeGo", noticeGo);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 6, 15, "@NoticeFrom", noticeFrom);
SetSQLParameter.setParameterArray(myPara, System.Data.DbType.String, 7, 10, "@Purpose", purpose);
}
private static void SetupThisParameters(ref MyADO.MyParameterDB[] myPara, string _UserID, string _aID, string _mID, string _Type, string _cID, string _gID, string _iID, string _tID)
{
SetSQLParameter.setParameterArray(myPara, DbType.String, 0, 50, "@UserID", _UserID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 1, 20, "@AppCode", _aID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 2, 20, "@Model", _mID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 3, 20, "@Type", _Type);
SetSQLParameter.setParameterArray(myPara, DbType.String, 4, 20, "@CategoryID", _cID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 5, 20, "@GroupID", _gID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 6, 20, "@ItemID", _iID);
SetSQLParameter.setParameterArray(myPara, DbType.String, 7, 30, "@TitleID", _tID);
}
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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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";
myCommon.MyParameterDB[] myPara = new myCommon.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 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 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)
{
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("");
}
}