public static commonReturn findByID(SqlConnection pCON, string id) { commonReturn return2 = new commonReturn(); string str = ""; str = @"select a.* , (select ec_name from EOPCHE where a.balju_id = ec_id) as balju_name, (select ec_name from EOPCHE where a.jejak_id = ec_id) as jejak_name, (select ec_name from EOPCHE where a.yangsan_id = ec_id) as yangsan_name, (select ec_name from EOPCHE where a.wonsuju_id = ec_id) as wonsuju_name, (select ec_name from EOPCHE where a.buy_id = ec_id) as buy_name, (select ec_name from EOPCHE where a.where_id = ec_id) as where_name, c.MACHINE_NAME from GEUMHYEONG a left outer join EOPCHE b on (a.balju_id = b.ec_id) left outer join SEOLBI c on (a.MACHINE_CODE = c.MACHINE_CODE) where gh_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); }
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); }
public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD) { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { str = @"insert into BIGADONG (bgd_id, bgd_why, bgd_gbn, use_chk, bgd_t) values (@bgd_id, @bgd_why, @bgd_gbn, @use_chk, @bgd_t)"; } else //수정일때 { str = @"update BIGADONG set bgd_why=@bgd_why, bgd_gbn=@bgd_gbn, bgd_t = @bgd_t, use_chk = @use_chk where bgd_id = @bgd_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
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); }
public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD) { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { str = @"insert into GEUNMU (gm_id, gm_name, start_time, end_time, gm_time, gm_span) values (@gm_id, @gm_name, @start_time, @end_time , @gm_time, @gm_span)"; } else //수정일때 { str = @"update GEUNMU set gm_name=@gm_name, start_time=@start_time, end_time = @end_time, gm_time = @gm_time, gm_span=@gm_span where gm_id = @gm_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
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); }
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); }
public static commonReturn read(SqlConnection pCON, string empid, string pw) //조회함수 { commonReturn return2 = new commonReturn(); string str = ""; str = @"select * from sawon where sw_id = @사원번호 and pw = @비밀번호"; // @" select a.사원번호, a.사원이름, a.영어이름, a.비밀번호, a.직위직책, // a.부서코드, a.사원등급, b.부서이름, a.시작주ID, a.시작부ID, 제품번호, a.사용여부 // from 사원코드 a join 부서코드 b on(a.부서코드 = b.부서코드) // where a.사원번호 = @사용자ID // and a.비밀번호 = @비밀번호 "; try { SqlCommand pCMD = new SqlCommand { CommandText = str, Connection = pCON }; pCMD.Parameters.Clear(); pCMD.Parameters.AddWithValue("@사원번호", empid); pCMD.Parameters.AddWithValue("@비밀번호", pw); 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 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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
public static commonReturn findByRequirements(SqlConnection pCON, string MACHINE_CODE, string MACHINE_NAME, int MACHINE_NUMBER, string MACHINE_IP) { commonReturn return2 = new commonReturn(); string str = ""; str = @"select * from SEOLBI where MACHINE_CODE = @MACHINE_CODE or MACHINE_NAME = @MACHINE_NAME or MACHINE_NUMBER = @MACHINE_NUMBER or MACHINE_IP = @MACHINE_IP "; try { SqlCommand pCMD = new SqlCommand { CommandText = str, Connection = pCON }; pCMD.Parameters.Clear(); pCMD.Parameters.AddWithValue("@MACHINE_CODE", MACHINE_CODE); pCMD.Parameters.AddWithValue("@MACHINE_NAME", MACHINE_NAME); pCMD.Parameters.AddWithValue("@MACHINE_NUMBER", MACHINE_NUMBER); pCMD.Parameters.AddWithValue("@MACHINE_IP", MACHINE_IP); return2 = DBsql.SQLExecuteDS(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
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); }
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 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); }
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); }
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); }
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); }
public static commonReturn findByCondition(SqlConnection pCON, string balju, string gbn, string chk) //조회함수 { commonReturn return2 = new commonReturn(); string str = ""; if (chk == "Y") { str = @"select a.* , (select ec_name from EOPCHE where a.balju_id = ec_id) as balju_name, (select ec_name from EOPCHE where a.jejak_id = ec_id) as jejak_name, (select ec_name from EOPCHE where a.yangsan_id = ec_id) as yangsan_name, (select ec_name from EOPCHE where a.wonsuju_id = ec_id) as wonsuju_name, (select ec_name from EOPCHE where a.buy_id = ec_id) as buy_name, (select ec_name from EOPCHE where a.where_id = ec_id) as where_name, c.MACHINE_NAME from GEUMHYEONG a left outer join EOPCHE b on (a.balju_id = b.ec_id) left outer join SEOLBI c on (a.MACHINE_CODE = c.MACHINE_CODE) where a.use_chk = 'Y' and ec_name like '%' + @balju_name + '%' and jj_gbn like '%' + @jj_gbn + '%' "; } else { str = @"select a.* , (select ec_name from EOPCHE where a.balju_id = ec_id) as balju_name, (select ec_name from EOPCHE where a.jejak_id = ec_id) as jejak_name, (select ec_name from EOPCHE where a.yangsan_id = ec_id) as yangsan_name, (select ec_name from EOPCHE where a.wonsuju_id = ec_id) as wonsuju_name, (select ec_name from EOPCHE where a.buy_id = ec_id) as buy_name, (select ec_name from EOPCHE where a.where_id = ec_id) as where_name, c.MACHINE_NAME from GEUMHYEONG a left outer join EOPCHE b on (a.balju_id = b.ec_id) left outer join SEOLBI c on (a.MACHINE_CODE = c.MACHINE_CODE) where ec_name like '%' + @balju_name + '%' and jj_gbn like '%' + @jj_gbn + '%' "; } try { SqlCommand pCMD = new SqlCommand { CommandText = str, Connection = pCON }; pCMD.Parameters.Clear(); pCMD.Parameters.AddWithValue("@balju_name", balju); pCMD.Parameters.AddWithValue("@jj_gbn", gbn); 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 JAKEOP_JISI (jisi_id, jisi_date, wr_bs_id, wr_sw_id, gj_gbn, jisi_gbn, mnf_id, MACHINE_CODE, line_id, gh_id, qt_plan, plan_t, jp_id, cavity, cycle_t, is_work_started, memo, wr_id, auto_wr_date) values (@jisi_id, @jisi_date, @wr_bs_id, @wr_sw_id, @gj_gbn, @jisi_gbn, @mnf_id, @MACHINE_CODE, @line_id, @gh_id, @qt_plan, @plan_t, @jp_id, @cavity, @cycle_t, @is_work_started, @memo, @wr_id, getdate())"; } else //수정일때 { str = @"update JAKEOP_JISI set jisi_date =@jisi_date , wr_bs_id =@wr_bs_id , wr_sw_id =@wr_sw_id , gj_gbn =@gj_gbn , jisi_gbn =@jisi_gbn , mnf_id =@mnf_id , MACHINE_CODE =@MACHINE_CODE , line_id =@line_id , gh_id =@gh_id , qt_plan =@qt_plan , plan_t =@plan_t , jp_id =@jp_id, cavity =@cavity, cycle_t =@cycle_t , is_work_started =@is_work_started , memo =@memo , upd_id =@wr_id , auto_upd_date =getdate() where jisi_id = @jisi_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
public static commonReturn write(SqlConnection pCON, bool is_add, SqlCommand pCMD) //공정코드 테이블 추가시 수정필요 gj_name -> gj_id { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { //제품코드 제품이름 제품번호 차종 모델 자재번호 규격 색상 색상이름 등록일자 승인일자 양산일자 단종일자 단종사유 적정재고 캐비티 포장수량 사이클타임 메모 사용여부 사진1,2,3,4 str = @"insert into JEPUM (jp_id, jp_name, jp_num, car, model, mtrl_num, spec, jp_color, color_name, sj_id, gh_id, wr_date, aprv_date, mass_date, discont_date, discont_why, opt_stock, now_stock, cavity, cavity_num, qt_pkg, cycle_t, memo, use_chk, jp_img1, jp_img2, jp_img3, jp_img4, jp_stdpaper, auto_wr_date) values (@jp_id, @jp_name, @jp_num, @car, @model, @mtrl_num, @spec, @jp_color, @color_name, @sj_id, @gh_id, @wr_date, @aprv_date, @mass_date, @discont_date, @discont_why, @opt_stock, @now_stock, @cavity, @cavity_num, @qt_pkg, @cycle_t, @memo, @use_chk, @jp_img1, @jp_img2, @jp_img3, @jp_img4, @jp_stdpaper, getdate())"; } else //수정일때 { str = @"update JEPUM set jp_name=@jp_name, jp_num=@jp_num, car=@car, model=@model, mtrl_num=@mtrl_num, spec=@spec, jp_color=@jp_color, color_name=@color_name, sj_id = @sj_id,gh_id=@gh_id, wr_date=@wr_date, aprv_date=@aprv_date, mass_date=@mass_date, discont_date=@discont_date, discont_why=@discont_why, now_stock=@now_stock, opt_stock=@opt_stock, cavity=@cavity, cavity_num = @cavity_num, qt_pkg=@qt_pkg, cycle_t=@cycle_t, memo=@memo, use_chk=@use_chk, jp_img1=@jp_img1, jp_img2=@jp_img2, jp_img3=@jp_img3, jp_img4=@jp_img4, jp_stdpaper =@jp_stdpaper, auto_upd_date = getdate() where jp_id = @jp_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
public static commonReturn write(SqlConnection pCON, bool is_add, bool isCompleted, SqlCommand pCMD) { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { str = @"insert into JAKEOP_SILJEOK (siljeok_id, jisi_id, work_date, bs_id, sw_id, gm_id, lot_number, start_time, end_time, work_time, bgd_time, qt_total, qt_manuf, qt_init, qt_error) values (@siljeok_id, @jisi_id, @work_date, @bs_id, @sw_id, @gm_id, @lot_number, @start_time, @end_time, @work_time, @bgd_time, @qt_total, @qt_manuf, @qt_init, @qt_error)"; } else //수정일때 { str = @"update JAKEOP_SILJEOK set work_date=@work_date, bs_id=@bs_id, sw_id=@sw_id, gm_id=@gm_id, lot_number=@lot_number, start_time=@start_time, end_time=@end_time, work_time=@work_time, bgd_time =@bgd_time, qt_total=@qt_total, qt_manuf=@qt_manuf, qt_init=@qt_init, qt_error=@qt_error where siljeok_id = @siljeok_id"; } if (isCompleted) { str += @"update JAKEOP_JISI set jisi_gbn = @jisi_gbn, is_work_started=@is_work_started where jisi_id = @jisi_id;"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
public static commonReturn write_ec(SqlConnection pCON, bool is_add, SqlCommand pCMD) { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { //업체구분 등급 국가 통화 업체코드 상호 세액적용 세금용상호 대표자 사업자번호 업태 종목 전번 팩스 기타 메일 홈피 우편번호 주소시군 주소번지 거래유무 거래중지사유 메모 str = @"insert into EOPCHE (ec_gbn, ec_grade, nation, currency, ec_id, ec_name, tax_app, tax_ec_name, ceo, service_num, ec_type, ec_item, tel, fax, etc_tel, mail, homepage, trade_chk, trade_end, memo, post_num, city, street, wr_date) values (@ec_gbn, @ec_grade, @nation, @currency, @ec_id, @ec_name, @tax_app, @tax_ec_name, @ceo, @service_num, @ec_type, @ec_item, @tel, @fax, @etc_tel, @mail, @homepage, @trade_chk, @trade_end, @memo, @post_num, @city, @street, convert(varchar(10), getdate(), 121) )"; } else //수정일때 { str = @"update EOPCHE set ec_gbn=@ec_gbn, ec_grade=@ec_grade, nation=@nation, currency=@currency, ec_name=@ec_name, tax_app=@tax_app, tax_ec_name=@tax_ec_name, ceo=@ceo, service_num=@service_num, ec_type=@ec_type, ec_item=@ec_item, tel=@tel, fax=@fax, etc_tel=@etc_tel, mail=@mail, homepage=@homepage, trade_chk=@trade_chk, trade_end=@trade_end, memo=@memo, post_num=@post_num, city=@city, street=@street where ec_id = @ec_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }
public static commonReturn write_dd(SqlConnection pCON, bool is_add, SqlCommand pCMD) { commonReturn return2 = new commonReturn(); string str = ""; if (is_add == true) //추가일때 { //담당코드, 담당이름, 부서이름, 직위직책, 전화번호, 팩스번호, 휴대전화, 메일, 메모, 사용여부, 업체코드 str = @"select @dd_id = isnull(max(dd_id), 0) + 1 from EOPCHE_DAMDANG if @dd_id = 0 set @dd_id = 1 insert into EOPCHE_DAMDANG (dd_id,dd_name,bs_name,pos, tel,fax,mobi,mail, memo,use_chk, ec_id) values (@dd_id, @dd_name, @bs_name, @pos, @tel, @fax, @mobi, @mail, @memo, @use_chk, @ec_id)"; } else //수정일때 { str = @"update EOPCHE_DAMDANG set dd_name=@dd_name, bs_name=@bs_name, pos=@pos, tel=@tel, fax=@fax, mobi=@mobi, mail=@mail, memo=@memo, use_chk=@use_chk where dd_id = @dd_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(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 SAWON (sw_id, pw, sw_name, sw_eng_name, bs_id, pos, mobi, mail, std_lab_rt, std_lab_t, memo, use_chk, user_gbn, sw_img, auto_wr_date, ALARM_CHK) values (@sw_id, @pw, @sw_name, @sw_eng_name, @bs_id, @pos, @mobi, @mail, @std_lab_rt, @std_lab_t, @memo, @use_chk, @user_gbn, @sw_img, getdate(), @ALARM_CHK)"; } else //수정일때 { str = @"update SAWON set pw=@pw, sw_name=@sw_name, sw_eng_name=@sw_eng_name, bs_id=@bs_id, pos=@pos, mobi=@mobi, mail=@mail, std_lab_rt=@std_lab_rt, std_lab_t=@std_lab_t, memo=@memo, use_chk=@use_chk, user_gbn=@user_gbn, sw_img=@sw_img, auto_upd_date=getdate(), ALARM_CHK=@ALARM_CHK where sw_id = @sw_id"; } try { pCMD.CommandText = str; pCMD.Connection = pCON; return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD); } catch (Exception exception) { return2.Message = exception.ToString(); } return(return2); }