Пример #1
0
        public DataSet GetDBDefault_Load()
        {
            common_DataBase = new Common_DataBase();
            common_DataBase.Query = "SELECT * FROM view_SingleGraphInfo Where Measured = 1 AND Incidence = 1 AND FreqBand = 1 AND GraphType = 1";

            //common_DataBase.Query = "SELECT * from Project";

            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }
Пример #2
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="Flag">0 �̸� ���� �ƴϸ� �Ϻ�</param>
        /// <returns></returns>
        public DataSet GetMaterialType(int Flag)
        {
            common_DataBase = new Common_DataBase();
            if(Flag == 0)
            {
                common_DataBase.Query = "SELECT * FROM MaterialType ORDER BY MID ASC";
            }
            else
            {
                common_DataBase.Query = "SELECT * FROM MaterialType Where Flag = 1 ORDER BY MID ASC";
            }

            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }
Пример #3
0
        public DataSet GetSingleMaterialGraph(string strID)
        {
            common_DataBase = new Common_DataBase();
            common_DataBase.Query = String.Format("SELECT * FROM SingleMeterialGraph Where SGID = {0}",strID);

            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }
Пример #4
0
        public DataSet GetSingleMaterial(string dID)
        {
            common_DataBase = new Common_DataBase();
            common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial Where SID = {0}",dID);

            return common_DataBase.GetDataSet_Text();
        }
Пример #5
0
        public int IsGraphExist(bool bIsSingle,int dIsMeasured,int dIncidence,int dFreqBand,int dGraphType,int dID)
        {
            common_DataBase = new Common_DataBase();

            if(bIsSingle == true)
            {
                common_DataBase.Query = String.Format("SELECT SGID FROM view_SingleGraphInfo Where Measured = {0} AND Incidence = {1} AND FreqBand = {2} AND GraphType = {3} AND SID = {4}",dIsMeasured,dIncidence,dFreqBand,dGraphType,dID);
            }
            else
            {
                common_DataBase.Query = String.Format("SELECT LGID FROM view_MultiLayerMaterialGraph Where Measured = {0} AND Incidence = {1} AND FreqBand = {2} AND GraphType = {3} AND LID = {4}",dIsMeasured,dIncidence,dFreqBand,dGraphType,dID);
            }

            if(common_DataBase.GetDataSet_Text().Tables[0].Rows.Count > 0)
            {
                return int.Parse(common_DataBase.GetDataSet_Text().Tables[0].Rows[0][0].ToString());
            }
            else
            {
                return -1;
            }
        }
Пример #6
0
        public DataSet GetMultiMaterial(int dID)
        {
            common_DataBase = new Common_DataBase();
            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where LID = {0}",dID);

            return common_DataBase.GetDataSet_Text();
        }
Пример #7
0
        public DataSet Search_Parameter(string Category,string IncidenceCondition,string MaterialType,string Frequency,string strName,
			string strVendor,string strProducing,string strDate,int dMeasured)
        {
            common_DataBase = new Common_DataBase();
            if(MaterialType != "0")
            {
                if(Category == "Single")
                {
                    if(strName != "")
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial WHERE SID IN(SELECT SID FROM view_SingleGraphInfo Where (Vendor LIKE '%{3}%' OR Vendor IS NULL) AND (Producing LIKE '%{4}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND Name LIKE '%{2}%') ORDER BY SID",IncidenceCondition,MaterialType,strName,strVendor,strProducing,strDate);

                    }
                    else
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial WHERE SID IN(SELECT SID FROM view_SingleGraphInfo Where (Vendor LIKE '%{2}%' OR Vendor IS NULL) AND (Producing LIKE '%{3}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1}) ORDER BY SID",IncidenceCondition,MaterialType,strVendor,strProducing,strDate);

                    }
                }
                else
                {
                    if(strName != "")
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND MultiLayer.Name LIKE '%{2}%'",IncidenceCondition,MaterialType,strName);

                    }
                    else
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1}",IncidenceCondition,MaterialType);

                    }
                }
            }
            else
            {
                if(Category == "Single")
                {
                    if(strName != "")
                    {

                        //common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial WHERE SID IN(SELECT SID FROM view_SingleGraphInfo Where ((Vendor LIKE '%{2}%' OR Vendor IS NULL) AND (Producing LIKE '%{3}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND Name = '%{1}%') OR(Occurred_Date LIKE '%{4}%')) ORDER BY SID",IncidenceCondition,strName,strVendor,strProducing,strDate);
                        common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial WHERE SID IN(SELECT SID FROM view_SingleGraphInfo Where (Vendor LIKE '%{1}%' OR Vendor IS NULL) AND (Producing LIKE '%{2}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {3} AND Name LIKE '%{0}%')",strName,strVendor,strProducing,IncidenceCondition);

                    }
                    else
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial WHERE SID IN(SELECT SID FROM view_SingleGraphInfo Where (Vendor LIKE '%{1}%' OR Vendor IS NULL) AND (Producing LIKE '%{2}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0}) ORDER BY SID",IncidenceCondition,strVendor,strProducing,strDate);

                    }
                }
                else
                {
                    if(strName != "")
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND Name LIKE '%{1}%'",IncidenceCondition,strName);

                    }
                    else
                    {

                        common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0}",IncidenceCondition);

                    }
                }
            }

            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }
Пример #8
0
        //        public DataSet Search_MultiMaterial(string strName,string strTotalThick)
        //        {
        //            string strQuery = "SELECT * FROM view_MultiLayerMaterialGraph Where Measured <> 1";
        //
        //            if(strname != "")
        //            {
        //                strQuery = strQuery + String.Format(" AND Name = '{0}' ",strName);
        //            }
        //            if(strTotalThick != "")
        //            {
        //                strQuery = strQuery + String.Format(" AND TotalThick = '{0}' ",strTotalThick);
        //            }
        //                    
        //            common_DataBase.Query = strQuery;
        //
        //            DataSet ds = common_DataBase.GetDataSet_Text();
        //
        //            return ds;
        //        }
        /// <summary>
        /// IDs �� �ĸ��������� �ָ� �� �����´�
        /// </summary>
        /// <param name="Category"></param>
        /// <param name="strIDs"></param>
        /// <returns></returns>
        public DataSet Search_IDs(string Category,string strIDs)
        {
            if(strIDs != "")
            {
                common_DataBase = new Common_DataBase();
                if(Category == "Single")
                {
                    common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where SGID IN({0})",strIDs);
                }
                else
                {
                    common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where LGID IN({0})",strIDs);
                }
                DataSet ds = common_DataBase.GetDataSet_Text();

                return ds;
            }
            else
            {
                return null;
            }
        }
Пример #9
0
        /// <summary>
        /// �ش� �׷��� ID �� �ָ� �װ͸� �����´�
        /// </summary>
        /// <param name="Category"></param>
        /// <param name="strIDs"></param>
        /// <returns></returns>
        public DataSet Search_ID(bool Category,string strID)
        {
            common_DataBase = new Common_DataBase();
            if(Category == true)
            {
                common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where SGID = {0}",strID);
            }
            else
            {
                common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where LGID = {0}",strID);
            }
            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }
Пример #10
0
        /// <summary>
        /// ��ȸ �Լ�
        /// </summary>
        /// <param name="Category"></param>
        /// <param name="IncidenceCondition"></param>
        /// <param name="MaterialType"></param>
        /// <param name="Option"></param>
        /// <param name="Frequency">1,Narrow band 2,Octave 3,1/3 Octav</param>
        public DataSet Search(string Category,string IncidenceCondition,string MaterialType,string Frequency,string strName,
			string strVendor,string strProducing,string strDate,int dMeasured)
        {
            common_DataBase = new Common_DataBase();
            if(MaterialType != "0")
            {
                if(Category == "Single")
                {
                    if(strName != "")
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{3}%' OR Vendor IS NULL) AND (Producing LIKE '%{4}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND Name LIKE '%{2}%' ORDER BY SID",IncidenceCondition,MaterialType,strName,strVendor,strProducing,strDate);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{4}%' OR Vendor IS NULL) AND (Producing LIKE '%{5}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND FreqBand = {2} AND Name LIKE '%{3}%' ORDER BY SID",IncidenceCondition,MaterialType,Frequency,strName,strVendor,strProducing,strDate);
                        }
                    }
                    else
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{2}%' OR Vendor IS NULL) AND (Producing LIKE '%{3}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} ORDER BY SID",IncidenceCondition,MaterialType,strVendor,strProducing,strDate);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{3}%' OR Vendor IS NULL) AND (Producing LIKE '%{4}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND FreqBand = {2} ORDER BY SID",IncidenceCondition,MaterialType,Frequency,strVendor,strProducing,strDate);
                        }
                    }
                }
                else
                {
                    if(strName != "")
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND MultiLayer.Name LIKE '%{2}%'",IncidenceCondition,MaterialType,strName);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND FreqBand = {2} AND MultiLayer.Name LIKE '%{3}%'",IncidenceCondition,MaterialType,Frequency,strName);
                        }
                    }
                    else
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1}",IncidenceCondition,MaterialType);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND MID = {1} AND FreqBand = {2} ",IncidenceCondition,MaterialType,Frequency);
                        }
                    }
                }
            }
            else
            {
                if(Category == "Single")
                {
                    if(strName != "")
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{2}%' OR Vendor IS NULL) AND (Producing LIKE '%{3}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND Name LIKE '%{1}%' ORDER BY SID",IncidenceCondition,strName,strVendor,strProducing,strDate);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{3}%' OR Vendor IS NULL) AND (Producing LIKE '%{4}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND FreqBand = {1} AND Name LIKE '%{2}%' ORDER BY SID",IncidenceCondition,Frequency,strName,strVendor,strProducing,strDate);
                        }
                    }
                    else
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{1}%' OR Vendor IS NULL) AND (Producing LIKE '%{2}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} ORDER BY SID",IncidenceCondition,strVendor,strProducing,strDate);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_SingleGraphInfo Where (Vendor LIKE '%{2}%' OR Vendor IS NULL) AND (Producing LIKE '%{3}%' OR Producing IS NULL) AND Measured = " + dMeasured + " AND Incidence = {0} AND FreqBand = {1} ORDER BY SID",IncidenceCondition,Frequency,strVendor,strProducing,strDate);
                        }
                    }
                }
                else
                {
                    if(strName != "")
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND Name LIKE '%{1}%'",IncidenceCondition,strName);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND FreqBand = {1} AND Name LIKE '%{2}%'",IncidenceCondition,Frequency,strName);
                        }
                    }
                    else
                    {
                        if(Frequency == "0")
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0}",IncidenceCondition);
                        }
                        else
                        {
                            common_DataBase.Query = String.Format("SELECT * FROM view_MultiLayerMaterialGraph Where Measured = " + dMeasured + " AND Incidence = {0} AND FreqBand = {1} ",IncidenceCondition,Frequency);
                        }
                    }
                }
            }

            DataSet ds = common_DataBase.GetDataSet_Text();

            return ds;
        }