private int makeSEQ()
{
Cnpgsql qry = new Cnpgsql();
NpgsqlCommand qryCommand = new NpgsqlCommand();
string sql = $" select to_char(count(*) +1, 'FM0000000000') cnt" +
$" from prj01m00";
qryCommand.CommandText = sql;
qry.SetSelect(qryCommand);
try
{
DataTable dt = qry.Select();
m_Seq = dt.Rows[0]["cnt"].ToString();
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
return(-1);
}
return(0);
}
public static void DeletePLH(CProjectInfo ProjectInfo)
{
Cnpgsql delete = new Cnpgsql();
NpgsqlCommand[] deleteCommands = new NpgsqlCommand[2];
NpgsqlCommand deleteCommander = new NpgsqlCommand();
string sql;
sql = $"delete from plh01t00 " +
$" where project_cd = :p_project_cd ";
deleteCommander.CommandText = sql;
deleteCommander.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
deleteCommands[0] = deleteCommander;
//////////////////////////////////////
NpgsqlCommand deleteCommander2 = new NpgsqlCommand();
sql = "";
sql = $"delete from plh01m00 " +
$" where project_cd = :p_project_cd ";
deleteCommander2.CommandText = sql;
deleteCommander2.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
deleteCommands[1] = deleteCommander2;
delete.delete(deleteCommands);
}
/// <summary>
/// 발주처 담당자 정보를 조회한다.
/// </summary>
public void QueryClientIDInfo()
{
Cnpgsql Qry = new Cnpgsql();
NpgsqlCommand QryCommander = new NpgsqlCommand();
string sql = $" select client_id" +
$" , client_id_nm" +
$" from client01t00" +
$" where client_cd like '%'|| :p_client_cd ||'%'";
QryCommander.CommandText = sql;
QryCommander.Parameters.AddWithValue("p_client_cd", lookupClient.GetColumnValue("client_cd").ToString());
Qry.SetSelect(QryCommander);
try
{
DataTable dt = Qry.Select();
lookupClientID.Properties.DataSource = dt;
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
return;
}
/*
*
* CHeader Header = new CHeader(UserInfo.UserID, "A0201A", "XtraNewProject", "00000", "");
*
* DataTable data = new DataTable("clientInfo");
*
* DataColumn colClientCd = new DataColumn("client_cd", typeof(string));
*
* data.Columns.Add(colClientCd);
*
*
*
*
* DataRow Dr = data.NewRow();
* Dr["client_cd"] = lookupClient.GetColumnValue("client_cd");
*
* data.Rows.Add(Dr);
*
* CParam Param = new CParam(data);
*
* DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
*
* DataTable Dt = ds.Tables["eror_dt"];
* itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
* itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
*
* DataTable Data = ds.Tables["Table"];
* lookupClientID.Properties.DataSource = Data;
*
*/
}
public void QueryClientInfo()
{
Cnpgsql Qry = new Cnpgsql();
NpgsqlCommand QryCommander = new NpgsqlCommand();
string sql = $" select client_cd" +
$" , client_nm" +
$" from client01m00";
QryCommander.CommandText = sql;
Qry.SetSelect(QryCommander);
try
{
DataTable dt = Qry.Select();
lookupClient.Properties.DataSource = dt;
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
return;
}
/*
*
* // 로그인 정보를 처리한다.
* CHeader Header = new CHeader(UserInfo.UserID, "A0200A", "XtraNewProject", "00000", "");
*
*
* CParam Param = new CParam();
*
*
* //refHighTops.HighTopsSoapClient aaa = new refHighTops.HighTopsSoapClient();
* DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
*
* DataTable Dt = ds.Tables["eror_dt"];
* itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
* itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
*
* DataTable Data = ds.Tables["Table"];
* lookupClient.Properties.DataSource = Data;
*
*
*/
}
private int InsertData()
{
Cnpgsql qry = new Cnpgsql();
NpgsqlCommand qryCommander = new NpgsqlCommand();
string sql;
sql = $" insert into prj01m00 " +
$" select :p_seq , " +
$" :p_project_nm , " +
$" :p_start_dt , " +
$" :p_end_dt , " +
$" :p_client_cd , " +
$" :p_client_id ";
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("project_nm", edtProjectNm.Text);
qryCommander.Parameters.AddWithValue("start_dt", dateStart.Text.Replace("-", ""));
qryCommander.Parameters.AddWithValue("end_dt", dateEnd.Text.Replace("-", ""));
qryCommander.Parameters.AddWithValue("client_cd", lookupClient.GetColumnValue("client_cd"));
qryCommander.Parameters.AddWithValue("client_id", lookupClientID.GetColumnValue("client_id"));
qry.SetInsert(qryCommander);
try
{
int nRet = qry.Insert();
if (nRet < 0)
{
return(-1);
}
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
return(-1);
}
return(0);
}
private int chkData()
{
Cnpgsql Qry = new Cnpgsql();
NpgsqlCommand cmd_select = new NpgsqlCommand();
string sql = $" select count(*) cnt" +
$" from prj01m00" +
$" where trim(project_nm) = trim(:p_project_nm)";
cmd_select.CommandText = sql;
cmd_select.Parameters.AddWithValue("p_project_nm", edtProjectNm.Text);
Qry.SetSelect(cmd_select);
try
{
DataTable dt = Qry.Select();
if (Convert.ToInt32(dt.Rows[0]["cnt"].ToString()) != 0)
{
itemErrMsg.Caption = "동일한 프로젝트명이 존재합니다.";
return(-1);
}
else
{
}
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
throw;
}
return(0);
}
/// <summary>
/// 프로젝트 리스트를 조회한다.
/// </summary>
private void QryFileList()
{
Cnpgsql Qry = new Cnpgsql();
string sql = $" select file_name" +
$" , description" +
$" , work_date" +
$" , work_user" +
$" , file" +
$" , 'DWONLOAD' " +
$" from file01m00" +
$" where file_name like '%' || :p_file_name || '%' ";
NpgsqlCommand QryCommander = new NpgsqlCommand();
QryCommander.CommandText = sql;
QryCommander.Parameters.AddWithValue("p_file_name", edtFileNm.Text);
Qry.SetSelect(QryCommander);
try
{
DataTable dt = Qry.Select();
gridControl1.DataSource = dt;
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
}
/*
*
* CHeader Header = new CHeader(UserInfo.UserID, "A0002A", "XtraPLHFile", "00000", "");
*
*
* dsFile.Tables["tbl_file"].Clear();
*
* DataRow Dr = dsFile.Tables["tbl_file"].NewRow();
* Dr["file_name"] = edtFileNm.Text;
*
*
* dsFile.Tables["tbl_file"].Rows.Add(Dr);
*
* CParam Param = new CParam(dsFile.Tables["tbl_file"]);
*
* DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
*
* DataTable Dt = ds.Tables["eror_dt"];
* itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
* itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
*
* if (SetStatus(ds) == true)
* {
* DataTable Data = ds.Tables["Table"];
* gridControl1.DataSource = Data;
* }
*
*
*
*/
}
/// <summary>
/// 사용자 정보를 조회한다.
/// </summary>
/// <param name="strUserId"></param>
/// <returns></returns>
public int QyrUserInfo(string strUserId)
{
Cnpgsql npgsql = new Cnpgsql();
NpgsqlCommand qryCommander = new NpgsqlCommand();
string sql = $" select user_id" +
$" , user_nm" +
$" from usr01m00" +
$" where user_id = :p_user_id ";
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("p_user_id", strUserId);
try
{
DataTable dt = npgsql.Select(qryCommander);
itemUserId.Caption = dt.Rows[0]["user_id"].ToString();
UserInfo.UserID = dt.Rows[0]["user_id"].ToString();
UserInfo.UserName = dt.Rows[0]["user_nm"].ToString();
return(0);
}
catch (Exception e)
{
return(-1);
//throw e;
}
//CHeader Header = new CHeader("test", "A0001B", "MAIN", "00000", "");
//DataTable data = new DataTable("custinfo");
//DataColumn colUserId = new DataColumn("user_id", typeof(string));
//data.Columns.Add(colUserId);
//DataRow Dr = data.NewRow();
//Dr["user_id"] = strUserId;
//data.Rows.Add(Dr);
//CParam Param = new CParam(data);
//DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
//DataTable Dt = ds.Tables["eror_dt"];
//itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
//itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
//if (Dt.Rows[0]["err_cd"].ToString().PadRight(5, ' ') != "00000")
//{
// return -1;
//}
//itemUserId.Caption = ds.Tables["Table"].Rows[0]["user_id"].ToString();
////사용자 정보를 설정한다.
//UserInfo.UserID = ds.Tables["Table"].Rows[0]["user_id"].ToString();
//UserInfo.UserName = ds.Tables["Table"].Rows[0]["user_nm"].ToString();
//return 0;
}
private int QryData()
{
string sql = $" select user_id" +
$" , user_nm" +
$" from usr01m00" +
$" where user_id = :p_user_id " +
$" and pswd = :p_pswd ";
SqlUserCheck.CommandText = sql;
Cnpgsql npgsql = new Cnpgsql();
SqlUserCheck.Parameters.AddWithValue("p_user_id", edtUserId.Text);
SqlUserCheck.Parameters.AddWithValue("p_pswd", edtPswd.Text);
npgsql.SetSelect(SqlUserCheck);
DataTable dt = npgsql.Select();
if (dt is null)
{
return(-1);
}
return(0);
/*
*
*
* // 로그인 정보를 처리한다.
* CHeader Header = new CHeader("test", "A0001A", "LOGIN", "00000", "");
*
*
* DataTable data = new DataTable("LoginInfo");
*
* DataColumn colUserId = new DataColumn("user_id", typeof(string));
* DataColumn colPswd = new DataColumn("pswd", typeof(string));
*
* data.Columns.Add(colUserId);
* data.Columns.Add(colPswd);
*
*
* DataRow Dr = data.NewRow();
* Dr["user_id"] = edtUserId.Text;
* Dr["pswd"] = edtPswd.Text;
*
* data.Rows.Add(Dr);
*
* CParam Param = new CParam(data);
*
* //wcfHighTop.HighTopsSoapClient aaa = new refHighTops.HighTopsSoapClient();
* DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
*
*
* DataTable Dt = ds.Tables["eror_dt"];
* itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
* itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
*
* if (Dt.Rows[0]["err_cd"].ToString().PadRight(5, ' ') != "00000")
* {
* return -1;
* }
*
* return 0;
*
*/
}
/// <summary>
/// 서버에서 PLH 정보를 LOAD 한다.
/// </summary>
public void QryPLH()
{
Cnpgsql Qry = new Cnpgsql();
NpgsqlCommand qryCommand = new NpgsqlCommand();
string sql;
sql = $" select a.* " +
$" ,get_pavement('1', project_cd, key, order_seq, filename) pavement_stat " +
$" ,get_pavement('2', project_cd, key, order_seq, filename) pavement_stat_nm " +
$" , 'false' as check " +
$" from plh01m00 a " +
$" where project_cd = :p_project_cd " +
$" order by a.order_seq; ";
qryCommand.CommandText = sql;
qryCommand.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
Qry.SetSelect(qryCommand);
try
{
DataTable dt = Qry.Select();
gridControl1.DataSource = dt;
}
catch (Exception ex)
{
itemErrMsg.Caption = ex.Message;
//throw;
}
/*
*
* CHeader Header = new CHeader(UserInfo.UserID, "A1002A", "XtraPLH", "00000", "");
*
*
*
* DataTable Data = new DataTable("PlhInfo");
* DataColumn colProjectCd = new DataColumn("project_cd", typeof(string));
*
*
* Data.Columns.Add(colProjectCd);
*
*
*
* DataRow Dr = Data.NewRow();
* Dr["project_cd"] = ProjectInfo.ProjectCD;
*
* Data.Rows.Add(Dr);
*
* //Project 정보를 담은 ...
* CParam Param = new CParam(Data);
*
*
* using (DataSet ds = CTransfer.QryData(Header, Param.GetDataSet()))
* {
*
* DataTable Dt = ds.Tables["eror_dt"];
* itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
* itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
*
* DataTable rcvData = ds.Tables["Table"];
* gridControl1.DataSource = rcvData;
*
* }
*
*/
}
public static void SavePLH(CProjectInfo ProjectInfo, DataTable dt)
{
Cnpgsql qry = new Cnpgsql();
NpgsqlCommand[] qryCommanders = new NpgsqlCommand[dt.Rows.Count];
int i = 0;
foreach (DataRow item in dt.Rows)
{
NpgsqlCommand qryCommander = new NpgsqlCommand();
string sql;
sql = $"insert into plh01t00 " +
$" select :p_project_cd " +
$" , :p_file_name " +
$" , :p_line_name " +
$" , :p_p_node " +
$" , :p_c_node ";
if (i == 0)
{
//노드 구성을 해보자
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
qryCommander.Parameters.AddWithValue("p_file_name", item["FileName"]);
qryCommander.Parameters.AddWithValue("p_line_name", item["linename"]);
qryCommander.Parameters.AddWithValue("p_p_node", 0);
qryCommander.Parameters.AddWithValue("p_c_node", Convert.ToInt16(item["key"].ToString()));
}
else
{
if (dt.Rows[i - 1]["linename"].ToString() == item["linename"].ToString())
{
//노드 구성을 해보자
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
qryCommander.Parameters.AddWithValue("p_file_name", item["FileName"]);
qryCommander.Parameters.AddWithValue("p_line_name", item["linename"]);
qryCommander.Parameters.AddWithValue("p_p_node", Convert.ToInt16(dt.Rows[i - 1]["key"].ToString()));
qryCommander.Parameters.AddWithValue("p_c_node", Convert.ToInt16(item["key"].ToString()));
}
else
{
string sss = item["linename"].ToString();
string aaa = dt.Rows[i - 1]["linename"].ToString();
//노드 구성을 해보자
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
qryCommander.Parameters.AddWithValue("p_file_name", item["FileName"]);
qryCommander.Parameters.AddWithValue("p_line_name", item["linename"]);
qryCommander.Parameters.AddWithValue("p_p_node", 0);
qryCommander.Parameters.AddWithValue("p_c_node", Convert.ToInt16(item["key"].ToString()));
}
}
sql = "";
sql = $"insert into plh01m00 " +
$" select :p_project_cd " +
$" , :p_key " +
$" , :p_order_seq" +
$" , :p_filename " +
$" , :p_linenumber " +
$" , :p_extention " +
$" , :p_dist" +
$" , :p_dist2" +
$" , :p_gh" +
$" , :p_inv" +
$" , :p_linename" +
$" , :p_dia" +
$" , :p_br" +
$" , :p_type" +
$" , :p_t1" +
$" , :p_slope" +
$" , :p_bcut" +
$" , :p_hcut" +
$" , :p_manwork" +
$" , :p_sand" +
$" , :p_baseangle" +
$" , :p_conca" +
$" , :p_concb" +
$" , :p_humanity" +
$" , :p_concrete" +
$" , :p_asphalt1" +
$" , :p_asphalt2" +
$" , :p_complay" +
$" , :p_mixlay" +
$" , :p_mixlay1" +
$" , :p_mixlay2" +
$" , :p_area1" +
$" , :p_area2" +
$" , :p_area3" +
$" , :p_area4" +
$" , :p_area5" +
$" , :p_area6" +
$" , :p_area7" +
$" , :p_area8" +
$" , :p_area9" +
$" , :p_area10" +
$" , :p_area11" +
$" , :p_t2" +
$" , :p_t3" +
$" , :p_t4" +
$" , :p_b" +
$" , :p_h" +
$" , :p_dir " +
$" , :p_pavement_stat";
qryCommander.CommandText = sql;
qryCommander.Parameters.AddWithValue("p_project_cd", ProjectInfo.ProjectCD);
qryCommander.Parameters.AddWithValue("p_key", item["key"].ToString());
qryCommander.Parameters.AddWithValue("p_order_seq", item["order_seq"].ToString());
qryCommander.Parameters.AddWithValue("p_filename", item["FileName"].ToString()); //string
qryCommander.Parameters.AddWithValue("p_linenumber", item["linenumber"].ToString()); //string
qryCommander.Parameters.AddWithValue("p_extention", item["extention"].ToString()); //plus
qryCommander.Parameters.AddWithValue("p_dist", item["dist"].ToString());
qryCommander.Parameters.AddWithValue("p_dist2", item["dist2"].ToString());
qryCommander.Parameters.AddWithValue("p_gh", item["gh"].ToString());
qryCommander.Parameters.AddWithValue("p_inv", item["inv"].ToString());
qryCommander.Parameters.AddWithValue("p_linename", item["linename"].ToString()); //string
qryCommander.Parameters.AddWithValue("p_dia", item["dia"].ToString());
qryCommander.Parameters.AddWithValue("p_br", item["br"].ToString());
qryCommander.Parameters.AddWithValue("p_type", item["type"].ToString());
qryCommander.Parameters.AddWithValue("p_t1", item["t1"].ToString());
qryCommander.Parameters.AddWithValue("p_slope", item["slope"].ToString());
qryCommander.Parameters.AddWithValue("p_bcut", item["bcut"].ToString());
qryCommander.Parameters.AddWithValue("p_hcut", item["hcut"].ToString());
qryCommander.Parameters.AddWithValue("p_manwork", item["manwork"].ToString());
qryCommander.Parameters.AddWithValue("p_sand", item["sand"].ToString());
qryCommander.Parameters.AddWithValue("p_baseangle", item["baseangle"].ToString());
qryCommander.Parameters.AddWithValue("p_conca", item["conca"].ToString());
qryCommander.Parameters.AddWithValue("p_concb", item["concb"].ToString());
qryCommander.Parameters.AddWithValue("p_humanity", item["humanity"].ToString());
qryCommander.Parameters.AddWithValue("p_concrete", item["concrete"].ToString());
qryCommander.Parameters.AddWithValue("p_asphalt1", item["asphalt1"].ToString());
qryCommander.Parameters.AddWithValue("p_asphalt2", item["asphalt2"].ToString());
qryCommander.Parameters.AddWithValue("p_complay", item["complay"].ToString());
qryCommander.Parameters.AddWithValue("p_mixlay", item["mixlay"].ToString());
qryCommander.Parameters.AddWithValue("p_mixlay1", item["mixlay1"].ToString());
qryCommander.Parameters.AddWithValue("p_mixlay2", item["mixlay2"].ToString());
qryCommander.Parameters.AddWithValue("p_area1", item["area1"].ToString());
qryCommander.Parameters.AddWithValue("p_area2", item["area2"].ToString());
qryCommander.Parameters.AddWithValue("p_area3", item["area3"].ToString());
qryCommander.Parameters.AddWithValue("p_area4", item["area4"].ToString());
qryCommander.Parameters.AddWithValue("p_area5", item["area5"].ToString());
qryCommander.Parameters.AddWithValue("p_area6", item["area6"].ToString());
qryCommander.Parameters.AddWithValue("p_area7", item["area7"].ToString());
qryCommander.Parameters.AddWithValue("p_area8", item["area8"].ToString());
qryCommander.Parameters.AddWithValue("p_area9", item["area9"].ToString());
qryCommander.Parameters.AddWithValue("p_area10", item["area10"].ToString());
qryCommander.Parameters.AddWithValue("p_area11", item["area11"].ToString());
qryCommander.Parameters.AddWithValue("p_t2", item["t2"].ToString());
qryCommander.Parameters.AddWithValue("p_t3", item["t3"].ToString());
qryCommander.Parameters.AddWithValue("p_t4", item["t4"].ToString());
qryCommander.Parameters.AddWithValue("p_b", item["b"].ToString());
qryCommander.Parameters.AddWithValue("p_h", item["h"].ToString());
qryCommander.Parameters.AddWithValue("p_dir", item["dir"].ToString());
qryCommanders[i] = qryCommander;
i++;
}
qry.insert(qryCommanders);
}
