예제 #1
0
        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));
        }
예제 #2
0
        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));
        }
예제 #3
0
        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));
        }
예제 #4
0
        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));
        }
예제 #5
0
        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));
        }
예제 #6
0
        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));
        }
예제 #7
0
        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));
        }
예제 #8
0
        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));
        }
예제 #9
0
        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));
        }
예제 #10
0
        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));
        }
예제 #11
0
        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));
        }
예제 #12
0
        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));
        }
예제 #13
0
        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));
        }
예제 #14
0
        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));
        }
예제 #15
0
        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));
        }
예제 #16
0
        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));
        }
예제 #17
0
        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));
        }
예제 #18
0
        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));
        }
예제 #19
0
 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
     { }
 }
예제 #20
0
 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);
     }
 }
예제 #21
0
 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
     { }
 }
예제 #22
0
 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
     { }
 }
예제 #23
0
 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(""); }
 }
예제 #24
0
 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("");
     }
 }
예제 #25
0
 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
     { }
 }
예제 #26
0
 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
     { }
 }
예제 #27
0
 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("");
     }
 }
예제 #28
0
 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
     { }
 }
예제 #29
0
 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("");
     }
 }
예제 #30
0
        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));
        }