private void Open1()
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP19_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_gshow_id", MySqlDbType.Int32);
cmd.Parameters[0].Value = Convert.ToInt32(txtGShop_ID.EditValue);
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl3.DataBind(ds);
this.efwGridControl3.MyGridView.BestFitColumns();
}
Cursor.Current = Cursors.Default;
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
void CreateNode2(BizNode OrNode)
{
if (OrNode == null)
{
return;
}
try
{
_dsDeptInfo2 = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_MM_MM02_SELECT_02", txtCOMPANYCD.EditValue, "2");
DataRow[] drs2 = _dsDeptInfo2.Tables[0].Select("LEVEL=0 AND BIZCD = '" + OrNode.BIZCD + "'", " RNKORDER ASC");
for (int i = 0; i < drs2.Length; i++)
{
DeptNode OrNode2 = new DeptNode(drs2[i]);
OrNode.Nodes.Add(OrNode2);
CreateNode3(OrNode2, _dsDeptInfo2);
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
public override void Search()
{
try
{
//using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_MM_MM15_SELECT_01", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_name", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = "";
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
// this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
// 평균단가 산정 이월처리
private void efwSimpleButton11_Click(object sender, EventArgs e)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.TelConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("erp.USP_TM_TM08_SAVE_07", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_YearMonth", MySqlDbType.VarChar, 6);
cmd.Parameters[0].Value = dtYear_Month.EditValue3.Substring(0, 6);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
MessageAgent.MessageShow(MessageType.Informational, "이월처리가 완료 되었습니다.");
}
private void popup_FormClosed(object sender, FormClosedEventArgs e)
{
popup_member.FormClosed -= popup_FormClosed;
if (popup_member.DialogResult == DialogResult.OK)
{
this.txtgshop_id.EditValue = popup_member.GSHOP_ID;
int nCount;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select count(*) as nCount FROM domabiz.tb_poto_best_gshop where gshop_id = '" + txtgshop_id.EditValue + "' ";
DataSet ds = sql.selectQueryDataSet();
nCount = Convert.ToInt32(sql.selectQueryForSingleValue());
}
if (nCount == 1)
{
MessageAgent.MessageShow(MessageType.Warning, " 선정 이력이 존재합니다 목록에서 선택하여 수정 하세요~ ");
this.txtSearch_Name.EditValue = popup_member.GSHHOP_NAME;
Search();
}
this.txtgshop_name.EditValue = popup_member.GSHHOP_NAME;
this.txtTelNo.EditValue = popup_member.U_CELL_NUM;
this.txtAddr.EditValue = popup_member.U_ADDR;
}
popup_member = null;
}
private void setCmb()
{
try
{
// Dictionary<string, string> myRecord;
string strQueruy = @" SELECT
T1.DCODE, T1.DNAME
FROM
(
SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT CODE DCODE
,CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'MEMBER' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbO_TYPE, strQueruy);
cmbO_TYPE.EditValue = "";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
// 출고
private void Open3()
{
try
{
string sCOMFIRM = string.Empty;
//using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.TelConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("erp.USP_TM_TM08_SELECT_03", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_sdate", MySqlDbType.VarChar, 8);
cmd.Parameters[0].Value = dtS_DATE.EditValue3.Substring(0, 8);
cmd.Parameters.Add("i_edate", MySqlDbType.VarChar, 8);
cmd.Parameters[1].Value = dtE_DATE.EditValue3.Substring(0, 8);
cmd.Parameters.Add("i_Search", MySqlDbType.VarChar, 50);
cmd.Parameters[2].Value = txtSearch.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl3.DataBind(ds);
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void efwSimpleButton7_Click(object sender, EventArgs e)
{
if (txtIs_Write.EditValue.ToString() == "Y")
{
MessageAgent.MessageShow(MessageType.Warning, " 작성된 스토리는 삭제할수 없습니다");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "스토리를 삭제하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GM_GM13_POP01_DELETE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_Idx", MySqlDbType.Int32));
cmd.Parameters["i_Idx"].Value = Convert.ToInt32(txtIdx.EditValue);
cmd.Parameters["i_Idx"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
MessageAgent.MessageShow(MessageType.Informational, "완료 되었습니다. 조회 결과를 확인하세요.");
Open1();
}
}
private void efwSimpleButton9_Click(object sender, EventArgs e)
{
if (txtStory_243.EditValue.ToString() == "O")
{
MessageAgent.MessageShow(MessageType.Warning, " 이미 생성된 스토리 입니다");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "PR추천 스토리를 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_PROD_ORDER_243", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_o_code", MySqlDbType.VarChar));
cmd.Parameters["i_o_code"].Value = txtGShop_O_Code.EditValue;
cmd.Parameters["i_o_code"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
MessageAgent.MessageShow(MessageType.Informational, "완료 되었습니다. 조회 결과를 확인하세요.");
Open1();
}
}
public void Open3()
{
try
{
string sCOMFIRM = string.Empty;
string sCom = string.Empty;
//using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GM_GM08_SELECT_03", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_search", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = "";
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl3.DataBind(ds);
// this.efwGridControl2.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open1()
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GM_GM13_POP01_SELECT_01", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_o_code", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = txtO_Code.EditValue;
cmd.Parameters.Add("i_gshop_code", MySqlDbType.VarChar, 50);
cmd.Parameters[1].Value = txtGShop_O_Code.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open1()
{
try
{
//base.Search();
string sSDate = string.Empty;
string sEDate = string.Empty;
sSDate = txtSDate.EditValue + "-01";
sEDate = txtEDate.EditValue + "-31";
DataSet ds = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_MA03_SELECT_04"
, sSDate
, sEDate
, rbType.EditValue
);
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open2()
{
try
{
string sCOMFIRM = string.Empty;
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
//using (MySqlConnection con = new MySqlConnection(ConstantLib.TelConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DT_DT03_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_ProdName", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = txtQuery.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open1()
{
try
{
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP01_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_qname", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = txtQ_NAME.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl2.DataBind(ds);
this.efwGridControl2.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void repositoryItemButtonEdit1_Click(object sender, EventArgs e)
{
if (rbq_type.EditValue.ToString() == "0")
{
popup = new frmGM13_Pop01();
popup.pO_Code = bandedGridView1.GetFocusedRowCellValue("o_code").ToString();
popup.pShop_Code = bandedGridView1.GetFocusedRowCellValue("shop_order").ToString();
popup.pStory_208 = bandedGridView1.GetFocusedRowCellValue("ps_story1").ToString();
popup.pStory_221 = bandedGridView1.GetFocusedRowCellValue("ps_story2").ToString();
popup.pStory_248 = bandedGridView1.GetFocusedRowCellValue("gd_story").ToString();
popup.pStory_232 = bandedGridView1.GetFocusedRowCellValue("tel_story").ToString();
popup.pStory_247 = bandedGridView1.GetFocusedRowCellValue("gv_story").ToString();
popup.pStory_244 = bandedGridView1.GetFocusedRowCellValue("gm_story").ToString();
popup.pStory_223 = bandedGridView1.GetFocusedRowCellValue("pr_story1").ToString();
popup.pStory_243 = bandedGridView1.GetFocusedRowCellValue("pr_story2").ToString();
popup.pU_NickNAme = bandedGridView1.GetFocusedRowCellValue("u_nickname").ToString();
popup.pU_Chef_Level = bandedGridView1.GetFocusedRowCellValue("u_chef_level").ToString();
popup.pDoma = bandedGridView1.GetFocusedRowCellValue("doma").ToString();
popup.pVip = bandedGridView1.GetFocusedRowCellValue("vip").ToString();
popup.pBiz = bandedGridView1.GetFocusedRowCellValue("biz").ToString();
popup.FormClosed += popup_FormClosed;
popup.ShowDialog();
}
else
{
MessageAgent.MessageShow(MessageType.Informational, "생성유무로 조회 하신후 스토리를 생성하세요!.");
}
}
private void memberDel1(string pid, string pu_id)
{
//[y2k2].[dbo].[Y2K2_member] 업데이트 (아이디 도용 문제가 있을수 있으므로 삭제가 아닌 업데이트처리)
try
{
Cursor.Current = Cursors.WaitCursor;
int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_TM_TM01_SAVE_01", pid, pu_id);
if (retVal > 0)
{
MessageAgent.MessageShow(MessageType.Informational, "처리 되었습니다.");
Cursor.Current = Cursors.Default;
}
}
catch (Exception ex)
{
//MessageAgent.MessageShow(MessageType.Error, ex.ToString());
Cursor.Current = Cursors.Default;
}
finally
{
MessageAgent.MessageShow(MessageType.Informational, "처리 되었습니다. 다시 조회 하세요.");
Cursor.Current = Cursors.Default;
}
}
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
if (MessageAgent.MessageShow(MessageType.Confirm, "PS축하 스토리를 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_PROD_ORDER_221", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_o_code", MySqlDbType.VarChar));
cmd.Parameters["i_o_code"].Value = txtPS_O_Code.EditValue;
cmd.Parameters["i_o_code"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
Open5();
}
}
private void efwSimpleButton6_Click(object sender, EventArgs e)
{
try
{
if (txtStory_ID.EditValue.ToString() == "" ^ txtStory_ID.EditValue.ToString() == null)
{
MessageAgent.MessageShow(MessageType.Warning, "변경할 발모후기를 선택하세요!");
return;
}
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP15_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_story_id", MySqlDbType.Int32);
cmd.Parameters[0].Value = Convert.ToInt32(txtStory_ID.EditValue.ToString());
cmd.Parameters.Add("i_informant", MySqlDbType.VarChar, 50);
cmd.Parameters[1].Value = txtInformant.EditValue;
cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
Search();
}
private void AutoOpen()
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DN_DN26_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void EfwSimpleButton5_Click(object sender, EventArgs e)
{
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
MySqlConnection connection = new MySqlConnection(ConstantLib.BasicConn_Dev);
connection.Open();
MySqlCommand updateCommand = new MySqlCommand();
updateCommand.Connection = connection;
updateCommand.CommandText = "UPDATE domalife.member_master_20170530 SET u_name=@u_name WHERE idx=@idx";
updateCommand.Parameters.Add("@u_name", MySqlDbType.VarChar, 50);
updateCommand.Parameters[0].Value = txtU_NAME.EditValue;
updateCommand.Parameters.Add("@idx", MySqlDbType.Int32, 11);
updateCommand.Parameters[1].Value = Convert.ToInt32(txtIDX.EditValue);
updateCommand.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
finally
{
EfwSimpleButton1_Click(null, null);
}
}
}
// 현행화 출고
private void Open4()
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.TelConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("erp.USP_TM_TM08_SELECT_08", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_sdate", MySqlDbType.VarChar, 8);
cmd.Parameters[0].Value = dtS_DATE.EditValue3;
cmd.Parameters.Add("i_edate", MySqlDbType.VarChar, 8);
cmd.Parameters[1].Value = dtE_DATE.EditValue3;
cmd.Parameters.Add("i_cust_name", MySqlDbType.VarChar, 50);
cmd.Parameters[2].Value = txtSearch.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl4.DataBind(ds);
this.efwGridControl4.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void EfwSimpleButton1_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
String sql = "SELECT idx, u_name FROM domalife.member_master_20170530 " +
"ORDER BY u_name";
MySqlDataAdapter adpt = new MySqlDataAdapter(sql, sconn);
adpt.Fill(ds, "members");
if (ds.Tables.Count > 0)
{
//foreach (DataRow r in ds.Tables[0].Rows)
//{
// Console.WriteLine(r["name"]);
//}
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
public override void Search()
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GM_GM11_SELECT_01", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_sdate", MySqlDbType.VarChar, 8);
cmd.Parameters[0].Value = dtS_DATE.EditValue3.Substring(0, 8);
cmd.Parameters.Add("i_edate", MySqlDbType.VarChar, 8);
cmd.Parameters[1].Value = dtE_DATE.EditValue3.Substring(0, 8);
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open4()
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_TM_TM14_SELECT_06", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_sdate", MySqlDbType.VarChar, 6);
cmd.Parameters[0].Value = dtYear.EditValue3.Substring(0, 4);
cmd.Parameters.Add("i_unit", MySqlDbType.VarChar, 10);
cmd.Parameters[1].Value = rbUnit.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl5.DataBind(ds);
this.efwGridControl5.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void Open1()
{
try
{
string sCOMFIRM = string.Empty;
//using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM_RM03_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_master_idx", MySqlDbType.Int32);
cmd.Parameters[0].Value = txtidx.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl2.DataBind(ds);
// this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_TM_TM14_SELECT_02", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_search", MySqlDbType.VarChar, 50);
cmd.Parameters[0].Value = txtAcc_NameQ.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl2.DataBind(ds);
this.efwGridControl2.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (this.treeView1.SelectedNode is DeptNode)
{
DeptNode oNode = (DeptNode)this.treeView1.SelectedNode;
cmbBIZCD.EditValue = oNode.BIZCD;
txtDEPTCODE.EditValue = oNode.DEPTCODE;
txtDEPTNAME.EditValue = oNode.DEPTNAME;
txtDEPTABBR.EditValue = oNode.DEPTABBR;
txtSTARTYM.EditValue = oNode.STARTYM;
txtENDYM.EditValue = oNode.ENDYM;
chkUSEYN.EditValue = oNode.USEYN;
txtRNKORDER.EditValue = oNode.RNKORDER;
txtLEVEL.EditValue = oNode.LEVEL;
txtREFCODE.EditValue = oNode.REFCODE;
txtMEMO.EditValue = oNode.MEMO;
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
finally
{
this.Cursor = Cursors.Default;
}
}
public void Open1()
{
try
{
string sCOMFIRM = string.Empty;
string sCom = string.Empty;
//using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("erp.USP_TM_TM13_SELECT_01", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_year_month", MySqlDbType.VarChar, 6);
cmd.Parameters[0].Value = dtYearMonth.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
void gridView3_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
try
{
DataRow dr = (e.Row as DataRowView).Row;
string url = dr["ImageURL"].ToString();
if (iconsCache.ContainsKey(url))
{
e.Value = iconsCache[url];
return;
}
var request = WebRequest.Create(url);
using (var response = request.GetResponse())
{
using (var stream = response.GetResponseStream())
{
e.Value = Bitmap.FromStream(stream);
iconsCache.Add(url, (Bitmap)e.Value);
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void SetCmb()
{
try
{
Dictionary <string, string> myRecord;
string strQueruy1 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'MALL_TYPE' and Use_YN = 'Y' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbMALL_TYPE, strQueruy1);
cmbMALL_TYPE.EditValue = "";
string strQueruy2 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'ORDER_SEARCH' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbORDER_SEARCH, strQueruy2);
cmbORDER_SEARCH.EditValue = "1";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}