示例#1
0
        public void clear()
        {
            try {
                clsDB DB = new clsDB();
                DB.executeSQL("UPDATE tblUserSession SET SessionEnd = GETDATE() WHERE SessionEnd IS NULL AND User_PK=" + User_PK);
            }
            catch { }
            HttpContext.Current.Session.Clear();
            var sessionCookie = new HttpCookie("Advance_SessionID", lib.CompressString(HttpContext.Current.Session.SessionID));

            sessionCookie.Domain   = config.PortalURL();
            sessionCookie.HttpOnly = true;
            HttpContext.Current.Response.SetCookie(sessionCookie);
        }
示例#2
0
        public static string[] getExportHeader(clsDB DB, string channel, string project, string projectGroup, string states, string status1, string status2, bool isIncludeStatus)
        {
            string    sReturn = "";
            DataSet   ds      = DB.getDS("rdb_getHeader '" + channel + "','" + project + "','" + projectGroup + "','" + states + "','" + status1 + "','" + status2 + "'", true);
            DataTable dt;

            dt = ds.Tables[2];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    sReturn += "Chase List~";
                }
                else
                {
                    sReturn += ", ";
                }
                sReturn += lib.cStr(dt.Rows[i][0]);
            }

            dt = ds.Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    sReturn += "^Project~";
                }
                else
                {
                    sReturn += ", ";
                }
                sReturn += lib.cStr(dt.Rows[i][0]);
            }

            dt = ds.Tables[1];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    sReturn += "^LOB~";
                }
                else
                {
                    sReturn += ", ";
                }
                sReturn += lib.cStr(dt.Rows[i][0]);
            }

            dt = ds.Tables[3];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    sReturn += "^States~";
                }
                else
                {
                    sReturn += ", ";
                }
                sReturn += lib.cStr(dt.Rows[i][0]);
            }

            if (isIncludeStatus)
            {
                dt = ds.Tables[4];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Retrieval Chase Status~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }

                dt = ds.Tables[5];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Retrieval Chase Detail~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }
                ///////////////////////
                dt = ds.Tables[6];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Invoice Chase Status~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }

                dt = ds.Tables[7];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Invoice Chase Detail~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }
                ///////////////////////
                dt = ds.Tables[8];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Coding Chase Status~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }

                dt = ds.Tables[9];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^Coding Chase Detail~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }
                ///////////////////////
                dt = ds.Tables[10];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^QA Coding Chase Status~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }

                dt = ds.Tables[11];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        sReturn += "^QA Coding Chase Detail~";
                    }
                    else
                    {
                        sReturn += ", ";
                    }
                    sReturn += lib.cStr(dt.Rows[i][0]);
                }
            }
            return(sReturn.Split('^'));
        }