예제 #1
0
        private void LoadData()
        {
            ArrayList al = DBLayer.ArrivalDetails.GetList(0, Date1, Date2);

            DataTable dt = new DataTable();

            dt.Columns.Add("Id", typeof(int));
            dt.Columns.Add("Date", typeof(DateTime));
            dt.Columns.Add("Total", typeof(double));
            dt.Columns.Add("Cost", typeof(double));
            dt.Columns.Add("Good");
            dt.Columns.Add("Quantity", typeof(double));
            dt.Columns.Add("Supplier");
            dt.Columns.Add("Dimension");

            double total = 0;

            for (int i = 0; i < al.Count; i++)
            {
                DataRow dr = dt.Rows.Add();

                DBLayer.ArrivalDetails.ArrivalDetails_WideDetails det = (DBLayer.ArrivalDetails.ArrivalDetails_WideDetails)al[i];

                dr["Id"]        = det.Id;
                dr["Supplier"]  = det.SupplierName;
                dr["Date"]      = det.Date;
                dr["Good"]      = det.ProductName;
                dr["Quantity"]  = det.Quantity;
                dr["Cost"]      = det.Price;
                dr["Total"]     = det.Price * det.Quantity;
                dr["Dimension"] = det.DimensionName;

                total += (det.Price * det.Quantity);
            }

            grGoods.DataSource = dt;
            advBandedGridView1.BestFitColumns();

            slblTotal.Text = total.ToString();
        }
예제 #2
0
        public static ArrayList GetList(int id, DateTime date1, DateTime date2)
        {
            string sql = "SELECT a.*, p.[Name], d.[Name] AS DimensionName, pg.[Name] AS GroupName, ";

            sql += " s.[Name] AS SupplierName  FROM ArrivalDetails AS a INNER JOIN Products AS p ON a.ProductId = p.[Id]  ";
            sql += " INNER JOIN Suppliers AS s ON s.[Id] = a.[SupplierId]  ";
            sql += " INNER JOIN ProductGroup AS pg ON pg.[Id] = p.GroupId  ";
            sql += " INNER JOIN Dimensions AS d ON d.[Id] = p.DimensionId ";
            sql += " WHERE a.[Date] BETWEEN '" + date1.ToString("yyyyMMdd") + "' AND '" + date2.ToString("yyyyMMdd") + "' ";
            sql += " ORDER BY [Date]";


            DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);

            ArrayList al = new ArrayList();

            foreach (DataRow dr in dt.Rows)
            {
                DBLayer.ArrivalDetails.ArrivalDetails_WideDetails det = new DBLayer.ArrivalDetails.ArrivalDetails_WideDetails();

                if (!dr.IsNull("Id"))
                {
                    det.Id = Convert.ToInt32(dr["Id"]);
                }

                if (!dr.IsNull("ArrivalId"))
                {
                    det.ArrivalId = Convert.ToInt32(dr["ArrivalId"]);
                }

                if (!dr.IsNull("Price"))
                {
                    det.Price = Convert.ToDouble(dr["Price"]);
                }

                if (!dr.IsNull("ProductId"))
                {
                    det.ProductId = Convert.ToInt32(dr["ProductId"]);
                }

                det.ProductName = dr["Name"].ToString();

                if (!dr.IsNull("Quantity"))
                {
                    det.Quantity = Convert.ToDouble(dr["Quantity"]);
                }

                det.DimensionName = dr["DimensionName"].ToString();

                det.GroupName     = dr["GroupName"].ToString();
                det.DimensionName = dr["DimensionName"].ToString();

                if (!dr.IsNull("SupplierId"))
                {
                    det.SupplierId = Convert.ToInt32(dr["SupplierId"]);
                }

                if (!dr.IsNull("Date"))
                {
                    det.Date = Convert.ToDateTime(dr["Date"]);
                }

                det.SupplierName = dr["SupplierName"].ToString();

                al.Add(det);
            }

            return(al);
        }