示例#1
0
        public override bool Equals(Object obj)
        {
            clsProduct vObj = obj as clsProduct;

            if (vObj == null)
            {
                return(false);
            }
            else
            {
                return(ProductID.Equals(vObj.ProductID) && ColorID.Equals(vObj.ColorID));
            }
        }
示例#2
0
        internal void InsertScProduct(clsProduct ele)
        {
            string sql = "INSERT INTO " + clsGlobals.Gesin + "[tblGIScProduct]([ScenarioID],[GIProductID],[ProductColorID],[ProductID],[ColorID],[GIProductStatus]," +
                         "[ProductComment],[SurplusRate],[ReferenceNo1],[ReferenceNo2],[ExpShippingDate],[ExpArrivalDate],[VendorID],[VendorSiteID]," +
                         "[PurchaseTypeID],[DefaultWarehouseID],[DivisionID],[CollectionID],[VOSeasonID],[VONote],[VOMessage],[VOStatus],[VoPdfStatus]," +
                         "[CreatedByUserID],[CreatedDate])VALUES(" + ScenarioID + "," + ele.GIProductID + "," + ele.ProductColorID + "," + ele.ProductID +
                         "," + ele.ColorID + "," + ele.GIProductStatus + ",'" + ele.ProductComment + "'," + ele.SurplusRate + ",'" + clsGlobals.GIPar.ReferenceNo1 +
                         "','" + clsGlobals.GIPar.ReferenceNo2 + "','" + clsGlobals.GIPar.ExpShippingDate.ToString("yyyy-MM-dd") + "','" +
                         clsGlobals.GIPar.ExpArrivalDate.ToString("yyyy-MM-dd") + "'," + clsGlobals.GIPar.VendorID + "," + clsGlobals.GIPar.VendorSiteID +
                         "," + clsGlobals.GIPar.PurchaseTypeID + "," + clsGlobals.GIPar.DefaultWarehouseID + "," + clsGlobals.GIPar.DivisionID + ","
                         + clsGlobals.GIPar.CollectionID + "," + clsGlobals.GIPar.SeasonID + ",'" + clsGlobals.GIPar.VONote + "','" + clsGlobals.GIPar.VOMessage +
                         "',0,0," + clsGlobals.GIPar.UserID + ",GETDATE())";

            //Conexion.StartSession();
            Conexion.GDatos.RunSql(sql);
            Conexion.EndSession();
        }