private void Authenticate() { WorkStationInfo ws = GetWorkstationID(); WorkStationInfo.CurrentStation = ws; if (ws == null) { MessageBox.Show(Resources.Resource1.FrmOfflineCardPaying_NotWorkStationID, Resources.Resource1.Form_Alert); Environment.Exit(0); } else { while (true) { Form login = new FrmLoginTool(); DialogResult result = login.ShowDialog(); if (result == DialogResult.OK) { break; } else if (result == DialogResult.Cancel) { Environment.Exit(0); } } } }
protected override bool DeletingItem(object item) { WorkStationInfo info = (WorkStationInfo)item; CommandResult result = bll.Delete(info); return(result.Result == ResultCode.Successful); }
/// <summary> /// 是否显示行 /// </summary> /// <param name="item"></param> /// <returns></returns> private bool ShowGridViewRow(DataGridViewRow row) { object item = row.Tag; if (_ShowAPMOnly) { if (!(item is APM)) { return(false); } } if (_ShowCenterOnly) { if (!(item is WorkStationInfo)) { return(false); } WorkStationInfo info = item as WorkStationInfo; if (!info.IsCenterCharge) { return(false); } } return(true); }
private void OnRefreshWorkStationInfo(WorkStationInfo info) { DispatcherHelper.CheckBeginInvokeOnUI(() => { WorkStationInfo = _mapper.Map <WorkStationInfo, WorkStationInfoDto>(info); }); }
private List <SqlParameter> Set_Values_In_Work_Station(WorkStationInfo work_Station) { List <SqlParameter> sqlparam = new List <SqlParameter>(); if (work_Station.Work_Station_Id != 0) { sqlparam.Add(new SqlParameter("@Work_Station_Id", work_Station.Work_Station_Id)); } sqlparam.Add(new SqlParameter("@Work_Center_Id", work_Station.Work_Center.Work_Center_Id)); //sqlparam.Add(new SqlParameter("@Work_Station_Id", work_Center.Work_Station_Id)); sqlparam.Add(new SqlParameter("@Work_Station_Code", work_Station.Work_Station_Code)); sqlparam.Add(new SqlParameter("@Machine_Name", work_Station.Machine_Name)); sqlparam.Add(new SqlParameter("@Machine_Properties", work_Station.Machine_Properties)); sqlparam.Add(new SqlParameter("@TPM_Speed", work_Station.TPM_Speed)); sqlparam.Add(new SqlParameter("@Average_Order_Length", work_Station.Average_Order_Length)); sqlparam.Add(new SqlParameter("@Capacity", work_Station.Capacity)); sqlparam.Add(new SqlParameter("@Wastage", work_Station.Wastage)); sqlparam.Add(new SqlParameter("@Target_Efficiency", work_Station.Target_Efficiency)); sqlparam.Add(new SqlParameter("@Under_Maintainance", work_Station.Under_Maintainance)); sqlparam.Add(new SqlParameter("@Is_Active", work_Station.Is_Active)); if (work_Station.Work_Station_Id == 0) { sqlparam.Add(new SqlParameter("@CreatedOn", work_Station.CreatedOn)); sqlparam.Add(new SqlParameter("@CreatedBy", work_Station.CreatedBy)); } sqlparam.Add(new SqlParameter("@UpdatedOn", work_Station.UpdatedOn)); sqlparam.Add(new SqlParameter("@UpdatedBy", work_Station.UpdatedBy)); return(sqlparam); }
public WorkStationInfo Get_Work_Stations_By_Work_Station_Id(int work_Station_Id) { WorkStationInfo work_Station = new WorkStationInfo(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Work_Station_Id", work_Station_Id)); DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Work_Stations_By_Work_Station_Id_Sp.ToString(), CommandType.StoredProcedure); DataTable dt = ds.Tables[0]; //DataTable dt1 = ds.Tables[1]; if (dt != null && dt.Rows.Count > 0) { List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { work_Station = Get_Work_Station_Values_By_Id(dr); } } return(work_Station); }
private WorkStationInfo Get_Work_Station_Values_By_Id(DataRow dr) { WorkStationInfo work_Station = new WorkStationInfo(); work_Station.Work_Station_Id = Convert.ToInt32(dr["Work_Station_Id"]); work_Station.Work_Center_Id = Convert.ToInt32(dr["Work_Center_Id"]); work_Station.Work_Station_Code = Convert.ToString(dr["Work_Station_Code"]); work_Station.Machine_Name = Convert.ToString(dr["Machine_Name"]); work_Station.Machine_Properties = Convert.ToString(dr["Machine_Properties"]); work_Station.TPM_Speed = Convert.ToInt32(dr["TPM_Speed"]); work_Station.Average_Order_Length = Convert.ToDecimal(dr["Average_Order_Length"]); work_Station.Capacity = Convert.ToString(dr["Capacity"]); work_Station.Wastage = Convert.ToInt32(dr["Wastage"]); work_Station.Target_Efficiency = Convert.ToInt32(dr["Target_Efficiency"]); work_Station.Under_Maintainance = Convert.ToBoolean(dr["Under_Maintainance"]); work_Station.Is_Active = Convert.ToBoolean(dr["Is_Active"]); work_Station.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]); work_Station.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); work_Station.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]); work_Station.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]); work_Station.Work_Center.Work_Center_Name = Convert.ToString(dr["Work_Center_Name"]); work_Station.Work_Center.Work_Center_Id = Convert.ToInt32(dr["Work_Center_Id"]); work_Station.Factory.Factory_Name = Convert.ToString(dr["Factory_Name"]); work_Station.Factory.Factory_Id = Convert.ToInt32(dr["Factory_Id"]); return(work_Station); }
protected override object GetItemFromInput() { WorkStationInfo info = null; if (IsAdding) { info = new WorkStationInfo(); info.StationID = txtName.Text.Trim(); } else { info = UpdatingItem as WorkStationInfo; } info.StationName = this.txtName.Text.Trim(); info.IsCenterCharge = chkCenterCharge.Checked; info.EntranceList = this.EntranceTree.SelectedEntranceIDs; if (comDeptList.Dept != null) { info.Dept = comDeptList.Dept; info.DeptID = comDeptList.SelectedDeptID; } else { info.Dept = null; info.DeptID = null; } return(info); }
private void lvWs_MouseDoubleClick(object sender, MouseEventArgs e) { if (lvWs.SelectedItems.Count > 0) { WorkStationInfo wsi = lvWs.SelectedItems[0].Tag as WorkStationInfo; CADRun(wsi); this.DialogResult = DialogResult.OK; } }
public void Update_Work_Station(WorkStationInfo work_Station) { _sqlRepo.ExecuteNonQuery(Set_Values_In_Work_Station(work_Station), StoredProcedures.Update_Work_Station_sp.ToString(), CommandType.StoredProcedure); if (!string.IsNullOrEmpty(work_Station.Process_Ids)) { Insert_Work_Station_Process(work_Station.Process_Ids, work_Station.Work_Station_Id); } }
/// <summary> /// 清除选择 /// </summary> private void ClearSelection() { foreach (DataGridViewRow row in GridView.Rows) { WorkStationInfo info = row.Tag as WorkStationInfo; DataGridViewCheckBoxCell c = row.Cells["colCheck"] as DataGridViewCheckBoxCell; c.Value = false; } }
protected override void ItemShowing() { WorkStationInfo info = (WorkStationInfo)UpdatingItem; this.txtName.Text = info.StationName; this.txtName.BackColor = Color.White; this.chkCenterCharge.Checked = info.IsCenterCharge; this.EntranceTree.SelectedEntranceIDs = info.EntranceList; this.Text = info.StationName; }
protected override void ShowItemInGridViewRow(DataGridViewRow row, object item) { WorkStationInfo info = item as WorkStationInfo; row.Tag = info; row.Cells["colWorkstationID"].Value = info.StationName; DataGridViewCheckBoxCell c = row.Cells["colCenterCharge"] as DataGridViewCheckBoxCell; c.Value = info.IsCenterCharge; }
private void ShowItemInGridViewRow(DataGridViewRow row, WorkStationInfo item) { WorkStationInfo info = item; row.Tag = info; row.Cells["colWorkstationID"].Value = info.StationName; DataGridViewCheckBoxCell c = row.Cells["colCenterCharge"] as DataGridViewCheckBoxCell; c.Value = info.IsCenterCharge; }
//是否在线 private bool IsOnline(WorkStationInfo info) { foreach (var ws in onlineWsList) { if (ws.WSId == info.WSId && !(ws.HostName == Dns.GetHostName())) { return(true); } } return(false); }
protected override CommandResult UpdateItem(object updatingItem) { WorkStationInfo info = updatingItem as WorkStationInfo; CommandResult result = bll.Update(info); if (result.Result == ResultCode.Successful && WorkStationInfo.CurrentStation.StationID == info.StationID) { WorkStationInfo.CurrentStation = info; } return(result); }
public CommandResult Delete(WorkStationInfo info) { if (info.CanDelete) { return(provider.Delete(info)); } else { throw new InvalidOperationException(string.Format(Resource1.WorkstationBll_CannotDelete, info.StationName)); } }
/// <summary> /// 选择所有 /// </summary> private void SelectAll() { foreach (DataGridViewRow row in GridView.Rows) { if (row.Visible) { WorkStationInfo info = row.Tag as WorkStationInfo; DataGridViewCheckBoxCell c = row.Cells["colCheck"] as DataGridViewCheckBoxCell; c.Value = true; } } }
protected override bool DeletingItem(object item) { WorkStationInfo info = (WorkStationInfo)item; CommandResult result = bll.Delete(info); if (result.Result == ResultCode.Successful && DataBaseConnectionsManager.Current.StandbyConnected) { WorkstationBll swbll = new WorkstationBll(AppSettings.CurrentSetting.CurrentStandbyConnect); swbll.Delete(info); } return(result.Result == ResultCode.Successful); }
protected override CommandResult AddItem(object addingItem) { WorkStationInfo info = (WorkStationInfo)addingItem; CommandResult result = bll.Insert((WorkStationInfo)addingItem); if (result.Result == ResultCode.Successful && DataBaseConnectionsManager.Current.StandbyConnected) { WorkstationBll swbll = new WorkstationBll(AppSettings.CurrentSetting.CurrentStandbyConnect); swbll.UpdateOrInsert(info); } return(result); }
public CommandResult Update(WorkStationInfo curVal) { WorkStationInfo original = GetWorkStationByID(curVal.StationID); if (original != null) { return(provider.Update(curVal, original)); } else { return(new CommandResult(ResultCode.NoRecord, ResultCodeDecription.GetDescription(ResultCode.NoRecord))); } }
public int Insert_Work_Station(WorkStationInfo work_Station) { int work_Station_Id = 0; work_Station_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Work_Station(work_Station), StoredProcedures.Insert_Work_Station_sp.ToString(), CommandType.StoredProcedure)); if (!string.IsNullOrEmpty(work_Station.Process_Ids)) { Insert_Work_Station_Process(work_Station.Process_Ids, work_Station_Id); } return(work_Station_Id); }
public CommandResult UpdateOrInsert(WorkStationInfo info) { WorkStationInfo original = provider.GetByID(info.StationID).QueryObject; if (original != null) { return(provider.Update(info, original)); } else { return(provider.Insert(info)); } }
private WorkStationInfo GetWorkstationID() { LDB_SysParaSettingsBll ssb = new LDB_SysParaSettingsBll(LDB_AppSettings.Current.LDBConnect); LDB_ParkingDataBuffer.Current = ssb.GetOrCreateSetting <LDB_ParkingDataBuffer>(); WorkStationInfo ws = null; string workstationID = AppSettings.CurrentSetting.WorkstationID; if (!string.IsNullOrEmpty(workstationID)) { ws = LDB_ParkingDataBuffer.Current.WorkStations.FirstOrDefault(w => w.StationID == workstationID); } return(ws); }
public WorkStationViewModel() { Work_Station = new WorkStationInfo(); Work_Stations = new List <WorkStationInfo>(); //Factories = new List<WorkStationInfo>(); //Work_Centers = new List<WorkStationInfo>(); Friendly_Message = new List <FriendlyMessageInfo>(); Pager = new PaginationInfo(); Filter = new Work_Station_Filter(); }
private string GetItemName(object item) { string name = string.Empty; if (item is WorkStationInfo) { WorkStationInfo info = item as WorkStationInfo; name = info.StationName; } else if (item is APM) { APM info = item as APM; name = info.SerialNum; } return(name); }
protected override CommandResult UpdateItem(object updatingItem) { WorkStationInfo info = updatingItem as WorkStationInfo; CommandResult result = bll.Update(info); if (result.Result == ResultCode.Successful && WorkStationInfo.CurrentStation.StationID == info.StationID) { WorkStationInfo.CurrentStation = info; if (DataBaseConnectionsManager.Current.StandbyConnected) { WorkstationBll swbll = new WorkstationBll(AppSettings.CurrentSetting.CurrentStandbyConnect); swbll.UpdateOrInsert(info); } } return(result); }
private void ShowSetting() { dataGridView1.Rows.Clear(); if (_VehicleLedSetting != null && _VehicleLedSetting.Items != null && _VehicleLedSetting.Items.Count > 0) { List <WorkStationInfo> stations = (new WorkstationBll(AppSettings.CurrentSetting.ParkConnect)).GetAllWorkstations().QueryObjects; foreach (VehicleLedItem item in _VehicleLedSetting.Items) { ParkInfo park = ParkBuffer.Current.GetPark(item.ParkID); EntranceInfo entrance = ParkBuffer.Current.GetEntrance(item.EntranceID); WorkStationInfo station = stations == null ? null : stations.FirstOrDefault(s => s.StationID == item.StationID); int row = dataGridView1.Rows.Add(); ShowItemOnRow(dataGridView1.Rows[row], item, park != null ? park.ParkName : string.Empty, entrance != null ? entrance.EntranceName : string.Empty, station != null ? station.StationName : string.Empty); if (chkOnlyStationLed.Checked) { dataGridView1.Rows[row].Visible = item != null && item.StationID == WorkStationInfo.CurrentStation.StationID; } } } }
public IHttpActionResult CreateWorkstation(WorkstationInfoModel model) { try { if (ModelState.IsValid) { var workstation = new WorkStationInfo(); workstation.HostName = model.HostName; workstation.DNSName = model.DNSName; workstation.SelectManufacturer = model.SelectManufacturer; workstation.SelectModel = model.SelectModel; workstation.SelectManufacturerPartNumber = model.SelectManufacturerPartNumber; workstation.SelectOS = model.SelectOS; workstation.SelectOSVersion = model.SelectOSVersion; workstation.SerialNumber = model.SerialNumber; workstation.InstallDate = model.InstallDate; workstation.WarrantyStarted = model.WarrantyStarted; workstation.WarrantyExpires = model.WarrantyExpires; workstation.SelectServerRoles = model.SelectServerRoles; workstation.Notes = model.Notes; workstation.SelectTag = model.SelectTag; workstation.SoftwareType = model.SoftwareType; workstation.SoftwareVersion = model.SoftwareVersion; workstation.LicenseKey = model.LicenseKey; workstation.ExpiresOn = model.ExpiresOn; workstation.CompanyId = model.CompanyId; db.WorkStationInfoes.Add(workstation); db.SaveChanges(); return(Ok(workstation)); } else { return(Ok("Please Enter All the mandatory Fields")); } } catch (Exception ex) { return(Ok("" + ex.Message + "")); } }
public CommandResult Insert(WorkStationInfo info) { return(provider.Insert(info)); }