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);
}
