コード例 #1
0
        public static string GetNextPCINumber(int deptID, int projID)
        {
            CDbPCIInfo   dbDt    = new CDbPCIInfo();
            CBDepartment dept    = new CBDepartment();
            string       nextNum = "";
            int          pciCnt;

            dept.Load(deptID);
            pciCnt = dbDt.GetCountByProjectID(projID) + 1;
            //nextNum = dept.Name.Substring(0,1).ToUpper() + pciCnt.ToString("00");
            nextNum = pciCnt.ToString("00");        // only use number per Mike 061608

            return(nextNum);
        }
コード例 #2
0
        public void Load(int iID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();
            string     tmpDat;

            tmpDat = dbDt.GetByID(iID);

            Clear();
            if (tmpDat.Length > 0)
            {
                LoadVals(tmpDat);
            }

            dbDt = null;
        }
コード例 #3
0
        public int Save()
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();
            string     tmpDat;
            int        retVal;

            tmpDat = GetDataString();
            if (base.ID > 0)
            {
                dbDt.SavePrev(tmpDat);
                retVal = base.ID;
            }
            else
            {
                retVal  = dbDt.SaveNew(tmpDat);
                base.ID = retVal;
            }

            dbDt = null;

            return(retVal);
        }
コード例 #4
0
        public static void Delete(int iID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            dbDt.Delete(iID);
        }
コード例 #5
0
        public static void SetPCIComments(int pciID, string comments)
        {
            CDbPCIInfo db = new CDbPCIInfo();

            db.SetPCIComments(pciID, comments);
        }
コード例 #6
0
        public static void GetPCILogTotalByProjID(int projID, ref int hours, ref decimal estTIC)
        {
            CDbPCIInfo db = new CDbPCIInfo();

            db.GetPCILogTotalByProjID(projID, ref hours, ref estTIC);
        }
コード例 #7
0
        public static DataSet GetPCILogByProjID(int projID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            return(dbDt.GetPCILogByProjID(projID));
        }
コード例 #8
0
        public static void CreatePCNFromPCI(int projID, int pciID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            dbDt.CreatePCNFromPCI(projID, pciID);
        }
コード例 #9
0
        public static void SetLockOnPCI(int pciID, bool lockState)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            dbDt.SetLockOnPCI(pciID, lockState);
        }
コード例 #10
0
        public static SqlDataReader GetListByProjDept(int projID, int deptID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            return(dbDt.GetListByProjDept(projID, deptID));
        }
コード例 #11
0
        public static SqlDataReader GetListByProjAllDepts(int projID)
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            return(dbDt.GetListByProjAllDepts(projID));
        }
コード例 #12
0
        public static SqlDataReader GetList()
        {
            CDbPCIInfo dbDt = new CDbPCIInfo();

            return(dbDt.GetList());
        }