コード例 #1
0
        /// <summary>
        /// 이 함수는 SP 실행(테이블 반환)  함수입니다.
        /// </summary>
        public static DataTable fnSpExecuteTable(string sspname, params string[] pparams)
        {
            CM_OLE.CreateConnection();
            SqlCommand scData = new SqlCommand(sspname, CM_OLE._conn);

            scData.CommandType    = CommandType.StoredProcedure;
            scData.CommandTimeout = Convert.ToInt32(1000);
            scData.Parameters.Clear();

            int i = 0;
            int k, j;

            while (i < pparams.Length)
            {
                //":"의 갯수로 파라미터의 갯수를 반환
                k = pparams[i].IndexOf(":");
                j = pparams[i].Length;

                if (k + 1 == j)
                {
                    scData.Parameters.AddWithValue(pparams[i].Substring(0, k), null);
                }
                else
                {
                    scData.Parameters.AddWithValue(pparams[i].Substring(0, k), pparams[i].Substring(k + 1, j - k - 1));
                }

                i++;
            }

            SqlDataAdapter adtData = new SqlDataAdapter(scData);
            DataTable      nDataTable = new DataTable();

            try
            {
                CM_OLE._conn.Open();
                adtData.Fill(nDataTable);
                CM_OLE._conn.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message.ToString());

                try
                {
                    nDataTable = new DataTable();
                    CM_OLE._conn.Close();

                    return(nDataTable);
                }
                catch (Exception es)
                {
                    nDataTable = new DataTable();
                    CM_OLE._conn.Close();
                    return(nDataTable);
                }
            }
            return(nDataTable);
        }
コード例 #2
0
        public static DataTable Exec_SCMSelect(string Proc_Name, string Para_Name, string Valu_Data)
        {
            string[] Arry_Para;
            string[] Arry_Valu;

            System.Data.DataTable dtData = new System.Data.DataTable();

            Arry_Para = Para_Name.Split('^');
            Arry_Valu = Valu_Data.Split('^');

            try
            {
                if (Arry_Para.Length == Arry_Valu.Length)
                {
                    CM_OLE.SCMCreateConnection();
                    SqlCommand scData = new SqlCommand(Proc_Name, CM_OLE._SCMconn);
                    scData.CommandType    = CommandType.StoredProcedure;
                    scData.CommandTimeout = Convert.ToInt32(1000);

                    for (int arrCnt = 0; arrCnt < Arry_Para.Length; arrCnt++)
                    {
                        scData.Parameters.Add("@" + Arry_Para[arrCnt].Trim(), Arry_Valu[arrCnt].Trim());
                    }

                    SqlDataAdapter adtData = new SqlDataAdapter(scData);

                    CM_OLE._SCMconn.Open();
                    adtData.Fill(dtData);
                    CM_OLE._SCMconn.Close();
                }
                else
                {
                    DataRow drData = dtData.NewRow();
                    dtData.Rows.Add(drData);
                }
            }
            catch (Exception Ex)
            {
                CM_OLE._SCMconn.Close();

                MessageBox.Show(Ex.Message.ToString());

                DataRow drData = dtData.NewRow();
                dtData.Rows.Add(drData);
            }
            return(dtData);
        }
コード例 #3
0
        public static string Exec_Save(string Proc_Name, string Para_Name, string Valu_Data)
        {
            string Rtn_Message = string.Empty;

            string[] Arry_Para;
            string[] Arry_Valu;

            Arry_Para = Para_Name.Split('^');
            Arry_Valu = Valu_Data.Split('^');

            try
            {
                if (Arry_Para.Length == Arry_Valu.Length)
                {
                    CM_OLE.CreateConnection();
                    SqlCommand scData = new SqlCommand(Proc_Name, CM_OLE._conn);
                    scData.CommandType    = CommandType.StoredProcedure;
                    scData.CommandTimeout = Convert.ToInt32(1000);

                    for (int arrCnt = 0; arrCnt < Arry_Para.Length; arrCnt++)
                    {
                        scData.Parameters.Add("@" + Arry_Para[arrCnt].Trim(), Arry_Valu[arrCnt].Trim());
                    }

                    CM_OLE._conn.Open();
                    scData.ExecuteNonQuery();
                    CM_OLE._conn.Close();

                    Rtn_Message = "저장 하였습니다.";
                }
                else
                {
                    Rtn_Message = "저장에 실패하였습니다.";
                }
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message.ToString());

                Rtn_Message = "저장에 실패하였습니다.";
            }

            return(Rtn_Message);
        }
コード例 #4
0
        public static SqlDataAdapter Exec_SCMDataAdapter(string Proc_Name, string Para_Name, string Valu_Data)
        {
            string[] Arry_Para;
            string[] Arry_Valu;

            Arry_Para = Para_Name.Split('^');
            Arry_Valu = Valu_Data.Split('^');

            CM_OLE.SCMCreateConnection();
            SqlCommand scData = new SqlCommand(Proc_Name, CM_OLE._SCMconn);

            scData.CommandType    = CommandType.StoredProcedure;
            scData.CommandTimeout = Convert.ToInt32(1000);

            for (int arrCnt = 0; arrCnt < Arry_Para.Length; arrCnt++)
            {
                scData.Parameters.Add("@" + Arry_Para[arrCnt].Trim(), Arry_Valu[arrCnt].Trim());
            }

            SqlDataAdapter adtData = new SqlDataAdapter(scData);

            return(adtData);
        }