public void CLEAR() { if (detailsSlip != null) { detailsSlip.Hide(); } int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); preAction = string.Empty; txt_DocId.Text = string.Empty; txt_StartDate.Value = DateTime.Today; txt_PurchaseAmt.Text = string.Empty; txt_InvoiceNo.Text = string.Empty; }
public void CLEAR() { if (detailsSlip != null) { detailsSlip.Hide(); } int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); txt_DocId.Text = ""; txt_InvoiceNo.Text = ""; txt_PurchaseAmt.Text = "0.00"; txt_StartDate.Text = ""; txt_EndDate.Text = ""; }
private void searchList(string page_num) { JObject jsonReq = new JObject(); try { cmbbox_Page.SelectedIndex = int.Parse(page_num) - 1; Transaction tran = new Transaction(); Utils util = new Utils(); string start_date = util.FormatConvertDate(TXT_REFUND_FROMDATE.Value.ToString()); string end_date = util.FormatConvertDate(TXT_REFUND_TODATE.Value.ToString()); jsonReq.Add("displayNum", display_num); jsonReq.Add("pageNum", page_num); jsonReq.Add("companyID", "000001"); jsonReq.Add("languageCD", "jp"); jsonReq.Add("user_desk_id", Constants.DESK_ID); jsonReq.Add("merchant_no", Constants.MERCHANT_NO); jsonReq.Add("dateFrom", start_date); jsonReq.Add("dateTo", end_date); if (!TXT_SLIP_NO.Text.Equals("")) { jsonReq.Add("slip_no", TXT_SLIP_NO.Text); } if (!TXT_TOTAL_SLIPSEQ.Text.Equals("")) //TOTAL_SLIPSEQ { jsonReq.Add("total_slipseq", TXT_TOTAL_SLIPSEQ.Text); } if (!COM_DATE_COND.SelectedValue.ToString().Equals("")) { jsonReq.Add("dateCond", COM_DATE_COND.SelectedValue.ToString()); } string refund_status_code = COM_REFUND_STATUS.SelectedValue.ToString(); if (!refund_status_code.Equals("")) { if (COM_REFUND_STATUS.SelectedValue.ToString().Equals("ALL")) { refund_status_code = null; } jsonReq.Add("refund_status_code", refund_status_code); } string strResult = tran.onlineSearch(jsonReq.ToString()); JArray a = JArray.Parse(strResult); int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); if (a == null || a.Count == 0) { MetroMessageBox.Show(this, Constants.getMessage("NO_SERACH_DATA"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { m_strLastSearchDate = start_date; GRD_SLIP.Rows.Add(a.Count); for (int i = 0; i < a.Count; i++) { JObject tempObj = (JObject)a[i]; GRD_SLIP[0, i].Value = (i + 1).ToString(); GRD_SLIP[1, i].Value = tempObj["SLIP_NO"].ToString(); GRD_SLIP[2, i].Value = tempObj["SALEDT"].ToString(); GRD_SLIP[3, i].Value = tempObj["MERCHANT_JPNM"].ToString(); GRD_SLIP[4, i].Value = Int64.Parse(tempObj["TOTAL_EXCOMM_SALE_AMT"].ToString()); GRD_SLIP[5, i].Value = Int64.Parse(tempObj["TOTAL_EXCOMM_TAX_AMT"].ToString()); GRD_SLIP[6, i].Value = Int64.Parse(tempObj["TOTAL_EXCOMM_REFUND_AMT"].ToString()); GRD_SLIP[7, i].Value = Int64.Parse(tempObj["TOTAL_COMM_SALE_AMT"].ToString()); GRD_SLIP[8, i].Value = Int64.Parse(tempObj["TOTAL_COMM_TAX_AMT"].ToString()); GRD_SLIP[9, i].Value = Int64.Parse(tempObj["TOTAL_COMM_REFUND_AMT"].ToString()); GRD_SLIP[10, i].Value = tempObj["REFUND_STATUS_CODE_DESC"].ToString(); GRD_SLIP[11, i].Value = tempObj["TOTAL_SLIPSEQ"].ToString(); GRD_SLIP[12, i].Value = tempObj["WORKERID"].ToString(); GRD_SLIP[13, i].Value = tempObj["SEND_FLAG"].ToString(); //GRD_SLIP[13, i].Value = Int64.Parse(tempObj["RETRY_CNT"].ToString()); GRD_SLIP[14, i].Value = tempObj["REFUND_STATUS_CODE"].ToString(); GRD_SLIP[15, i].Value = tempObj["REFUND_WAY_CODE"].ToString(); GRD_SLIP[16, i].Value = tempObj["PROGRESS_STATUS_CODE"].ToString(); tempObj = null; } } tran = null; } catch (Exception ex) { Constants.LOGGER_MAIN.Error(ex.StackTrace); MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/SearchFaild"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BTN_SEARCH_Click(object sender, EventArgs e) { if (!BTN_SEARCH.Enabled) { return; } BTN_SEARCH.Enabled = false; JObject jsonReq = new JObject(); init_num = 1; int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); try { setWaitCursor(true); /* * TimeSpan between_date = TXT_REFUND_TODATE.Value - TXT_REFUND_FROMDATE.Value; * int date_cnt = between_date.Days; * * if (DateTime.Compare(TXT_REFUND_FROMDATE.Value, TXT_REFUND_TODATE.Value) > 0) * { * MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/ValidateSearchDate")); * return; * } * else if (date_cnt > 10) * { * * MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/ExceedSearchDate")); * return; * } */ Transaction tran = new Transaction(); Utils util = new Utils(); string start_date = util.FormatConvertDate(TXT_REFUND_FROMDATE.Value.ToString()); string end_date = util.FormatConvertDate(TXT_REFUND_TODATE.Value.ToString()); jsonReq.Add("companyID", "000001"); jsonReq.Add("languageCD", "jp"); jsonReq.Add("user_desk_id", Constants.DESK_ID); jsonReq.Add("merchant_no", Constants.MERCHANT_NO); jsonReq.Add("dateFrom", start_date); jsonReq.Add("dateTo", end_date); if (!TXT_SLIP_NO.Text.Equals("")) { jsonReq.Add("slip_no", TXT_SLIP_NO.Text); } if (!TXT_TOTAL_SLIPSEQ.Text.Equals("")) //TOTAL_SLIPSEQ { jsonReq.Add("total_slipseq", TXT_TOTAL_SLIPSEQ.Text); } if (!COM_DATE_COND.SelectedValue.ToString().Equals("")) { jsonReq.Add("dateCond", COM_DATE_COND.SelectedValue.ToString()); } string refund_status_code = COM_REFUND_STATUS.SelectedValue.ToString(); if (!refund_status_code.Equals("")) { if (COM_REFUND_STATUS.SelectedValue.ToString().Equals("ALL")) { refund_status_code = ""; } else { jsonReq.Add("refund_status_code", refund_status_code); } } string page = "1"; int total_cnt = tran.onlineSearchCount(jsonReq.ToString()); if (total_cnt > 0) { if (cmbbox_Page.Items.Count > 0) { cmbbox_Page.Items.Clear(); } int i = 0; double quotient = total_cnt / display_num; double remainder = total_cnt % display_num; double tot_page = 0; if (remainder != 0) { tot_page = System.Math.Truncate(quotient); } else { tot_page = System.Math.Truncate(quotient) - 1; } for (i = 0; i <= tot_page; i++) { cmbbox_Page.Items.Add(i + 1); } searchList(page); } else { MetroMessageBox.Show(this, Constants.getMessage("NO_SERACH_DATA"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { } finally { setWaitCursor(false); BTN_SEARCH.Enabled = true; } }
private void BTN_SEARCH_Click(object sender, EventArgs e) { if (!BTN_SEARCH.Enabled) { return; } BTN_SEARCH.Enabled = false; JObject jsonReq = new JObject(); init_num = 1; int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); try { setWaitCursor(true); TimeSpan between_date = txt_EndDate.Value - txt_StartDate.Value; int date_cnt = between_date.Days; if (DateTime.Compare(txt_StartDate.Value, txt_EndDate.Value) > 0) { MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/ValidateSearchDate")); return; } else if (date_cnt > 10) { MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/ExceedSearchDate")); return; } jsonReq.Add("group_id", Constants.GROUP_ID); jsonReq.Add("start_date", Util.Utils.FormatConvertDate(txt_StartDate.Text)); jsonReq.Add("end_date", Util.Utils.FormatConvertDate(txt_EndDate.Text)); jsonReq.Add("shop_id", Constants.MID); if (!txt_DocId.Text.Replace(".", "").Replace(" ", "").Equals("")) { jsonReq.Add("doc_id", txt_DocId.Text.Replace(".", "").Replace(" ", "")); } if (!txt_InvoiceNo.Equals("")) { jsonReq.Add("receipt_no", txt_InvoiceNo.Text); } string value = txt_PurchaseAmt.Text.Replace(",", "").Replace("$", ""); if (!txt_PurchaseAmt.Text.Equals("") && (decimal.Parse(value) > 0)) { jsonReq.Add("receipt_amt", value); } Transaction tran = new Transaction(); string page = "1"; int total_cnt = tran.searchReceiptCount(jsonReq.ToString()); if (total_cnt > 0) { if (cmbbox_Page.Items.Count > 0) { cmbbox_Page.Items.Clear(); } int i = 0; double quotient = total_cnt / display_num; double remainder = total_cnt % display_num; double tot_page = 0; if (remainder != 0) { tot_page = System.Math.Truncate(quotient); } else { tot_page = System.Math.Truncate(quotient) - 1; } for (i = 0; i <= tot_page; i++) { cmbbox_Page.Items.Add(i + 1); } searchList(page); } else { //MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/DataNotFound")); MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/DataNotFound"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { } finally { setWaitCursor(false); BTN_SEARCH.Enabled = true; } }
private void searchList(string page_num) { JObject jsonReq = new JObject(); try { cmbbox_Page.SelectedIndex = int.Parse(page_num) - 1; Transaction tran = new Transaction(); jsonReq.Add("display_num", display_num); jsonReq.Add("page_num", page_num); jsonReq.Add("group_id", Constants.GROUP_ID); jsonReq.Add("start_date", Util.Utils.FormatConvertDate(txt_StartDate.Text)); jsonReq.Add("end_date", Util.Utils.FormatConvertDate(txt_EndDate.Text)); jsonReq.Add("shop_id", Constants.MID); if (!txt_DocId.Text.Replace(".", "").Replace(" ", "").Equals("")) { jsonReq.Add("doc_id", txt_DocId.Text.Replace(".", "").Replace(" ", "")); } if (!txt_InvoiceNo.Equals("")) { jsonReq.Add("receipt_no", txt_InvoiceNo.Text); } string value = txt_PurchaseAmt.Text.Replace(",", "").Replace("$", ""); if (!txt_PurchaseAmt.Text.Equals("") && (decimal.Parse(value) > 0)) { jsonReq.Add("receipt_amt", value); } string strResult = tran.searchReceiptList(jsonReq.ToString()); int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); if (!strResult.Equals("")) { nRow = GRD_SLIP.RowCount; JArray a = JArray.Parse(strResult); int i = 0; foreach (JObject json in a.Children <JObject>()) { GRD_SLIP.Rows.Add(); GRD_SLIP.Rows[nRow + i].Cells["No"].Value = json["row_no"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["Outlet"].Value = json["group_name"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["StoreName"].Value = json["store_name"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["GSTNo"].Value = json["gst_no"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["ReceiptNo"].Value = json["receipt_no"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["PurchaseDate"].Value = Util.Utils.FormatDate(json["purchase_date"].ToString()); GRD_SLIP.Rows[nRow + i].Cells["PurchaseAmt"].Value = json["purchase_amt"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["PurchaseItem"].Value = json["purchase_item"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["IssueDate"].Value = json["issue_date"].ToString(); GRD_SLIP.Rows[nRow + i].Cells["DocId"].Value = Util.Utils.FormatDocId(json["doc_id"].ToString()); /* * GRD_SLIP.Rows[nRow + i].Cells["SalesAmt"].Value = json["sales_amt"].ToString(); * GRD_SLIP.Rows[nRow + i].Cells["GSTAmt"].Value = json["gst_amt"].ToString(); * GRD_SLIP.Rows[nRow + i].Cells["RefundAmt"].Value = json["refund_amt"].ToString(); */ GRD_SLIP.Rows[nRow + i].Cells["Status"].Value = json["status_name"].ToString();; GRD_SLIP.Rows[nRow + i].Cells["StatusCode"].Value = json["status"].ToString();; i++; } } else { //MessageBox.Show(Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/DataNotFound")); MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/DataNotFound"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { Constants.LOGGER_MAIN.Error(ex.StackTrace); MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/SearchFaild"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BTN_SEARCH2_Click(object sender, EventArgs e) { BTN_SEARCH2.Enabled = false; JObject jsonReq = new JObject(); init_num = 1; int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); try { setWaitCursor(true); string value = txt_PurchaseAmt.Text.Replace(",", "").Replace("$", ""); jsonReq.Add("group_id", Constants.GROUP_ID); jsonReq.Add("start_date", Util.Utils.FormatConvertDate(txt_StartDate.Text)); jsonReq.Add("end_date", string.Empty); jsonReq.Add("doc_id", string.Empty); if(txt_InvoiceNo.Text.Equals("") || (decimal.Parse(value) < 1)) { MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/SearchValidate"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (!txt_InvoiceNo.Text.Equals("")) { jsonReq.Add("receipt_no", txt_InvoiceNo.Text); } if (!txt_PurchaseAmt.Text.Equals("") && (decimal.Parse(value) > 0)) { jsonReq.Add("receipt_amt", value); } jsonReq.Add("gst_no", string.Empty); Transaction tran = new Transaction(); string page = "1"; int total_cnt = tran.searchDocIdCount(jsonReq.ToString()); if (total_cnt > 0) { if (cmbbox_Page.Items.Count > 0) cmbbox_Page.Items.Clear(); int i = 0; double quotient = total_cnt / display_num; double remainder = total_cnt % display_num; double tot_page = 0; if (remainder != 0) { tot_page = System.Math.Truncate(quotient); } else { tot_page = System.Math.Truncate(quotient) - 1; } for (i = 0; i <= tot_page; i++) { cmbbox_Page.Items.Add(i + 1); } //searchListByInvoice(page); preAction = "BTN_SEARCH2"; cmbbox_Page.SelectedIndex = 0; } else { MetroMessageBox.Show(this, Constants.CONF_MANAGER.getCustomValue("Message", Constants.SYSTEM_LANGUAGE + "/DataNotFound"), "Search", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { Constants.LOGGER_MAIN.Error(ex.StackTrace); } finally { BTN_SEARCH2.Enabled = true; setWaitCursor(false); } }
private void COM_STORE_SelectedIndexChanged(object sender, EventArgs e) { int nRow = GRD_SLIP.RowCount; for (int i = nRow - 1; i >= 0; i--) { GRD_SLIP.Rows.RemoveAt(i); } GRD_SLIP.Refresh(); if (COM_STORE.SelectedIndex == 0) { BTN_SEARCH.Enabled = false; } else { BTN_SEARCH.Enabled = true; JObject jsonStore = Constants.merchant_list[(COM_STORE.SelectedIndex - 1)].ToObject<JObject>(); if (jsonStore["mid"] != null) { Constants.MID = jsonStore["mid"].ToString(); } if (jsonStore["tid"] != null) { Constants.TID = jsonStore["tid"].ToString(); } if (jsonStore["gst_no"] != null) { Constants.GST_NO = jsonStore["gst_no"].ToString(); } if (jsonStore["rec_prefix"] != null) { Constants.REC_PREFIX = jsonStore["rec_prefix"].ToString(); } if (jsonStore["dup_rc"] != null) { Constants.DUP_RC = jsonStore["dup_rc"].ToString(); } if (jsonStore["rec_digits"] != null) { Constants.REC_DIGITS = jsonStore["rec_digits"].ToString(); } if (jsonStore["item_code1"] != null) { Constants.ITEM_CODE1 = jsonStore["item_code1"].ToString(); } if (jsonStore["item_code2"] != null) { Constants.ITEM_CODE2 = jsonStore["item_code2"].ToString(); } if (jsonStore["item_code3"] != null) { Constants.ITEM_CODE3 = jsonStore["item_code3"].ToString(); } if (jsonStore["item_code4"] != null) { Constants.ITEM_CODE4 = jsonStore["item_code4"].ToString(); } if (jsonStore["item_code5"] != null) { Constants.ITEM_CODE5 = jsonStore["item_code5"].ToString(); } } }