public StoreInPlan(SessionInfo _session = null, StoreInPlanHead model = null) { InitializeComponent(); this._repo = new StoreInPlanRepo(); this._repoIn = new StoreInRepo(); this._repoCurr = new CurrenciesRepo(); this._repoSupplier = new SupplierRepo(); this._repoBT = new BussinessTypeRepo(); this._repoMaker = new MakerRepo(); this._repoMill = new MillRepo(); this._repoCmdt = new Commodity(); this._repoSpec = new SpecRepo(); this._repoCoating = new CoatingRepo(); this._repoWhse = new WharehouseRepo(); this._repoPort = new ImportPortRepo(); this._repoCust = new CustomerRepo(); this._repoLookup = new LookupRepo(); this.SourceStr = ""; epiSession = _session; if (model == null || epiSession == null) { this.HeadContent = new StoreInPlanHead(); this.IMEXReviewFlag = false; } else { this.HeadContent = model; this.IMEXReviewFlag = true; } this.ModelClone = new StoreInPlanHead(); this.POTrans = new POLineModel(); }
public PackingOrder(SessionInfo _session = null, PackingOrderModel model = null) { InitializeComponent(); epiSession = _session; this._repo = new PackingOrderRepo(); this.HeaderContent = new PackingOrderModel(); }
public ProductionPlan(SessionInfo _session, ProductionPlanModel model = null) { InitializeComponent(); this._repo = new ProductionPlanRepo(); this.domain = new ProductionPlanModel(); epiSession = _session; }
public SimulateEntry(SessionInfo _session = null, PlanningHeadModel model = null, SimulateActionModel simModel = null) { InitializeComponent(); this._repo = new WorkEntryRepo(); HeadModel = model; SimModel = simModel; epiSession = _session; }
public StoreInBalance(SessionInfo _session = null, StoreInPlanDialogModel model = null) { InitializeComponent(); this._repoPln = new StoreInPlanRepo(); this._repo = new StoreInRepo(); this.StoreInPlanBln = new List<StoreInPlanDialogModel>(); this.FilterData = model; }
public OrderHeadDialog(SessionInfo _session, IEnumerable<OrderHeadModel> model) { InitializeComponent(); _repo = new SaleOrderRepo(); _selected = new OrderHeadModel(); list = model; epiSession = _session; }
public DieMaster(SessionInfo _session, DieModel model = null) { InitializeComponent(); this._repo = new DieMasterRepo(); epiSession = _session; //epiSession = _session; DieHeader = model; }
public CoilBackRuleDialog(SessionInfo _session) { InitializeComponent(); this._repo = new CoilBackRuleRepo(); this.Code = ""; this.Description = ""; epiSession = _session; }
public SimulateReShear(SessionInfo _session = null, PlanningHeadModel model = null, SimulateReshearHeadModel data = null) { InitializeComponent(); this._repo = new WorkEntryRepo(); HeadModel = model; ReshearHead = data; epiSession = _session; }
public MCSSDashborad(SessionInfo _session = null, MCSS model = null) { InitializeComponent(); this._repo = new McssRepo(); this.McssList = new List<MCSS>(); this.McssNum = ""; epiSession = _session; }
public IEnumerable<MaterialFindingModel> SaveMaterial(SessionInfo _session, MaterialFindingModel model) { //int id = 0; string sql = string.Format(@"IF NOT EXISTS ( SELECT * FROM ucc_prd_MaterailTracker (NOLOCK) WHERE MaterialTransLineID = {1} ) BEGIN INSERT INTO ucc_prd_MaterailTracker (WorkOrderID ,MaterialTransLineID ,FoundFlag ,UnPackFlag ,ProcessFlag ,CreationDate ,LastUpdateDate ,CreatedBy ,UpdatedBy) VALUES ({0} --<WorkOrderID, bigint,> ,{1} --<MaterialTransLineID, bigint,> ,{2} --<FoundFlag, int,> ,{3} --<UnPackFlag, int,> ,{4} --<ProcessFlag, int,> ,GETDATE() --<CreationDate, datetime,> ,GETDATE() --<LastUpdateDate, datetime,> ,N'{5}' --<CreatedBy, varchar(45),> ,N'{5}' --<UpdatedBy, varchar(45),> ) END ELSE BEGIN UPDATE ucc_prd_MaterailTracker SET WorkOrderID = {0} --<WorkOrderID, bigint,> ,FoundFlag = {2} --<FoundFlag, int,> ,UnPackFlag = {3} --<UnPackFlag, int,> ,ProcessFlag = {4} --<ProcessFlag, int,> ,LastUpdateDate = GETDATE() --<LastUpdateDate, datetime,> ,UpdatedBy = N'{5}' --<UpdatedBy, varchar(45),> WHERE MaterialTransLineID = {1} --<Search Conditions,,> END" + Environment.NewLine , model.WorkOrderID , model.TransactionLineID , Convert.ToInt32(model.FoundFlag.GetBoolean()) , Convert.ToInt32(model.UnPackFlag.GetBoolean()) , Convert.ToInt32(model.ProcessFlag.GetBoolean()) , _session.UserID ); //Update PartLot.CheckBox01 = 1 to change status has already used. // sql += string.Format(@"UPDATE PartLot SET CheckBox01 = 1, ShortChar05 = N'{2}', Date03 = CONVERT(DATETIME, '{3}',103), Number08 = 2 // WHERE PartNum = N'{0}' AND LotNum = N'{1}'" // , model.MCSSNo, model.SerialNo, model.WorkOrderNum, model.WorkDate.ToString("dd/MM/yyyy hh:mm:ss")); Repository.Instance.ExecuteWithTransaction(sql, "Save Material"); return GetAllMaterailTracker(_session.PlantID); }
public SerialList(SessionInfo _session = null, IEnumerable<GeneratedSerialModel> model = null, PlanningHeadModel head = null) { InitializeComponent(); this._repo = new WorkEntryRepo(); epiSession = _session; snList = model; workParent = head; GenSNComplete = true; }
public MaterialSelecting(SessionInfo _session, IEnumerable<MaterialModel> data, PlanningHeadModel workOrder) { InitializeComponent(); this._repo = new WorkEntryRepo(); epiSession = _session; this.model = data; this._selected = new MaterialModel(); this.baseOrder = workOrder; }
public DiePatternMaster(SessionInfo _session, DiePatternModel model = null) { InitializeComponent(); this._repo = new DieMasterRepo(); this.PatternPara = ""; this.StorePerPcsPara = ""; this.RemarkPara = ""; epiSession = _session; }
public OrderLineDialog(SessionInfo _session, IEnumerable<OrderDetailModel> model) { InitializeComponent(); _repo = new SaleOrderRepo(); _selected = new OrderDetailModel(); this.listAll = new List<OrderDetailModel>(); listAll = model; epiSession = _session; }
public StoreInPlanDialog(SessionInfo _session, IList<StoreInPlanDialogModel> param = null)//, int Status = 2, string TransType = "") { InitializeComponent(); this._repo = new StoreInPlanRepo(); this.HeadContent = new StoreInPlanDialogModel(); this.list = param; epiSession = _session; //this.status = Status; //this.Type = TransType; }
public IEnumerable<WorkOrderPlanModel> GetWorksPlan(SessionInfo _session) { string sql = @"SELECT 0 as Seq, uf.Name as PICName, busi.Character01 as BussinessTypeName, plh.* FROM ucc_pln_PlanHead plh (NOLOCK) LEFT JOIN UserFile uf ON(plh.PIC = uf.DcdUserID) LEFT JOIN UD25 busi ON(plh.BT = busi.Key1) WHERE OpenFlag = 1"; var result = Repository.Instance.GetMany<WorkOrderPlanModel>(sql); return result; }
public ReceiveArticleDialog(StoreInPlanDetail model, SessionInfo _session, int LineReceive, decimal WeightReceive) { InitializeComponent(); this._repo = new StoreInPlanRepo(); this.ArticleList = new List<StoreInPlanDetail>(); this.lineNum = model; this.numofline = LineReceive; this.WeightRcv = WeightReceive; this.DataFlag = false; epiSession = _session; }
public Progression(string moduleName, decimal tranactionID, SessionInfo session, int possession) { InitializeComponent(); this._repoPlan = new StoreInPlanRepo(); this._repo = new StoreInRepo(); this._session = session; this.Possession = possession; this.TransactionID = tranactionID; timer1.Enabled = false; }
public WorkEntryDialog(SessionInfo _session, IEnumerable<PlanningHeadModel> param = null) { InitializeComponent(); this._repo = new WorkEntryRepo(); this._repoRes = new ResourceRepo(); this._repoUcd = new UserCodeRepo(); this._model = param; //this.PatternPara = ""; //this.StorePerPcsPara = ""; //this.RemarkPara = ""; epiSession = _session; }
public ProductionPlanModel Get(SessionInfo _session) { ProductionPlanModel model = new ProductionPlanModel(); model.WorkDateFrom = DateTime.Now; model.WorkDateTo = DateTime.Now; model.DueDateFrom = DateTime.Now; model.DueDateTo = DateTime.Now; model.Resources = _repoResrc.GetAll(_session.PlantID).ToList(); model.WorkOrders = GetWorksPlan(_session).ToList(); return model; }
public CultureInfo cul; //declare culture info public BaseSession() { if (Thread.CurrentThread.CurrentCulture.Name == "th-TH") { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); } res_man = new ResourceManager("Epicoil.Appl.Resources.Res", typeof(BaseSession).Assembly); epiSession = new SessionInfo(); //Set default theme. initail.UseTheme(this); }
public MaterialTracker(SessionInfo _session = null, string str = null) { InitializeComponent(); epiSession = _session; _repoWork = new WorkEntryRepo(); _repo = new MaterialFindingRepo(); _repoResrc = new ResourceRepo(); _repoUcode = new UserCodeRepo(); list = new List<MaterialFindingModel>(); possessionList = new List<UserCodeModel>(); resourceList = new List<ResourceModel>(); modelFilter = new MaterialFindingModel(); }
public StoreIn(SessionInfo _session = null, StoreInHead model = null) { InitializeComponent(); this._repoPlan = new StoreInPlanRepo(); this._repo = new StoreInRepo(); this._repoWhse = new WharehouseRepo(); //Initial Session and content this.HeadContent = new StoreInHead(); epiSession = _session; if (model != null) this.HeadContent = model; this.ModelClone = new StoreInHead(); HeadContent.InsertState = false; }
public IEnumerable<DieModel> Save(DieModel data, SessionInfo epiSession) { try { Session currSession = new Session(epiSession.UserID, epiSession.UserPassword, epiSession.AppServer, Session.LicenseType.Default); UD107 myUD107 = new UD107(currSession.ConnectionPool); UD107DataSet dsUD107 = new UD107DataSet(); string whereClause = string.Format(@"UD107.Key1 ='{0}' AND UD107.Key5 = '{1}'", data.DieCode, epiSession.PlantID); bool morePages = false; bool dataExisting = false; try { UD107DataSet ds = myUD107.GetByID(data.DieCode, "", "", "", epiSession.PlantID); dataExisting = true; } catch (Exception ex) { if (ex.Message == "Record not found.") dataExisting = false; } if (dataExisting) { dsUD107 = myUD107.GetRows(whereClause, "", "", 0, 1, out morePages); } else { myUD107.GetaNewUD107(dsUD107); } DataRow drUD107 = dsUD107.Tables[0].Rows[0]; drUD107.BeginEdit(); drUD107["Key1"] = data.DieCode; drUD107["Key5"] = epiSession.PlantID; drUD107["Character01"] = data.DieName; drUD107["Character02"] = string.IsNullOrEmpty(data.DieRemark) ? "" : data.DieRemark; drUD107["ShortChar01"] = string.IsNullOrEmpty(data.PatternID) ? "" : data.PatternID; drUD107.EndEdit(); myUD107.Update(dsUD107); currSession.Dispose(); return GetDieAll(epiSession.PlantID); } catch (Exception ex) { return null; } }
public ProductionSlitter(SessionInfo _session = null, ProductionHeadModel model = null) { InitializeComponent(); epiSession = _session; this._repo = new ProductionRepo(); this._repoPlan = new WorkEntryRepo(); this._repoRes = new ResourceRepo(); this._repoUcd = new UserCodeRepo(); HeaderContent = new ProductionHeadModel(); cuttingList = new Dictionary<int, string>(); pauseFlag = false; if (model != null) { this.HeaderContent = model; } }
public McssMaster(MCSS model = null, SessionInfo _session = null) { InitializeComponent(); this._repo = new McssRepo(); this._repoCustomer = new CustomerRepo(); this._repoCoating = new CoatingRepo(); this._repoSpec = new SpecRepo(); this._repoCommodity = new Commodity(); this._repoSupplier = new SupplierRepo(); this._repoBT = new BussinessTypeRepo(); this._repoMaker = new MakerRepo(); this._repoMill = new MillRepo(); this._repoCatg = new CategoryGroupRepo(); specialRef = new Dictionary<int, string>(); #region Dashboard if (model == null) { this.McssContent = new MCSS(); this.ModelClone = new MCSS(); this.Initail = new InitialModel(); } else { this.McssContent = model; ModelClone = (MCSS)model.Clone(); } epiSession = _session; #endregion #region Direct form //epiSession = new SessionInfo(); //if (epiSession.SessionID == null) //{ // Login frm = new Login(); // frm.ShowDialog(); //} //else if (epiSession.SessionID == "x") //{ // Application.Exit(); //} //else //{ // this.Text = epiSession.CompanyName; //} #endregion }
public WorkEntry(SessionInfo _session = null, PlanningHeadModel model = null) { InitializeComponent(); this._repoRes = new ResourceRepo(); this._repoUcd = new UserCodeRepo(); this._repo = new WorkEntryRepo(); this._reRes = new ResourceRepo(); this._repoSale = new SaleOrderRepo(); this._repoCls = new ClassMasterRepo(); this.HeaderContent = new PlanningHeadModel(); this._class = new ClassMasterModel(); //Initial Session and content this.HeaderContent = new PlanningHeadModel(); epiSession = _session; if (model != null) { this.HeaderContent = model; } }
public bool ClearSerialInEpicor(SessionInfo _session, PlanningHeadModel model, out string msg) { msg = string.Empty; bool IsSuccess = true; string sql = string.Empty; Session currSession = null; var resultContinue = GetSerialAllByWorkOrder(model.WorkOrderID).ToList(); try { currSession = new Session(_session.UserID, _session.UserPassword, _session.AppServer, Session.LicenseType.Default); } catch (Exception ex) { msg = ex.Message; IsSuccess = false; } foreach (var item in resultContinue) { try { LotSelectUpdate lotPart = new LotSelectUpdate(currSession.ConnectionPool); lotPart.DeleteByID(string.IsNullOrEmpty(item.NORNum) ? item.MCSSNo : item.NORNum, item.SerialNo); } catch (Exception ex) { msg = ex.Message; IsSuccess = false; } //TODO : There are has one more case for delete S/N. sql += string.Format(@"DELETE FROM ucc_pln_SerialGenerated WHERE WorkOrderID = {0} AND SerialNo = '{1}' {2}{3}{4}" , item.WorkOrderID, item.SerialNo, Environment.NewLine, "", Environment.NewLine); } sql += string.Format(@"UPDATE ucc_pln_PlanHead SET GenSerialFlag = 0 WHERE WorkOrderID = {0} ", model.WorkOrderID); Repository.Instance.ExecuteWithTransaction(sql, "Delete Serial"); return IsSuccess; }
public NorDialog(SessionInfo _epiSession, IEnumerable<ProductsMasterModel> data) { InitializeComponent(); epiSession = _epiSession; _model = data; }