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