public void login(string username, string userpass, string certpass, Action action) { Properties.Settings.Default.username = username; Properties.Settings.Default.userpass = userpass; Properties.Settings.Default.certpass = certpass; Properties.Settings.Default.Save(); SessionEvents session = new SessionEvents(() => { _queryCtrl = new QueryCtrl(); _queryCtrl.QueryInit(action); }); session.Login(username, userpass, certpass); }
private void SalesGrid(DataGridView dgv, string condition) { QueryCtrl qCtrl = new QueryCtrl(); DataTable dt = new DataTable(); dt = qCtrl.fn_SalesList(condition); //dt = qCtrl.fn_WorkList(" where 1=1 "); if (dt != null && dt.Rows.Count > 0) { dgv.RowCount = dt.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { dgv.Rows[i].Cells["SALES_DATE"].Value = dt.Rows[i]["SALES_DATE"].ToString(); dgv.Rows[i].Cells["SALES_CD"].Value = dt.Rows[i]["SALES_CD"].ToString(); //dgv.Rows[i].Cells["BALANCE"].Value = dt.Rows[i]["BALANCE"].ToString(); dgv.Rows[i].Cells["RS_TOTAL_MONEY"].Value = decimal.Parse(dt.Rows[i]["RS_TOTAL_MONEY"].ToString()).ToString("#,0.######"); dgv.Rows[i].Cells["SUPPLY_MONEY"].Value = decimal.Parse(dt.Rows[i]["ALL_SUPPLY_MONEY"].ToString()).ToString("#,0.######"); dgv.Rows[i].Cells["TAX_MONEY"].Value = decimal.Parse(dt.Rows[i]["ALL_TAX_MONEY"].ToString()).ToString("#,0.######"); dgv.Rows[i].Cells["CUST_CD"].Value = dt.Rows[i]["CUST_CD"].ToString(); dgv.Rows[i].Cells["CUST_NM"].Value = dt.Rows[i]["CUST_NM"].ToString(); dgv.Rows[i].Cells["ITEM_AMT"].Value = dt.Rows[i]["ITEM_AMT"].ToString(); dgv.Rows[i].Cells["OUT_DATE"].Value = dt.Rows[i]["JISI_DATE"].ToString(); dgv.Rows[i].Cells["OUT_CD"].Value = dt.Rows[i]["JISI_CD"].ToString(); dgv.Rows[i].Cells["VAT_CD"].Value = dt.Rows[i]["TAX_CD"].ToString(); dgv.Rows[i].Cells["BALANCE"].Value = dt.Rows[i]["BALANCE"].ToString(); //dgv.Rows[i].Cells["CUST_NM"].Value = dt.Rows[i]["CUST_NM"].ToString(); //(decimal.Parse(dt.Rows[i]["SOYO_AMT"].ToString())).ToString("#,0.######"); //workRsGrid.Rows[i].Cells["W_SEQ"].Value = dt.Rows[i]["SEQ"].ToString(); } } else { dgv.Rows.Clear(); } }
public Main() { _queryCtrl = new QueryCtrl(); _realCtrl = new RealCtrl(); }
private void SaleDetail(DataGridView dgv, int p) { QueryCtrl qCtrl = new QueryCtrl(); DataTable dt = new DataTable(); dt = qCtrl.fn_Sales_Detail_List("WHERE A.SALES_DATE = '" + dtp_sales_date.Text + "' AND A.SALES_CD ='" + txt_sales_cd.Text + "' "); //dt = qCtrl.fn_WorkList(" where 1=1 "); if (dt != null && dt.Rows.Count > 0) { dgv.RowCount = dt.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { // dgv.Rows[i].Cells["SALES_DATE"].Value = dt.Rows[i]["SALES_DATE"].ToString(); //dgv.Rows[i].Cells["SALES_CD"].Value = dt.Rows[i]["SALES_CD"].ToString(); //dgv.Rows[i].Cells["BALANCE"].Value = dt.Rows[i]["BALANCE"].ToString(); dgv.Rows[i].Cells[0].Value = dt.Rows[i]["SEQ"].ToString(); dgv.Rows[i].Cells["ITEM_CD"].Value = dt.Rows[i]["PRODUCT_CD"].ToString(); dgv.Rows[i].Cells["ITEM_NM"].Value = dt.Rows[i]["PRODUCT_NM"].ToString(); dgv.Rows[i].Cells["CHUGJONG_NM"].Value = dt.Rows[i]["CHUGJONG_NM"].ToString(); dgv.Rows[i].Cells["CLASS_NM"].Value = dt.Rows[i]["CLASS_NM"].ToString(); dgv.Rows[i].Cells["TYPE_NM"].Value = dt.Rows[i]["TYPE_NM"].ToString(); dgv.Rows[i].Cells["COUNTRY_NM"].Value = dt.Rows[i]["COUNTRY_NM"].ToString(); dgv.Rows[i].Cells["LABEL_NM"].Value = dt.Rows[i]["LABEL_NM"].ToString(); dgv.Rows[i].Cells["UNION_CD"].Value = dt.Rows[i]["UNION_CD"].ToString(); dgv.Rows[i].Cells["PAC_AMT"].Value = ""; dgv.Rows[i].Cells["COMMENT"].Value = ""; dgv.Rows[i].Cells["SPEC"].Value = dt.Rows[i]["SPEC"].ToString(); if (dt.Rows[i]["STORE_GUBUN"].ToString().Equals("STORE_1F")) { dgv.Rows[i].Cells["STORE_GUBUN"].Value = "냉동"; } else if (dt.Rows[i]["STORE_GUBUN"].ToString().Equals("STORE_1NF")) { dgv.Rows[i].Cells["STORE_GUBUN"].Value = "냉장"; } else if (dt.Rows[i]["STORE_GUBUN"].ToString().Equals("STORE_UF")) { dgv.Rows[i].Cells["STORE_GUBUN"].Value = "해동"; } else if (dt.Rows[i]["STORE_GUBUN"].ToString().Equals("REMAIN_AMT")) { dgv.Rows[i].Cells["STORE_GUBUN"].Value = "대기"; } else { dgv.Rows[i].Cells["STORE_GUBUN"].Value = "제품"; } //dgv.Rows[i].Cells["SPEC"].Value = dt.Rows[i]["SPEC"].ToString(); dgv.Rows[i].Cells["TOTAL_AMT"].Value = decimal.Parse(dt.Rows[i]["TOTAL_AMT"].ToString()).ToString("#,0.######"); dgv.Rows[i].Cells["PRICE"].Value = decimal.Parse(dt.Rows[i]["TOTAL_PRICE"].ToString()).ToString("#,0.######"); dgv.Rows[i].Cells["UNIT_NM"].Value = dt.Rows[i]["UNIT_NM"].ToString(); dgv.Rows[i].Cells["TOTAL_MONEY"].Value = (decimal.Parse(dt.Rows[i]["TOTAL_AMT"].ToString()) * decimal.Parse(dt.Rows[i]["TOTAL_PRICE"].ToString())).ToString("#,0.######"); //dgv.Rows[i].Cells["SALES_GUBUN"].Value = dt.Rows[i]["SALES_GUBUN_NM"].ToString(); //dgv.Rows[i].Cells["CUST_NM"].Value = dt.Rows[i]["CUST_NM"].ToString(); //(decimal.Parse(dt.Rows[i]["SOYO_AMT"].ToString())).ToString("#,0.######"); //workRsGrid.Rows[i].Cells["W_SEQ"].Value = dt.Rows[i]["SEQ"].ToString(); } } else { dgv.Rows.Clear(); } }