static void Main(string[] args) { //Utilities.updateTime(); //Utilities.UploadStandardTime(); string lineDesc = "BBRLED-1000-80-35-RG-35'-W-UNV-DP-1-DF"; lineDesc = "SKPLED-22-4000-80-35-0.5-W-UNV-DP-1-TB9"; string DWConnectiontring = "metadata = res://*/DBConnection.csdl|res://*/DBConnection.ssdl|res://*/DBConnection.msl;provider=System.Data.SqlClient;provider connection string='Data Source=VAULT\\DRIVEWORKS;Initial Catalog=\"AXIS Automation\";Integrated Security=True;MultipleActiveResultSets=True'"; using (AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities _AutomationEntities = new AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities(DWConnectiontring)) { _Fixture fixture = new AXISAutomation.FixtureConfiguration._Fixture(lineDesc, _AutomationEntities); fixture.SPM.ConfigureAll(); var Time = new TimeCalculator(fixture, 4); } using (var db = new DWModel()) { //string codeid = "BBRLED"; //string optionName = "Standard"; //string workStation = "Cutting Extrusion"; //string CategoryName = "Length"; //string parameter = "8"; //var time = db.Timing_Option.First(r => r.Fixture.Code == codeid //&& r.Name == optionName && r.Timing_WorkStations.Name == workStation //&& r.Categories.Any( t => t.Name == CategoryName) //&& r.Parameters.Any(e => e.Code == parameter)); //int optionID = 72636; //var time2 = db.Timing_Option.Where(r => r.OptionID == optionID).FirstOrDefault(); //time2.Time = (decimal)1.40; //db.SaveChanges(); } }
public ProductClass(string ProductCode) { var DriveWorkdb = new AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities(); this.BOM = new _BOM(ProductCode, DriveWorkdb); bool morepage; var BO = UD30BO.GetRows(string.Format("Key1 = 'PRODUCTID' and key2 = '{0}'", this.BOM.GetselectedproductID_Category), "", 0, 0, out morepage); this.productCode = BO.UD03[0]["Key2"].ToString(); this.fixtureCode = BO.UD03[0]["Character03"].ToString(); this.ProdFamCode = BO.UD03[0]["Key3"].ToString(); string optic = this.BOM.GetSelectedOpticsDirect_Category.ToString(); string mounting = this.BOM.GetSelectedMounting_Category.ToString(); string driver = this.BOM.GetSelectedDriver_Category; string defaultMounting = "-"; var x = (this.BOM.GetSelectedLength_Category.ToString()).Replace("'", ""); int length = Int32.Parse(x); lengthParam.Add(null); List <string> sectionType = new List <string>(); if (length < 12) { lengthParam.Add(length); sectionType.Add("Complete Section"); using (var db = new TimeContext()) { int dummy; var lengthtest = db.Options.Where(r => r.OptionName == "Length" && r.sectionLength == length).FirstOrDefault(); var cartridge = (from row in lengthtest.Params where !int.TryParse(row.ParamValue, out dummy) select row.ParamValue).ToList(); sectionType.AddRange(cartridge); } } else { using (var db = new TimeContext()) { int dummy; var lengthtest = db.Options.Where(r => r.OptionName == "Length" && r.sectionLength == length).FirstOrDefault(); var cartridge = (from row in lengthtest.Params where !int.TryParse(row.ParamValue, out dummy) select row.ParamValue).ToList(); List <int> Length = (from row in lengthtest.Params where int.TryParse(row.ParamValue, out dummy) select Int32.Parse(row.ParamValue)).ToList(); sectionType.AddRange(cartridge); var newList = Length.Select(i => (int?)i).ToList(); lengthParam.AddRange(newList); } } ParamValue.AddRange(new List <string> { optic, mounting, defaultMounting, driver, //Driver }); ParamValue.AddRange(sectionType); this.Initial(); this.retrieveTime(); }