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();
}
}
