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 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 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 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_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 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 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 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 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 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 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 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 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 delete(SqlConnection pCON, string id)
{
commonReturn return2 = new commonReturn();
string str = "";
try
{
SqlCommand pCMD = new SqlCommand();
str = "delete from BULRYANG_WONIN where br_id = @br_id";
pCMD.CommandText = str;
pCMD.Connection = pCON;
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@br_id", id);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn deletePerformance(SqlConnection pCON, string id)
{
commonReturn return2 = new commonReturn();
string str = "";
try
{
SqlCommand pCMD = new SqlCommand();
str = "delete from JAKEOP_SILJEOK where siljeok_id = @id";
pCMD.CommandText = str;
pCMD.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 read_menu(SqlConnection pCON, string sw_id)
{
commonReturn return2 = new commonReturn();
string str = "";
//(case when y.child_id = 0 then '▶ ' + y.menu_name else ' ▷ ' + y.menu_name end) menu_name,
str = @"select isnull(x.permission_id, -1) as pemission_id , isnull(x.sw_id, '-1x') as sw_id , y.parent_id, y.child_id,
y.menu_name,
cast(isnull(x.menu_access, 0) as bit) menu_access,
cast(isnull(x.menu_add, 0) as bit) menu_add,
cast(isnull(x.menu_upd, 0) as bit) menu_upd,
cast(isnull(x.menu_del, 0) as bit) menu_del,
cast(isnull(x.menu_search, 0) as bit) menu_search,
cast(isnull(x.menu_print, 0) as bit) menu_print,
cast(isnull(x.menu_convert, 0) as bit) menu_convert
from (select * from MENU_PERMISSION where sw_id = @sw_id) x
right outer join MENU_TYPE y on (x.parent_id = y.parent_id and x.child_id = y.child_id)
where y.use_chk = 'Y'
order by y.parent_id, y.child_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 findByName(SqlConnection pCON, string model, 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.model like '%' + @model + '%'
and a.use_chk = @chk";
}
else
{
str = @"select a.*, b.sj_name
from JEPUM a
left outer join SUJI b on (a.sj_id = b.sj_id)
where a.model like '%' + @model + '%' ";
}
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@model", model);
pCMD.Parameters.AddWithValue("@chk", chk);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn readWorkPerformance(SqlConnection pCON, string start, string end, string product) //조회함수
{
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 SUJI g on (h.sj_id = g.sj_id)
left outer join JEPUM h on (b.jp_id = h.jp_id)
where a.work_date >= @start
and a.work_date <= @end
and b.jp_id like '%' + @product + '%' ";
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@start", start);
pCMD.Parameters.AddWithValue("@end", end);
pCMD.Parameters.AddWithValue("@product", product);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn delete_ec(SqlConnection pCON, string id)
{
commonReturn return2 = new commonReturn();
string str = "";
try
{
SqlCommand pCMD = new SqlCommand();
str = @"delete from EOPCHE_DAMDANG where ec_id = @ec_id;
delete from EOPCHE where ec_id=@ec_id; ";
pCMD.CommandText = str;
pCMD.Connection = pCON;
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@ec_id", id);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn read_all(SqlConnection pCON) //조회함수
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from BULRYANG_WONIN order by br_gbn, br_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 readResinRecordsForRef(SqlConnection pCON) //조회함수
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from SUJI where use_chk = 'Y' order by 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 findByDetail(SqlConnection pCON, string detail)
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from BULRYANG_WONIN where br_detail like '%' + @br_detail + '%' order by br_id";
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@br_detail", detail);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn findForRef(SqlConnection pCON, string grpName)
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from GONGTONG where gt_grp like '%' + @grpName + '%' and use_chk ='Y' ";
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@grpName", grpName);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn findByName(SqlConnection pCON, string name)
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from GEUNMU where gm_name like '%' + @gm_name + '%' order by gm_id";
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@gm_name", name);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}
public static commonReturn read_dd(SqlConnection pCON, string ec_id) //조회함수
{
commonReturn return2 = new commonReturn();
string str = "";
str = @"select * from EOPCHE_DAMDANG where ec_id = @ec_id order by dd_name";
try
{
SqlCommand pCMD = new SqlCommand
{
CommandText = str,
Connection = pCON
};
pCMD.Parameters.Clear();
pCMD.Parameters.AddWithValue("@ec_id", ec_id);
return2 = DBsql.SQLExecuteDS(pCON, pCMD);
}
catch (Exception exception)
{
return2.Message = exception.ToString();
}
return(return2);
}