public static commonReturn findByID(SqlConnection pCON, string sw_id) //기존 권한 내역이 존재하는지 여부를 알아내기위해
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select * from MENU_PERMISSION where sw_id = @sw_id";

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };

                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@sw_id", sw_id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#2
0
        public static commonReturn findByWorkOrderID(SqlConnection pCON, string id) //작업지시 기준 조회
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select a.*, b.*, c.MACHINE_NAME, d.sw_name, e.bs_name, f.gm_name, g.sj_name,
                                h.jp_name, h.jp_num, h.car, h.model, h.mtrl_num, h.cavity, h.cycle_t

                       from JAKEOP_SILJEOK a left outer join JAKEOP_JISI b on (a.jisi_id = b.jisi_id)
                                                left outer join SEOLBI c on (b.MACHINE_CODE = c.MACHINE_CODE)
                                                left outer join SAWON d on (a.sw_id = d.sw_id)
                                                left outer join BUSEO e on (a.bs_id = e.bs_id)
                                                left outer join GEUNMU f on (a.gm_id = f.gm_id)
                                                left outer join JEPUM h on (b.jp_id = h.jp_id)
                                                left outer join SUJI g on (h.sj_id = g.sj_id)

                       where a.jisi_id= @jisi_id ";
            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@jisi_id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
        private DataRow readMachineInfo(string MachineID)
        {
            DataRow      row         = null;
            commonReturn MachineInfo = new commonReturn();

            MachineInfo = fx_machineCode.findByID(commonVar.DBconn, MachineID);

            if (MachineInfo.Message == "" && MachineInfo.Dataset.Tables[0].Rows.Count > 0)
            {
                row = MachineInfo.Dataset.Tables[0].Rows[0];

                selectedInfo.MachineNum  = Convert.ToInt32(row["MACHINE_NUMBER"]);
                selectedInfo.MachineName = Convert.ToString(row["MACHINE_NAME"]);
                selectedInfo.MachineType = Convert.ToString(row["MACHINE_TYPE"]);
            }
            else
            {
                selectedInfo.MachineNum  = 0;
                selectedInfo.MachineName = string.Empty;
                selectedInfo.MachineType = string.Empty;
            }


            return(row);
        }
示例#4
0
        private void conditionalRead()
        {
            string use = "";

            if (chk_use.Checked == true)
            {
                use = "Y";
            }
            else
            {
                use = "N";
            }

            commonReturn Return = new commonReturn();

            Return = fx_resinCode.findByName(commonVar.DBconn, txt_name.Text, use);

            if (Return.Message == "")
            {
                ds_resinCode            = Return.Dataset;
                gridControl1.DataSource = Return.Dataset.Tables[0].DefaultView;
            }
            else
            {
                MessageBox.Show(Return.Message, "DB 에러!");
            }
        }
示例#5
0
        public static commonReturn ReadErrorDetails(SqlConnection pCON, bool is_add, string id)
        {
            commonReturn return2 = new commonReturn();
            string       str     = string.Empty;

            if (is_add)
            {
                str = @"select a.*, 0 as qt_br 
                        from BULRYANG_WONIN a";
            }
            else
            {
                str = @"select a.*, b.qt_br 
                        from BULRYANG_WONIN a 
                                left outer join JAKEOP_SILJEOK_BR b on (a.br_id = b.br_id)
                        where siljeok_id like '%' + @siljeok_id + '%' ;";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@siljeok_id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#6
0
        public static commonReturn read_all(SqlConnection pCON, string chk) //조회함수
        {
            commonReturn return2 = new commonReturn();

            string str = "";

            if (chk == "Y")
            {
                str = @"select * from BUSEO where use_chk = 'Y' order by bs_id";
            }
            else
            {
                str = @"select * from BUSEO order by bs_id";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#7
0
        public static commonReturn findByID(SqlConnection pCON, string id)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select * from BUSEO where bs_id = @bs_id ";

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };

                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@bs_id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#8
0
        public static commonReturn SQLExecuteNonQuery(SqlConnection pCON, SqlCommand pCMD)
        {
            commonReturn commonReturn = new commonReturn();

            try
            {
                if (pCON.State != ConnectionState.Open)
                {
                    pCON.Open();
                }

                pCMD.Connection       = pCON;
                pCMD.CommandTimeout   = 120;
                commonReturn.ExeCount = pCMD.ExecuteNonQuery();
                commonReturn.Code     = 1;
                commonReturn.Message  = "";

                return(commonReturn);
            }
            catch (Exception ex)
            {
                commonReturn.Code    = -1;
                commonReturn.Message = ex.ToString();
            }
            finally
            {
                pCMD.Dispose();
            }
            return(commonReturn);
        }
示例#9
0
        public static commonReturn findBy2Param(SqlConnection pCON, string name, string dept)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select a.*, b.bs_name 
                        from SAWON a left outer join BUSEO b on (a.bs_id = b.bs_id) 
                        where a.use_chk = 'Y'
                        and a.sw_name like '%' + @name + '%'
                        and b.bs_name like '%' + @dept + '%'
                        order by b.bs_name, a.sw_id";

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@name", name);
                pCMD.Parameters.AddWithValue("@dept", dept);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
        public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (is_add == true)   //추가일때
            {
                str = @"insert into BULRYANG_WONIN
                            (br_id, br_detail, br_gbn, use_chk, seq_num)

                            values
                            (@br_id, @br_detail, @br_gbn, @use_chk, @seq_num)";
            }
            else //수정일때
            {
                str = @"update BULRYANG_WONIN
                            set 
                            br_detail=@br_detail, br_gbn=@br_gbn, use_chk = @use_chk, seq_num = @seq_num

                            where br_id = @br_id";
            }

            try
            {
                pCMD.CommandText = str;
                pCMD.Connection  = pCON;
                return2          = DBsql.SQLExecuteNonQuery(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#11
0
        public static commonReturn SQLExecuteDS(SqlConnection pCON, SqlCommand pCMD)
        {
            commonReturn   commonReturn = new commonReturn();
            SqlDataAdapter DA           = new SqlDataAdapter();

            try
            {
                if (pCON.State != ConnectionState.Open)
                {
                    pCON.Open();
                }

                pCMD.Connection     = pCON;
                pCMD.CommandTimeout = 0;
                if (pCMD.CommandType != CommandType.StoredProcedure)
                {
                    pCMD.CommandType = System.Data.CommandType.Text;
                }
                DA.SelectCommand = pCMD;
                DA.Fill(commonReturn.Dataset);
                commonReturn.Code = 1;
            }
            catch (Exception ex)
            {
                commonReturn.Code    = -1;
                commonReturn.Message = ex.ToString();
            }
            finally
            {
                pCMD.Dispose();
            }

            return(commonReturn);
        }
示例#12
0
        private void btn_delete_Click(object sender, EventArgs e)
        {
            parentRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
            if (parentRow == null)
            {
                MessageBox.Show("삭제할 자료를 선택하세요.");
            }
            else
            {
                DialogResult question = MessageBox.Show("선택하신 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (question == DialogResult.Yes)
                {
                    if (edit.Visible == true)
                    {
                        MessageBox.Show("삭제 불가능 상태입니다. 뒤로가기 버튼을 누르세요.");
                        return;
                    }
                    bizID = parentRow["ec_id"].ToString();


                    commonReturn Return = new commonReturn();

                    Return = fx_bizCode.delete_ec(commonVar.DBconn, bizID);

                    if (Return.Message == "")
                    {
                        parentRow.Delete();
                    }
                    else
                    {
                        MessageBox.Show(Return.Message, "DB 에러!");
                    }
                }
            }//else
        }
示例#13
0
        private void read_grid1()         //업체코드 그리드
        {
            string use = "";

            if (chk_use.Checked == true)
            {
                use = "Y";
            }
            else
            {
                use = "N";
            }

            commonReturn Return = new commonReturn();

            Return = fx_bizCode.read_all_ec(commonVar.DBconn, use);

            if (Return.Message == "")
            {
                ds_bizCode = Return.Dataset;
                gridControl1.DataSource = Return.Dataset.Tables[0].DefaultView;
            }
            else
            {
                MessageBox.Show(Return.Message, "DB 에러!");
            }
        }
示例#14
0
        public static commonReturn write(SqlConnection pCON, SqlCommand pCMD)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"insert into MENU_PERMISSION
                            (sw_id, menu_access, menu_add, menu_upd, menu_del,
                             menu_search, menu_print, menu_convert, parent_id, child_id)

                            values
                             (@sw_id, @menu_access, @menu_add, @menu_upd, @menu_del,
                             @menu_search, @menu_print, @menu_convert, @parent_id, @child_id)";

            try
            {
                pCMD.CommandText = str;
                pCMD.Connection  = pCON;
                return2          = DBsql.SQLExecuteNonQuery(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#15
0
        private void conditionalRead()
        {
            if (commonVar.DBconn.State == ConnectionState.Closed)
            {
                commonVar.DBconn.ConnectionString = commonVar.dbConnectionString;
            }

            string use = "";

            if (chk_use.Checked == true)
            {
                use = "Y";
            }
            else
            {
                use = "N";
            }

            commonReturn Return = new commonReturn();

            Return = fx_errorCode.findByMsg(commonVar.DBconn, txt_msg.Text, use);

            if (Return.Message == "")
            {
                ds_errorCode            = Return.Dataset;
                gridControl1.DataSource = Return.Dataset.Tables[0].DefaultView;
            }
            else
            {
                MessageBox.Show(Return.Message, "DB 에러!");
            }
        }
示例#16
0
        private void btn_delete_Click(object sender, EventArgs e)
        {
            parentRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
            if (parentRow == null)
            {
                MessageBox.Show("삭제할 자료를 선택하세요.");
            }
            else
            {
                DialogResult question = MessageBox.Show("선택하신 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (question == DialogResult.Yes)
                {
                    deptID = parentRow["bs_id"].ToString();

                    if (commonVar.DBconn.State == ConnectionState.Closed)
                    {
                        commonVar.DBconn.ConnectionString = commonVar.dbConnectionString;
                    }

                    commonReturn Return = new commonReturn();

                    Return = fx_deptCode.delete(commonVar.DBconn, deptID);

                    if (Return.Message == "")
                    {
                        parentRow.Delete();
                        parentRow.AcceptChanges();
                    }
                    else
                    {
                        MessageBox.Show(Return.Message, "DB 에러!");
                    }
                }
            }//else
        }
示例#17
0
        public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (is_add == true)   //추가일때
            {
                str = @"insert into BUSEO
                            (bs_id, bs_name, use_chk)

                            values
                            (@bs_id, @bs_name, @use_chk)";
            }
            else //수정일때
            {
                str = @"update BUSEO
                            set 
                            bs_name=@bs_name, use_chk=@use_chk

                            where bs_id = @bs_id";
            }

            try
            {
                pCMD.CommandText = str;
                pCMD.Connection  = pCON;
                return2          = DBsql.SQLExecuteNonQuery(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#18
0
        private void read()
        {
            if (commonVar.DBconn.State == ConnectionState.Closed)
            {
                commonVar.DBconn.ConnectionString = commonVar.dbConnectionString;
                commonVar.DBconn.Open();
            }

            string use = "";

            if (chk_use.Checked == true)
            {
                use = "Y";
            }
            else
            {
                use = "N";
            }

            commonReturn Return = new commonReturn();

            Return = fx_deptCode.read_all(commonVar.DBconn, use);

            if (Return.Message == "")
            {
                ds_deptCode             = Return.Dataset;
                gridControl1.DataSource = Return.Dataset.Tables[0].DefaultView;
            }
            else
            {
                MessageBox.Show(Return.Message, "DB 에러!");
            }
        }
示例#19
0
        public static commonReturn findByName(SqlConnection pCON, string name, string chk)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (chk == "Y")
            {
                str = @"select * from BUSEO where bs_name like '%' + @name + '%' and use_chk = @chk";
            }
            else
            {
                str = @"select * from BUSEO where bs_name like '%' + @name + '%' ";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@name", name);
                pCMD.Parameters.AddWithValue("@chk", chk);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#20
0
        public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (is_add == true)   //추가일때
            {
                str = @"insert into ERROR
                            (err_id, err_msg, server_id, use_chk)

                            values
                            (@err_id, @err_msg, @server_id, @use_chk)";
            }
            else //수정일때
            {
                str = @"update ERROR
                            set 
                            err_msg=@err_msg, server_id = @server_id, use_chk=@use_chk

                            where err_id = @err_id";
            }

            try
            {
                pCMD.CommandText = str;
                pCMD.Connection  = pCON;
                return2          = DBsql.SQLExecuteNonQuery(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#21
0
        private void read()
        {
            string use = "";

            if (chk_use.Checked == true)
            {
                use = "Y";
            }
            else
            {
                use = "N";
            }

            commonReturn Return = new commonReturn();

            Return = fx_resinCode.readResinRecords(commonVar.DBconn, use);

            if (Return.Message == "")
            {
                ds_resinCode            = Return.Dataset;
                gridControl1.DataSource = Return.Dataset.Tables[0].DefaultView;
            }
            else
            {
                MessageBox.Show(Return.Message, "DB 에러!");
            }
        }
示例#22
0
        public static commonReturn read_all(SqlConnection pCON, string chk) //조회함수
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (chk == "Y")
            {
                str = @"select a.*, b.sj_name
                            from JEPUM a
                                    left outer join SUJI b on (a.sj_id = b.sj_id)
                            where a.use_chk = 'Y' ";
            }
            else
            {
                str = @"select *, b.sj_name
                            from JEPUM a
                                    left outer join SUJI b on (a.sj_id = b.sj_id)";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#23
0
        public static commonReturn ReadWorkOrder(SqlConnection pCON, string id) //작업지시 조회
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select a.*, b.jp_name, b.jp_num, b.car, b.model, b.mtrl_num, b.now_stock, b.cavity as original_cavity, b.cycle_t as original_cycle, b.sj_id,
                                b.sj_id, b.jp_stdpaper, c.MACHINE_NAME, d.sw_name, e.bs_name, f.ec_name, g.sj_name

                       from JAKEOP_JISI a left outer join JEPUM b on (a.jp_id = b.jp_id)
                                                left outer join SEOLBI c on (a.MACHINE_CODE = c.MACHINE_CODE)
                                                left outer join SAWON d on (a.wr_sw_id = d.sw_id)
                                                left outer join BUSEO e on (a.wr_bs_id = e.bs_id)
                                                left outer join EOPCHE f on (a.mnf_id = f.ec_id)
                                                left outer join SUJI g on (b.sj_id = g.sj_id)
                        where a.jisi_id = @jisi_id";
            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@jisi_id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#24
0
        public static commonReturn findByID(SqlConnection pCON, string id)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select a.*, b.sj_name
                        from JEPUM  a
                               left outer join SUJI b on (a.sj_id = b.sj_id) where a.jp_id = @id ";

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };

                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#25
0
        public static commonReturn ReadBreakTimeDetails(SqlConnection pCON, bool is_add, string id)
        {
            commonReturn return2 = new commonReturn();
            string       str     = string.Empty;

            if (is_add)
            {
                str = @"select a.*, '00:00' as start_time, '00:00' as end_time, '00:00' as bgd_time
                        from BIGADONG a;";
            }
            else
            {
                str = @"select a.*, b.start_time, b.end_time, b.bgd_time
                           from BIGADONG a 
                                 left outer join JAKEOP_SILJEOK_BGD b on (a.bgd_id = b.bgd_id)
                           where siljeok_id like '%' + @siljeok_id + '%' ";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@siljeok_id", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#26
0
        public static commonReturn findByCondition(SqlConnection pCON, string gbn, string name)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            str = @"select * from EOPCHE where ec_gbn_name like '%' + @gbn + '%' and ec_name like '%' + @name + '%' ";

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@gbn", gbn);
                pCMD.Parameters.AddWithValue("@name", name);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
示例#27
0
        private DataRow readMoldInfo(string MoldID)
        {
            DataRow      row      = null;
            commonReturn MoldInfo = new commonReturn();

            MoldInfo = fx_moldCode.findByID(commonVar.DBconn, MoldID);
            if (MoldInfo.Message == "" && MoldInfo.Dataset.Tables[0].Rows.Count > 0)
            {
                row = MoldInfo.Dataset.Tables[0].Rows[0];

                selectedInfo.MoldModel  = Convert.ToString(row["model"]);
                selectedInfo.MoldName   = Convert.ToString(row["gh_name"]);
                selectedInfo.MoldNum    = Convert.ToString(row["gh_num"]);
                selectedInfo.MoldShot   = Convert.ToInt32(row["accumulated"]);
                selectedInfo.MoldCavity = Convert.ToString(row["cavity"]);
            }
            else
            {
                selectedInfo.MoldModel  = string.Empty;
                selectedInfo.MoldName   = string.Empty;
                selectedInfo.MoldNum    = string.Empty;
                selectedInfo.MoldShot   = 0;
                selectedInfo.MoldCavity = string.Empty;
            }

            return(row);
        }
示例#28
0
        public static commonReturn findByGbn(SqlConnection pCON, string gbn, string chk)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            if (chk == "Y")
            {
                str = @"select * from EOPCHE where ec_gbn_name like '%' + @gbn + '%' and trade_chk = @chk";
            }
            else
            {
                str = @"select * from EOPCHE where ec_gbn like '%' + @gbn + '%' ";
            }

            try
            {
                SqlCommand pCMD = new SqlCommand
                {
                    CommandText = str,
                    Connection  = pCON
                };
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@gbn", gbn);
                pCMD.Parameters.AddWithValue("@chk", chk);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }
        private void btn_delete_Click(object sender, EventArgs e)
        {
            parentRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
            if (parentRow == null)
            {
                MessageBox.Show("삭제할 자료를 선택하세요.");
            }
            else
            {
                DialogResult question = MessageBox.Show("선택하신 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (question == DialogResult.Yes)
                {
                    nonOpID = parentRow["bgd_id"].ToString();


                    commonReturn Return = new commonReturn();

                    Return = fx_nonOperationCode.delete(commonVar.DBconn, nonOpID);

                    if (Return.Message == "")
                    {
                        parentRow.Delete();
                    }
                    else
                    {
                        MessageBox.Show(Return.Message, "DB 에러!");
                    }
                }
            }//else
        }
示例#30
0
        public static commonReturn delete(SqlConnection pCON, string id)
        {
            commonReturn return2 = new commonReturn();
            string       str     = "";

            try
            {
                SqlCommand pCMD = new SqlCommand();
                str = @"BEGIN TRY
                                    BEGIN TRAN
                                    update SEOLBI set Maptype=null where MACHINE_CODE=@MACHINE_CODE
                                    delete from SEOLBI where MACHINE_CODE = @MACHINE_CODE

                                    update SEOLBI set MapType=null where MACHINE_CODE = @MACHINE_CODE
                                    delete from SEOLBI where MACHINE_CODE = @MACHINE_CODE
                                    COMMIT TRAN
                            END TRY

                            BEGIN CATCH
                                    ROLLBACK TRAN
                            END CATCH ";
                pCMD.CommandText = str;
                pCMD.Connection  = pCON;
                pCMD.Parameters.Clear();
                pCMD.Parameters.AddWithValue("@MACHINE_CODE", id);
                return2 = DBsql.SQLExecuteDS(pCON, pCMD);
            }
            catch (Exception exception)
            {
                return2.Message = exception.ToString();
            }
            return(return2);
        }