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 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 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 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 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 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 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, 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(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_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);
}
public static commonReturn delete_dd(SqlConnection pCON, string id)
{
commonReturn return2 = new commonReturn();
string str = "";
try
{
SqlCommand pCMD = new SqlCommand();
str = " delete From EOPCHE_DAMDANG where dd_id = @dd_id ";
pCMD.CommandText = str;
pCMD.Connection = pCON;
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@dd_id", id);
return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn writeResinRecord(SqlConnection pCON, bool is_add, SqlCommand pCMD)
{
commonReturn return2 = new commonReturn();
string str = "";
if (is_add == true) //추가일때
{
str = @"insert into SUJI
(sj_id, sj_name, grade, maker, chk_gbn, ms_spec,
sj_color, color_name, opt_stock, loss_rate,
unit, unit_price, use_chk, memo, auto_wr_date)
values
(@sj_id, @sj_name, @grade, @maker, @chk_gbn, @ms_spec,
@sj_color, @color_name, @opt_stock, @loss_rate,
@unit, @unit_price, @use_chk, @memo, getdate())";
}
else //수정일때
{
str = @"update SUJI
set
sj_name=@sj_name, grade=@grade, maker=@maker, chk_gbn=@chk_gbn, ms_spec=@ms_spec,
sj_color=@sj_color, color_name=@color_name, opt_stock=@opt_stock, loss_rate=@loss_rate,
unit=@unit, unit_price =@unit_price, use_chk=@use_chk, memo=@memo, auto_upd_date=getdate()
where sj_id = @sj_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 = @"select @gt_id = isnull(max(gt_id), 0) + 1 from GONGTONG
if @gt_id = 0
set @gt_id = 1
insert into GONGTONG
(gt_id, gt_grp, gt_name, use_chk)
values
(@gt_id, @gt_grp, @gt_name, @use_chk)";
}
else //수정일때
{
str = @"update GONGTONG
set
gt_grp=@gt_grp, gt_name=@gt_name, use_chk = @use_chk
where gt_id = @gt_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) //SEOLBI 테이블
{
commonReturn return2 = new commonReturn();
string str = "";
if (is_add == true) //추가일때
{
//설비코드 설비이름 설비구분 ip 포트 메모리맵 설비번호 표준가동 표준임률 관리부서 관리자 점검주기 제조국가 메이커명 모델명 제조년월 제조번호 구입날짜 부대비용 규격 컨트롤러 이미지경로 메모 사용여부
str = @"BEGIN TRY
BEGIN TRAN
insert into SEOLBI
(MACHINE_CODE, MACHINE_NAME, MACHINE_TYPE, MACHINE_IP, MACHINE_NUMBER, MapType, std_op_hr,
admin_bs, admin_main, chk_term,
nation, maker, model, mnf_date, mnf_num,
buy_date, buy_price, xtra_cost, size, ctlr,
sb_img, memo, use_chk )
values
(@MACHINE_CODE, @MACHINE_NAME, @MACHINE_TYPE, @MACHINE_IP, @MACHINE_NUMBER, @MapType, @std_op_hr,
@admin_bs, @admin_main, @chk_term,
@nation, @maker, @model, @mnf_date, @mnf_num,
@buy_date, @buy_price, @xtra_cost, @size, @ctlr,
@sb_img, @memo, @use_chk);
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
PRINT ERROR_MESSAGE();
END CATCH ";
}
else //수정일때
{
str = @"BEGIN TRY
BEGIN TRAN
update SEOLBI
set
MACHINE_NAME=@MACHINE_NAME, MACHINE_TYPE=@MACHINE_TYPE, MACHINE_IP=@MACHINE_IP,
MACHINE_NUMBER=@MACHINE_NUMBER, MapType = @MapType, std_op_hr=@std_op_hr,
admin_bs=@admin_bs, admin_main=@admin_main, chk_term=@chk_term,
nation=@nation, maker=@maker, model=@model, mnf_date=@mnf_date, mnf_num=@mnf_num,
buy_date=@buy_date, buy_price=@buy_price, xtra_cost=@xtra_cost, size=@size, ctlr=@ctlr,
sb_img=@sb_img, memo=@memo, use_chk=@use_chk
where MACHINE_CODE = @MACHINE_CODE;
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
PRINT ERROR_MESSAGE();
END CATCH ";
}
try
{
string ErrorMessage = string.Empty;
pCON.InfoMessage += delegate(object sender, SqlInfoMessageEventArgs e)
{
ErrorMessage = e.Message;
};
pCMD.CommandText = str;
pCMD.Connection = pCON;
return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD);
if (ErrorMessage.Length > 0)
{
return2.Message = ErrorMessage;
}
}
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 GEUMHYEONG
(gh_id, model, gh_name, gh_num, nation, currency, gh_gbn, jj_gbn, MACHINE_CODE,
jj_goal, buy_dd, design_dd1, design_dd2, jj_dd1, jj_dd2,
balju_num, balju_id, jejak_id, yangsan_id, wonsuju_id, buy_id, where_id,
wr_date, fix_date, nego_date, t0_date, t1_date, init_date, okay_date,
out_date, ship_date, arrive_date, ys_date, dump_date, location,
chk_shot, chk_month, chk_freq, chk_final_date, chk_final_shot,
spec_freq, error_freq, blueprint_freq, sample_freq, warranty, limit,
init_shot, accumulated, auth_num, size, weight, spec, cavity,
mtrl_core, qt_core, mtrl_cavity, qt_cavity, mtrl_upSL, qt_upSL,
mtrl_lowSL, qt_lowSL, mtrl_angular, qt_angular, shrink, gate_type,
runner_eject, jp_eject, machine_type, inject_type, cycle_t,
gh_img1, gh_img2, gh_img3, gh_img4, memo, use_chk)
values
(@gh_id, @model, @gh_name, @gh_num, @nation, @currency, @gh_gbn, @jj_gbn, @MACHINE_CODE,
@jj_goal, @buy_dd, @design_dd1, @design_dd2, @jj_dd1, @jj_dd2,
@balju_num, @balju_id, @jejak_id, @yangsan_id, @wonsuju_id, @buy_id, @where_id,
@wr_date, @fix_date, @nego_date, @t0_date, @t1_date, @init_date, @okay_date,
@out_date, @ship_date, @arrive_date, @ys_date, @dump_date, @location,
@chk_shot, @chk_month, @chk_freq, @chk_final_date, @chk_final_shot,
@spec_freq, @error_freq, @blueprint_freq, @sample_freq, @warranty, @limit,
@init_shot, @accumulated, @auth_num, @size, @weight, @spec, @cavity,
@mtrl_core, @qt_core, @mtrl_cavity, @qt_cavity, @mtrl_upSL, @qt_upSL,
@mtrl_lowSL, @qt_lowSL, @mtrl_angular, @qt_angular, @shrink, @gate_type,
@runner_eject, @jp_eject, @machine_type, @inject_type, @cycle_t,
@gh_img1, @gh_img2, @gh_img3, @gh_img4, @memo, @use_chk)";
}
else //수정일때
{
str = @"update GEUMHYEONG
set
model=@model , gh_name=@gh_name , gh_num=@gh_num , nation=@nation , currency=@currency , gh_gbn=@gh_gbn , jj_gbn=@jj_gbn , MACHINE_CODE=@MACHINE_CODE,
jj_goal=@jj_goal , buy_dd=@buy_dd , design_dd1=@design_dd1 , design_dd2=@design_dd2 , jj_dd1=@jj_dd1 , jj_dd2=@jj_dd2 ,
balju_num=@balju_num , balju_id=@balju_id , jejak_id=@jejak_id , yangsan_id=@yangsan_id , wonsuju_id=@wonsuju_id , buy_id=@buy_id , where_id=@where_id ,
wr_date=@wr_date , fix_date=@fix_date , nego_date=@nego_date , t0_date=@t0_date , t1_date=@t1_date , init_date=@init_date , okay_date=@okay_date ,
out_date=@out_date , ship_date=@ship_date , arrive_date=@arrive_date , ys_date=@ys_date , dump_date=@dump_date , location=@location ,
chk_shot=@chk_shot , chk_month=@chk_month , chk_freq=@chk_freq , chk_final_date=@chk_final_date , chk_final_shot=@chk_final_shot ,
spec_freq=@spec_freq , error_freq=@error_freq , blueprint_freq=@blueprint_freq , sample_freq=@sample_freq , warranty=@warranty , limit=@limit ,
init_shot=@init_shot , accumulated=@accumulated , auth_num=@auth_num , size=@size , weight=@weight , spec=@spec , cavity=@cavity ,
mtrl_core=@mtrl_core , qt_core=@qt_core , mtrl_cavity=@mtrl_cavity , qt_cavity=@qt_cavity , mtrl_upSL=@mtrl_upSL , qt_upSL=@qt_upSL ,
mtrl_lowSL=@mtrl_lowSL , qt_lowSL=@qt_lowSL , mtrl_angular=@mtrl_angular , qt_angular=@qt_angular , shrink=@shrink , gate_type=@gate_type ,
runner_eject=@runner_eject , jp_eject=@jp_eject , machine_type=@machine_type , inject_type=@inject_type , cycle_t=@cycle_t ,
gh_img1=@gh_img1 , gh_img2=@gh_img2 , gh_img3=@gh_img3 , gh_img4=@gh_img4 , memo=@memo , use_chk=@use_chk
where gh_id = @gh_id";
}
try
{
pCMD.CommandText = str;
pCMD.Connection = pCON;
return2 = DBsql.SQLExecuteNonQuery(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
