Ejemplo n.º 1
0
        /// <summary>
        /// Delete an item
        /// </summary>
        /// <param name="inItem">Input item</param>
        /// <returns>Number item is deleted</returns>
        public int DeleteItem(pts_stockout_log inItem)
        {
            //SQL library
            PSQL   SQL   = new PSQL();
            string query = string.Empty;

            //Open SQL connection
            SQL.Open();
            //SQL query string
            query = "DELETE FROM pts_stockout_log WHERE stockout_id ='" + inItem.stockout_id + "'";
            //Execute non query for read database
            int result = SQL.Command(query).ExecuteNonQuery();

            query = string.Empty;
            SQL.Close();
            return(result);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Search list stock out item with date
        /// </summary>
        /// <param name="fromDate">From stock out date</param>
        /// <param name="toDate">To stock out date</param>
        public void Search(DateTime fromDate, DateTime toDate)
        {
            //SQL library
            PSQL   SQL   = new PSQL();
            string query = string.Empty;

            //Open SQL connection
            SQL.Open();
            //SQL query string
            query  = "SELECT stockout_id, packing_cd, process_cd, issue_cd, stockout_date, stockout_user_cd, stockout_qty, ";
            query += "real_qty, received_user_cd, comment, remark FROM pts_stockout_log WHERE 1=1 ";
            query += "AND stockout_date >='" + fromDate.ToString("yyyy-MM-dd") + "' ";
            query += "AND stockout_date <='" + toDate.ToString("yyyy-MM-dd") + "' ";
            query += "ORDER BY stockout_id";
            //Execute reader for read database
            IDataReader reader = SQL.Command(query).ExecuteReader();

            //Clear query
            query = string.Empty;
            //Read data into list
            while (reader.Read())
            {
                pts_stockout_log outItem = new pts_stockout_log
                {
                    stockout_id      = (int)reader["stockout_id"],
                    packing_cd       = reader["packing_cd"].ToString(),
                    process_cd       = reader["process_cd"].ToString(),
                    issue_cd         = (int)reader["issue_cd"],
                    stockout_date    = (DateTime)reader["stockout_date"],
                    stockout_user_cd = reader["stockout_user_cd"].ToString(),
                    stockout_qty     = (double)reader["stockout_qty"],
                    real_qty         = (double)reader["real_qty"],
                    received_user_cd = reader["received_user_cd"].ToString(),
                    comment          = reader["comment"].ToString(),
                    remark           = reader["remark"].ToString(),
                };
                listStockOutItem.Add(outItem);
            }
            //Close reader and connection
            reader.Close();
            SQL.Close();
        }
Ejemplo n.º 3
0
        public void SearchMultiPacking(string processCD, string itemCD)
        {
            //SQL library
            PSQL   SQL   = new PSQL();
            string query = string.Empty;

            listStockOutItem = new List <pts_stockout_log>();
            //Open SQL connection
            SQL.Open();
            //SQL query string
            query  = "SELECT stockout_id, packing_cd, process_cd, issue_cd, stockout_date, stockout_user_cd, stockout_qty, ";
            query += "real_qty, received_user_cd, comment, remark FROM pts_stockout_log WHERE 1=1 ";
            query += "AND process_cd like '" + processCD + "%' and packing_cd in(select packing_cd from pts_stock where item_cd ='" + itemCD + "') ";
            query += "ORDER BY packing_cd";
            //Execute reader for read database
            IDataReader reader = SQL.Command(query).ExecuteReader();

            //Clear query
            query = string.Empty;
            //Read data into list
            while (reader.Read())
            {
                pts_stockout_log outItem = new pts_stockout_log
                {
                    stockout_id      = (int)reader["stockout_id"],
                    packing_cd       = reader["packing_cd"].ToString(),
                    process_cd       = reader["process_cd"].ToString(),
                    issue_cd         = (int)reader["issue_cd"],
                    stockout_date    = (DateTime)reader["stockout_date"],
                    stockout_user_cd = reader["stockout_user_cd"].ToString(),
                    stockout_qty     = (double)reader["stockout_qty"],
                    real_qty         = (double)reader["real_qty"],
                    received_user_cd = reader["received_user_cd"].ToString(),
                    comment          = reader["comment"].ToString(),
                    remark           = reader["remark"].ToString(),
                };
                listStockOutItem.Add(outItem);
            }
            //Close reader and connection
            reader.Close();
            SQL.Close();
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Add an stock out log
        /// </summary>
        /// <param name="inItem">Input item</param>
        /// <returns>Number of item is added</returns>
        public int AddItem(pts_stockout_log inItem)
        {
            //SQL library
            PSQL   SQL   = new PSQL();
            string query = string.Empty;

            //Open SQL connection
            SQL.Open();
            //SQL query string
            query  = "INSERT INTO pts_stockout_log(packing_cd, process_cd, issue_cd, stockout_date, stockout_user_cd, ";
            query += "stockout_qty, real_qty, received_user_cd, comment, remark) VALUES ";
            query += "('" + inItem.packing_cd + "','" + inItem.process_cd + "','" + inItem.issue_cd + "','" + inItem.stockout_date;
            query += "','" + inItem.stockout_user_cd + "','" + inItem.stockout_qty + "','" + inItem.real_qty + "','";
            query += inItem.received_user_cd + "','" + inItem.comment + "','" + inItem.remark + "')";
            //Execute non query for read database
            int result = SQL.Command(query).ExecuteNonQuery();

            query = string.Empty;
            SQL.Close();
            return(result);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// Search list stock out item with item code and invoice
        /// </summary>
        /// <param name="inItem">info item want search</param>
        /// <param name="itemCode">item code</param>
        /// <param name="itemInvoice">item invoice</param>
        /// <param name="setNumber">set number</param>
        /// <param name="fromDate"></param>
        /// <param name="toDate"></param>
        /// <param name="checkDate">true: check date</param>
        public void Search(pts_stockout_log inItem, string itemCode, string itemInvoice, string setNumber, string destinationCode, DateTime fromDate, DateTime toDate, bool checkDate)
        {
            //SQL library
            PSQL   SQL   = new PSQL();
            string query = string.Empty;

            //Open SQL connection
            SQL.Open();
            //SQL query string
            query  = "SELECT stockout_id, packing_cd, process_cd, issue_cd, stockout_date, stockout_user_cd, stockout_qty, ";
            query += "real_qty, received_user_cd, comment, remark FROM pts_stockout_log WHERE 1=1 ";
            if (!string.IsNullOrEmpty(inItem.process_cd))
            {
                query += "AND process_cd ='" + inItem.process_cd + "' ";
            }
            if (!string.IsNullOrEmpty(destinationCode))
            {
                query += "AND process_cd in (select request_cd as process_cd from pts_request_log where destination_cd ='" + destinationCode + "' union ";
                query += "select plan_cd as process_cd from pts_plan where destination_cd ='" + destinationCode + "' union ";
                query += "select noplan_cd as process_cd from pts_noplan where destination_cd ='" + destinationCode + "') ";
            }
            if (!string.IsNullOrEmpty(inItem.packing_cd) && string.IsNullOrEmpty(itemCode) && string.IsNullOrEmpty(itemInvoice))
            {
                query += "AND packing_cd ='" + inItem.packing_cd + "' ";
            }
            if (!string.IsNullOrEmpty(itemCode))
            {
                query += "AND packing_cd in ( select packing_cd from pts_stock where item_cd ='" + itemCode + "') ";
            }
            if (!string.IsNullOrEmpty(itemInvoice))
            {
                query += "AND packing_cd in ( select packing_cd from pts_stock where invoice ='" + itemInvoice + "') ";
            }
            if (!string.IsNullOrEmpty(setNumber))
            {
                query += "AND packing_cd in ( select packing_cd from pts_stock where order_no ='" + setNumber + "') ";
            }
            if (checkDate)
            {
                query += "AND stockout_date >='" + fromDate.ToString("yyyy-MM-dd") + "' AND stockout_date <='" + toDate.ToString("yyyy-MM-dd") + "' ";
            }
            if (inItem.issue_cd > 0)
            {
                query += "AND issue_cd ='" + inItem.issue_cd + "' ";
            }
            if (!string.IsNullOrEmpty(inItem.stockout_user_cd))
            {
                query += "AND stockout_user_cd ='" + inItem.stockout_user_cd + "' ";
            }
            if (!string.IsNullOrEmpty(inItem.received_user_cd))
            {
                query += "AND received_user_cd ='" + inItem.received_user_cd + "' ";
            }
            if (!string.IsNullOrEmpty(inItem.remark))
            {
                query += "AND remark ='" + inItem.remark + "' ";
            }
            query += "ORDER BY stockout_id";
            //Execute reader for read database
            IDataReader reader = SQL.Command(query).ExecuteReader();

            //Clear query
            query = string.Empty;
            //Read data into list
            while (reader.Read())
            {
                pts_stockout_log outItem = new pts_stockout_log
                {
                    stockout_id      = (int)reader["stockout_id"],
                    packing_cd       = reader["packing_cd"].ToString(),
                    process_cd       = reader["process_cd"].ToString(),
                    issue_cd         = (int)reader["issue_cd"],
                    stockout_date    = (DateTime)reader["stockout_date"],
                    stockout_user_cd = reader["stockout_user_cd"].ToString(),
                    stockout_qty     = (double)reader["stockout_qty"],
                    real_qty         = (double)reader["real_qty"],
                    received_user_cd = reader["received_user_cd"].ToString(),
                    comment          = reader["comment"].ToString(),
                    remark           = reader["remark"].ToString(),
                };
                listStockOutItem.Add(outItem);
            }
            //Close reader and connection
            reader.Close();
            SQL.Close();
        }