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)); } }
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(); }