示例#1
0
文件: ClsPrint.cs 项目: xpjy91/POS
        /// <summary>
        /// 포트오픈
        /// </summary>
        public void OpenPort()
        {
            try
            {
                spPort = new SerialPort()
                {
                    PortName = "COM7",
                    BaudRate = (int)9600,
                    DataBits = (int)8,
                    Parity   = Parity.None,
                    StopBits = StopBits.One,
                    //Handshake = Handshake.RequestToSend,
                    Handshake = Handshake.None,
                    //Encoding = Encoding.UTF8, //한글처리 필요시
                    Encoding     = Encoding.GetEncoding("ks_c_5601-1987"),
                    NewLine      = "\n",
                    ReadTimeout  = 500,
                    WriteTimeout = 500
                };

                spPort.Open();
            }
            catch (Exception ex)
            {
                spPort.Dispose();
                spPort = null;
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
        }
示例#2
0
        /// <summary>
        /// 로우 검사
        /// </summary>
        /// <param name="rowInput"></param>
        /// <returns></returns>
        private bool checkRow(DataGridViewRow rowInput)
        {
            bool bRet = false;

            try
            {
                if (rowInput == null)
                {
                    return(false);
                }
                else if (Regex.IsMatch(rowInput.Cells["colUnitPrice"].Value.ToString(), @"\D"))
                {
                    return(false);
                }
                else if (Regex.IsMatch(rowInput.Cells["colQty"].Value.ToString(), @"\D"))
                {
                    return(false);
                }
                else if (Regex.IsMatch(rowInput.Cells["colDisCount"].Value.ToString(), @"\D"))
                {
                    return(false);
                }

                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }

            return(bRet);
        }
示例#3
0
        /// <summary>
        /// 아이디체크
        /// </summary>
        /// <returns></returns>
        private bool CheckId()
        {
            bool   bRet  = false;
            string sId   = txtId.Text;
            string sName = null;

            try
            {
                if (CheckInput("I", sId) != true)
                {
                    return(false);
                }

                sName = clsLogin.SearchName(sId);
                if (sName != null)
                {
                    txtName.Text = sName;
                    txtPwd.Focus();
                    bRet = true;
                }
                else
                {
                    MessageBox.Show("잘못된 캐셔번호 입니다.");
                    txtName.Text = "";
                    txtId.Focus();
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            return(bRet);
        }
示例#4
0
文件: ClsTran.cs 项目: xpjy91/POS
        /// <summary>
        /// 거래번호조회
        /// </summary>
        /// <returns></returns>
        public string SelectTranNo()
        {
            string        sRet    = null;
            string        sQuery  = "SELECT MAX(TRAN_NO) FROM SALHDR";
            SqlDataReader sqlRead = null;

            try
            {
                sqlRead = clsDb.GetData(sQuery);

                if (sqlRead.Read() == true)
                {
                    sRet = sqlRead[0].ToString();
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            finally
            {
                if (sqlRead.IsClosed != true)
                {
                    sqlRead.Close();
                }
            }
            return(sRet);
        }
示例#5
0
        /// <summary>
        /// 숫자키 클릭 이벤트
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnNum_Click(object sender, EventArgs e)
        {
            string sKey = null;

            try
            {
                sKey = ((Button)sender).Text;
                if (ctrFocus == txtId)
                {
                    if ((txtId.Text.Length + sKey.Length) <= 6)
                    {
                        txtId.Text += sKey;
                    }
                    txtId.Focus();
                    txtId.Select(txtId.TextLength, 0);
                }
                else if (ctrFocus == txtPwd)
                {
                    if ((txtPwd.Text.Length + sKey.Length) <= 2)
                    {
                        txtPwd.Text += sKey;
                    }
                    txtPwd.Focus();
                    txtPwd.Select(txtPwd.TextLength, 0);
                }//end if~ else if
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
        }
示例#6
0
文件: ClsTran.cs 项目: xpjy91/POS
        /// <summary>
        /// 거래보류 카운트
        /// </summary>
        /// <returns></returns>
        public int SelectHoldCount()
        {
            int           iRet    = 0;
            SqlDataReader sqlRead = null;
            string        sQuery  = null;

            try
            {
                sQuery = "SELECT count(*) " +
                         "FROM SALHDR " +
                         "WHERE tran_type = '02'";

                sqlRead = clsDb.GetData(sQuery);
                if (sqlRead.Read() == true)
                {
                    iRet = (int)sqlRead[0];
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            finally
            {
                if (sqlRead.IsClosed != true)
                {
                    sqlRead.Close();
                }
            }
            return(iRet);
        }
示例#7
0
        /// <summary>
        /// 보류리스트
        /// </summary>
        public bool SearchHoldList()
        {
            bool bRet   = false;
            int  iIndex = 0;
            List <Dictionary <string, string> > liHold = null;

            try
            {
                liHold = clsTran.SearchHold();
                if (liHold.Count > 0)
                {
                    foreach (Dictionary <string, string> dicHold in liHold)
                    {
                        iIndex = grdHoldList.Rows.Add();
                        grdHoldList.Rows[iIndex].Cells["colNo"].Value       = iIndex;
                        grdHoldList.Rows[iIndex].Cells["colSaleDate"].Value = dicHold["sal_date"];
                        grdHoldList.Rows[iIndex].Cells["colPrice"].Value    = dicHold["sal_price"];
                        grdHoldList.Rows[iIndex].Cells["colStoreNo"].Value  = dicHold["STORE_NO"];
                        grdHoldList.Rows[iIndex].Cells["colPosNo"].Value    = dicHold["POS_NO"];
                        grdHoldList.Rows[iIndex].Cells["colTranNo"].Value   = dicHold["TRAN_NO"];
                    }
                    bRet = true;
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }

            return(bRet);
        }
示例#8
0
文件: ClsLogin.cs 项目: xpjy91/POS
        /// <summary>
        /// 이름검색
        /// </summary>
        /// <param name="sId"></param>
        /// <returns></returns>
        public string SearchName(string sId)
        {
            string sName  = null;
            string sQuery = "SELECT EMP_NAME FROM EMPMST " +
                            "WHERE EMP_ID =" + "'" + sId + "'";
            SqlDataReader sqlRead = null;

            try
            {
                sqlRead = clsDb.GetData(sQuery);

                if (sqlRead.Read() == true)
                {
                    sName = sqlRead[0].ToString();
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            finally
            {
                if (sqlRead.IsClosed != true)
                {
                    sqlRead.Close();
                }
            }
            return(sName);
        }
示例#9
0
文件: ClsLogin.cs 项目: xpjy91/POS
        /// <summary>
        /// 로그인체크
        /// </summary>
        /// <param name="sId"></param>
        /// <param name="sPwd"></param>
        /// <returns></returns>
        public bool CheckLogin(string sId, string sPwd)
        {
            bool   bRet   = false;
            int    iCount = -1;
            string sQuery = "SELECT count(*) FROM EMPMST " +
                            "WHERE EMP_ID =" + "'" + sId + "'" +
                            "AND EMP_PASS ="******"'" + sPwd + "'";
            SqlDataReader sqlRead = null;

            try
            {
                sqlRead = clsDb.GetData(sQuery);
                if (sqlRead.Read() == true)
                {
                    iCount = (int)sqlRead[0];
                    if (iCount > 0)
                    {
                        bRet = true;
                    }
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            finally
            {
                if (sqlRead.IsClosed != true)
                {
                    sqlRead.Close();
                }
            }

            return(bRet);
        }
示例#10
0
        /// <summary>
        /// 판매등록
        /// </summary>
        private bool RegisterSale()
        {
            bool     bRet     = false;
            FrmLogin frmLogin = null;

            try
            {
                frmLogin = new FrmLogin();
                frmLogin.ShowDialog();

                if (ClsMain.sLoginState == "true")
                {
                    FrmSale frmSale = new FrmSale();
                    frmSale.txtCashierNo.Text   = ClsMain.sCashierNo;
                    frmSale.txtCashierName.Text = ClsMain.sName;
                    frmSale.ShowDialog();
                }
                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            return(bRet);
        }
示例#11
0
        /// <summary>
        /// 수량 변경
        /// </summary>
        /// <returns></returns>
        private bool ChangeQty()
        {
            bool   bRet   = false;
            string sValue = null;
            int    iQty   = 0;

            try
            {
                sValue = txtInput.Text;
                if (sValue == "")
                {
                    sValue = (int.Parse(grdSaleList.CurrentRow.Cells["colQty"].Value.ToString()) + 1).ToString();
                }
                if (CheckInput("count", sValue) != true)
                {
                    return(false);
                }
                iQty = int.Parse(sValue);
                grdSaleList.CurrentRow.Cells["colQty"].Value = iQty;
                txtInput.Clear();
                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            return(bRet);
        }
示例#12
0
        /// <summary>
        /// 가격변경
        /// </summary>
        /// <param name="sPrice"></param>
        /// <returns></returns>
        private bool ChangePrice()
        {
            bool   bRet   = false;
            string sValue = null;
            int    iPrice = 0;

            try
            {
                sValue = txtInput.Text;
                if (CheckInput("price", sValue) != true)
                {
                    return(false);
                }
                iPrice = int.Parse(sValue);
                grdSaleList.CurrentRow.Cells["colUnitPrice"].Value = iPrice;
                txtInput.Clear();
                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }

            return(bRet);
        }
示例#13
0
        /// <summary>
        /// 로우추가
        /// </summary>
        /// <param name="rowData"></param>
        /// <returns></returns>
        public bool AddRow(List <Dictionary <string, string> > liRowData)
        {
            bool bRet   = false;
            int  iIndex = 0;

            try
            {
                if (liRowData.Count > 0)
                {
                    foreach (Dictionary <string, string> rowData in liRowData)
                    {
                        iIndex = grdSaleList.Rows.Add();
                        grdSaleList.Rows[iIndex].Cells["colSeq"].Value       = iIndex;
                        grdSaleList.Rows[iIndex].Cells["colCode"].Value      = rowData["colCode"];
                        grdSaleList.Rows[iIndex].Cells["colTitle"].Value     = rowData["colTitle"];
                        grdSaleList.Rows[iIndex].Cells["colUnitPrice"].Value = rowData["colUnitPrice"];
                        grdSaleList.Rows[iIndex].Cells["colQty"].Value       = rowData["colQty"];
                        grdSaleList.Rows[iIndex].Cells["colDisCount"].Value  = rowData["colDisCount"];
                        grdSaleList.Rows[iIndex].Cells["colTaxYn"].Value     = rowData["colTaxYn"];
                        grdSaleList.Rows[iIndex].Cells["colPrice"].Value     = rowData["colPrice"];
                        grdSaleList.Rows[iIndex].Cells["colRemarks"].Value   = rowData["colRemarks"];
                    }

                    ChangeButton("tran");
                    bRet = true;
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            return(bRet);
        }
示例#14
0
        /// <summary>
        /// 행 삭제
        /// </summary>
        /// <returns></returns>
        private bool DeleteRow()
        {
            bool            bRet        = false;
            DataGridViewRow grdRow      = null;
            int             iCurrentRow = 0;

            try
            {
                if (grdSaleList.CurrentRow == null)
                {
                    return(false);
                }
                iCurrentRow = grdSaleList.CurrentRow.Index;
                grdRow      = grdSaleList.Rows[iCurrentRow];
                grdSaleList.Rows.RemoveAt(iCurrentRow);
                if (grdSaleList.Rows.Count <= 0)
                {
                    ChangeButton("sale");
                }
                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            return(bRet);
        }
示例#15
0
        /// <summary>
        //  행업데이트
        /// </summary>
        private bool UpdateRow()
        {
            bool bRet = false;

            int iUnitPrice = 0;
            int iPrice     = 0;
            int iQty       = 0;
            int iDisCount  = 0;
            int iRowIndex  = 0;

            try
            {
                if (checkRow(grdSaleList.CurrentRow) != true)
                {
                    return(false);
                }

                iRowIndex  = grdSaleList.CurrentRow.Index;
                iUnitPrice = int.Parse(grdSaleList.Rows[iRowIndex].Cells["colUnitPrice"].Value.ToString());
                iQty       = int.Parse(grdSaleList.Rows[iRowIndex].Cells["colQty"].Value.ToString());
                iDisCount  = int.Parse(grdSaleList.Rows[iRowIndex].Cells["colDisCount"].Value.ToString());
                //iPrice = (iUnitPrice * iQty) - ((iUnitPrice * iQty) * iDisCount / 100 );
                iPrice = (iUnitPrice * iQty) - (iDisCount * iQty);
                grdSaleList.Rows[iRowIndex].Cells["colPrice"].Value = iPrice;

                bRet = true;
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }


            return(bRet);
        }
示例#16
0
        /// <summary>
        /// 합계업데이트
        /// </summary>
        /// <returns></returns>
        private bool UpdateTotal()
        {
            bool bRet = false;

            int iSubTotal = 0;
            int iDisCount = 0;
            int iTotal    = 0;

            try
            {
                foreach (DataGridViewRow grdRow in grdSaleList.Rows)
                {
                    iSubTotal += int.Parse(grdRow.Cells["colUnitPrice"].Value.ToString()) * int.Parse(grdRow.Cells["colQty"].Value.ToString());
                    iTotal    += int.Parse(grdRow.Cells["colPrice"].Value.ToString());
                }

                iDisCount        = iSubTotal - iTotal;
                txtSubTotal.Text = String.Format("{0:#,###}", iSubTotal);
                txtDisCount.Text = String.Format("{0:#,###}", iDisCount);
                txtTotal.Text    = String.Format("{0:#,###}", iTotal);
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }

            return(bRet);
        }
示例#17
0
        /// <summary>
        /// 할인변경
        /// </summary>
        /// <param name="Discount"></param>
        /// <returns></returns>
        private bool ChangeDisCount()
        {
            bool   bRet      = false;
            int    iDisCount = 0;
            string sValue    = null;
            string sType     = "persent";

            int iUnitPrice = 0;
            int iTemp      = 0;

            try
            {
                sValue = txtInput.Text;
                if (CheckInput("disCount", sValue) != true)
                {
                    return(false);
                }
                if (sValue == "99")
                {
                    sType = "value";
                }

                switch (sType)
                {
                case "persent":

                    iDisCount  = int.Parse(sValue);
                    iUnitPrice = int.Parse(grdSaleList.CurrentRow.Cells["colUnitPrice"].Value.ToString());

                    iTemp = (iUnitPrice * iDisCount / 100);
                    grdSaleList.CurrentRow.Cells["colDisCount"].Value = iTemp;
                    grdSaleList.CurrentRow.Cells["colRemarks"].Value  = iDisCount + "% 할인";

                    txtInput.Clear();
                    bRet = true;

                    break;

                case "value":

                    FrmDisCount frmDisCount = new FrmDisCount(this);
                    frmDisCount.Show();

                    bRet = true;
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }

            return(bRet);
        }
示例#18
0
 /// <summary>
 /// ESC 버튼 클릭
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnEsc_Click(object sender, EventArgs e)
 {
     try
     {
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#19
0
 /// <summary>
 /// 폼시작 이벤트
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void FrmLogin_Load(object sender, EventArgs e)
 {
     try
     {
         ClsDB.OpenDataBase();
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#20
0
 /// <summary>
 /// 폼종료 이벤트
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void FrmSale_FormClosed(object sender, FormClosedEventArgs e)
 {
     try
     {
         ClsDB.CloseDataBase();
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#21
0
 /// <summary>
 /// 등록버튼 클릭 이벤트
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnRegister_Click(object sender, EventArgs e)
 {
     try
     {
         this.Close();
     }//end try
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }//end catch
 }
示例#22
0
        private void btnMain_Click(object sender, EventArgs e)
        {
            int iIndex = 0;

            try
            {
                iIndex = ((Button)sender).TabIndex;
                switch (iIndex)
                {
                case 1:
                    //영업시작
                    StartSale();
                    break;

                case 2:
                    //판매등록
                    RegisterSale();
                    break;

                case 3:
                    //마감입금
                    break;

                case 4:
                    //정산출력
                    break;

                case 5:
                    //관리설정
                    break;

                case 6:
                    //영업관리
                    break;

                case 7:
                    //영업종료
                    CloseSale();
                    break;

                case 8:
                    //종    료
                    ClosePos();
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
        }
示例#23
0
 /// <summary>
 /// 포커스 저장
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void txtFocus_Enter(object sender, EventArgs e)
 {
     try
     {
         ctrFocus = (Control)sender;
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(1, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#24
0
文件: ClsPrint.cs 项目: xpjy91/POS
 /// <summary>
 /// 포트종료
 /// </summary>
 public void ClosePort()
 {
     try
     {
         spPort.Close();
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#25
0
 /// <summary>
 /// 데이터베이스 열기
 /// </summary>
 public static void OpenDataBase()
 {
     try
     {
         sqlConn = new SqlConnection(sSource);
         sqlConn.Open();
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#26
0
        /// <summary>
        /// 상품복원
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void RestoreGoods()
        {
            FrmRestore frmRestor = new FrmRestore(this);

            try
            {
                frmRestor.Show();
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
        }
示例#27
0
 /// <summary>
 /// 고객정보 엔터 이벤트
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void txtInfo_KeyDown(object sender, KeyEventArgs e)
 {
     try
     {
         if (e.KeyCode == Keys.Return)
         {
         }
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#28
0
文件: ClsTran.cs 项目: xpjy91/POS
        /// <summary>
        /// 보류리스트 검색
        /// </summary>
        /// <param name="sTranNo"></param>
        /// <returns></returns>
        public List <Dictionary <string, string> > SearchHold()
        {
            SqlDataReader sqlRead = null;
            List <Dictionary <string, string> > liRet    = null;
            Dictionary <string, string>         dicGoods = null;
            string sQuery = null;

            try
            {
                liRet  = new List <Dictionary <string, string> >();
                sQuery = "SELECT hdr.sal_date, " +
                         "hdr.tot_amt AS sal_HoldPrice, " +
                         "hdr.POS_NO, " +
                         "hdr.STORE_NO, " +
                         "hdr.TRAN_NO " +
                         "FROM  salhdr hdr " +
                         "INNER JOIN saldtl dtl " +
                         "ON(hdr.sal_date = dtl.sal_date " +
                         "AND hdr.store_no = dtl.store_no " +
                         "AND hdr.pos_no = dtl.pos_no " +
                         "AND hdr.tran_no = dtl.tran_no) " +
                         "WHERE hdr.tran_type = '02' " +
                         "GROUP BY hdr.TRAN_TYPE, hdr.SAL_DATE, hdr.TOT_AMT, hdr.POS_NO, hdr.STORE_NO, hdr.TRAN_NO";

                sqlRead = clsDb.GetData(sQuery);

                while (sqlRead.Read() == true)
                {
                    dicGoods              = new Dictionary <string, string>();
                    dicGoods["sal_date"]  = sqlRead["sal_date"].ToString();
                    dicGoods["sal_price"] = sqlRead["sal_HoldPrice"].ToString();
                    dicGoods["STORE_NO"]  = sqlRead["STORE_NO"].ToString();
                    dicGoods["POS_NO"]    = sqlRead["POS_NO"].ToString();
                    dicGoods["TRAN_NO"]   = sqlRead["TRAN_NO"].ToString();

                    liRet.Add(dicGoods);
                }
            }
            catch (Exception ex)
            {
                ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
            }
            finally
            {
                if (sqlRead.IsClosed != true)
                {
                    sqlRead.Close();
                }
            }
            return(liRet);
        }
示例#29
0
文件: FrmDisCount.cs 项目: xpjy91/POS
 /// <summary>
 /// 종료버튼 클릭 이벤트
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnClose_Click(object sender, EventArgs e)
 {
     try
     {
         if (MessageBox.Show("종료하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
         {
             Application.Exit();
         }
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }
示例#30
0
 /// <summary>
 /// 날짜 타이머
 /// </summary>
 private void DateTimer()
 {
     try
     {
         Timer timer = new System.Windows.Forms.Timer();
         timer.Interval = 1000; // 1초
         timer.Tick    += new EventHandler(GetCurrentDate);
         timer.Start();
     }
     catch (Exception ex)
     {
         ClsLog.WriteLog(ClsLog.LOG_EXCEPTION, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message);
     }
 }