コード例 #1
0
ファイル: config.cs プロジェクト: rehanishrat74/MedHealth
 public static void checkConfigSession()
 {
     if (HttpContext.Current.Session["IsProduction"] == null)
     {
         clsDB DB = new clsDB();
         SetConfigSession(DB.getDS("SELECT * FROM [config].[appSettings]").Tables[0], null, DB);
     }
 }
コード例 #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('^'));
        }