public static ValueListItem[] GetValueList_Customer_All()
{
List<ValueListItem> lstVL = new List<ValueListItem>();
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>() { };
List<tmdlcustomer> lstCustomer = client.GetCustomerList((new BaseForm()).CurrentContextInfo,
lstParameters.ToArray<MESParameterInfo>()).ToList();
var q = from p in lstCustomer orderby p.customername ascending select p;
for (int i = 0; i < q.Count(); i++)
{
ValueListItem item = new ValueListItem()
{
DisplayText = q.ElementAt(i).customername,
DataValue = q.ElementAt(i).customerid
};
lstVL.Add(item);
}
return lstVL.ToArray<ValueListItem>();
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public void ShowEmployeeList()
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
DataSet employeeDs = client.GetEmployeeRecords(baseForm.CurrentContextInfo, QueryParameters.ToArray<MESParameterInfo>());
this.gridEmployeeList.SetDataBinding( employeeDs.Tables[0],"");
if (employeeDs.Tables[0].Rows.Count < 1)
{
this.ucToolbarEmployeeList.SetToolbarWithoutRows();
}
else
{
this.ucToolbarEmployeeList.SetToolbarWithRows();
}
this.ucStatusBarEmployeeList.ShowText1(UtilCulture.GetString("Msg.R00006") + ": " + employeeDs.Tables[0].Rows.Count.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
public void DoDelete()
{
if (this.grdQuery.ActiveRow == null) return;
DialogResult result = baseForm.CreateMessageBox(Public_MessageBox.Question,
MessageBoxButtons.OKCancel,
UtilCulture.GetString("Msg.R00004"),
"<span style='font-weight:bold;'>" + UtilCulture.GetString("Label.R01018") + ": </span> " +
this.grdQuery.ActiveRow.Cells["workgroup"].Value.ToString());
if (result == DialogResult.Cancel) return;
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>() {
new MESParameterInfo(){
ParamName="workgroup",
ParamValue=this.grdQuery.ActiveRow.Cells["workgroup"].Value.ToString(),
ParamType="string"
}
};
client.DoDeleteWorkGroup(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
MESMsgBox.ShowInformation(UtilCulture.GetString("Msg.R00003"));
GetData(QueryParameters);
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
public void DoDelete()
{
if (this.grdQuery.ActiveRow == null) return;
DialogResult result = baseForm.CreateMessageBox(Public_MessageBox.Question,
MessageBoxButtons.OKCancel,
UtilCulture.GetString("Msg.R00004"),
"" + UtilCulture.GetString("Label.R00705") + ": "
+ this.grdQuery.ActiveRow.Cells["fromcurrency"].Value.ToString() + "->" + this.grdQuery.ActiveRow.Cells["tocurrency"].Value.ToString());
if (result == DialogResult.Cancel) return;
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>() {
new MESParameterInfo(){
ParamName="exsysid",
ParamValue=this.grdQuery.ActiveRow.Cells["exsysid"].Value.ToString(),
ParamType="string"
}
};
client.DoDeleteExchange(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
baseForm.CreateMessageBox(Public_MessageBox.Information, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00003"));
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
private void DeleteShift()
{
if (this.gridShiftList.ActiveRow != null)
{
Dictionary<string, object> dir = new Dictionary<string, object>();
dir.Add(UtilCulture.GetString("Label.R00394"), this.gridShiftList.ActiveRow.Cells["SHIFT"].Value.ToString());
DialogResult result = baseForm.CreateMessageBox(Public_MessageBox.Question,
MessageBoxButtons.OKCancel,
UtilCulture.GetString("Msg.R00004"),
dir);
if (result == DialogResult.OK)
{
baseForm.SetCursor();
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "shift",
ParamValue = this.gridShiftList.ActiveRow.Cells["SHIFT"].Value.ToString(),
ParamType = "string"
});
client.DoDeleteShift(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
ShowShiftList();
baseForm.CreateMessageBox(Public_MessageBox.Information, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00003"));
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
}
}
public static void InitCMB_Shift_All(UltraComboEditor cmb)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
cmb.DataSource = client.GetShiftRecords((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).Tables[0];
cmb.DisplayMember = "shiftname";
cmb.ValueMember = "shift";
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_Shift_All(ComboBox cmb)
{
cmb.Items.Clear();
cmb.DisplayMember = "DisplayField";
cmb.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
List<tmdlshift> lstShift = client.GetShiftList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlshift>();
var q = (from p in lstShift
orderby p.shift ascending
select p);
foreach (tmdlshift sf in q)
{
cmb.Items.Add(new ValueInfo()
{
DisplayField = sf.shiftname,
ValueField = sf.shift
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_ReasonCode_ByCategoryStep(ComboBox cmd,
MES_ReasonCategory reasonCategory, string stepsysid)
{
cmd.Items.Clear();
cmd.DisplayMember = "DisplayField";
cmd.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<tmdlreasoncode> lstReasonCode = client.GetReasonCodeList_ByCategoryStep(
(new BaseForm()).CurrentContextInfo, reasonCategory.ToString(), stepsysid).ToList<tmdlreasoncode>();
var q = from p in lstReasonCode orderby p.reasoncodedesc ascending select p;
for (int i = 0; i < q.Count(); i++)
{
cmd.Items.Add(new ValueInfo()
{
DisplayField = q.ElementAt(i).reasoncodedesc,
ValueField = q.ElementAt(i).reasoncode
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_ReasonCategory_All(ComboBox cmd)
{
cmd.Items.Clear();
cmd.DisplayMember = "DisplayField";
cmd.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
List<tmdlreasoncategory> lstReasonCategory = client.GetReasonCategoryList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlreasoncategory>();
var q = from p in lstReasonCategory orderby p.reasoncategory ascending select p;
for (int i = 0; i < q.Count(); i++)
{
cmd.Items.Add(new ValueInfo()
{
DisplayField = q.ElementAt(i).reasoncategory,
ValueField = q.ElementAt(i).reasoncategory
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static ValueListItem[] GetValueList_Employee(string employeeType)
{
List<ValueListItem> lstVL = new List<ValueListItem>();
ValueListItem emptyitem = new ValueListItem()
{
DisplayText = " ",
DataValue = ""
};
lstVL.Add(emptyitem);
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "employeetypeid",
ParamValue = employeeType,
ParamType = "string"
});
List<tmdlemployee> lstEmployee = client.GetEmployeeList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlemployee>();
for (int i = 0; i < lstEmployee.Count; i++)
{
ValueListItem item = new ValueListItem()
{
DisplayText = lstEmployee[i].employeename.Trim(),
DataValue = lstEmployee[i].employeeid
};
lstVL.Add(item);
}
return lstVL.ToArray<ValueListItem>();
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_ReasonCode_ByCategory(ComboBox cmd, MES_ReasonCategory reasonCategory)
{
cmd.Items.Clear();
cmd.DisplayMember = "DisplayField";
cmd.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "reasoncategory",
ParamValue = reasonCategory.ToString()
});
List<tmdlreasoncode> lstReasonCode = client.GetReasonCodeList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlreasoncode>();
for (int i = 0; i < lstReasonCode.Count; i++)
{
cmd.Items.Add(new ValueInfo()
{
DisplayField = lstReasonCode[i].reasoncodedesc,
ValueField = lstReasonCode[i].reasoncode
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void UpdateCustomer(tmdlcustomer _customer, List<tmdlcontact> lstContact)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
client.DoUpdateCustomer(baseForm.CurrentContextInfo, _customer, lstContact.ToArray());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private DataSet GetAllCustomer()
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
DataSet ds = null;
try
{
baseForm.SetCursor();
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
ds = client.GetCustomerRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
return ds;
}
public static ValueListItem[] GetValueList_Employee()
{
List<ValueListItem> lstVL = new List<ValueListItem>();
ValueListItem emptyitem = new ValueListItem()
{
DisplayText = " ",
DataValue = ""
};
lstVL.Add(emptyitem);
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
//lstParameters.Add(new MESParameterInfo()
//{
// ParamName = "employeestatus",
// ParamValue = MES_Flag.Valid.ToString(),
// ParamType = "string"
//});
List<tmdlemployee> lstEmployee = client.GetEmployeeList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlemployee>();
var q = from p in lstEmployee orderby p.employeename ascending select p;
for (int i = 0; i < q.Count(); i++)
{
ValueListItem item = new ValueListItem()
{
DisplayText = q.ElementAt(i).employeename.Trim(),
DataValue = q.ElementAt(i).employeeid
};
lstVL.Add(item);
}
return lstVL.ToArray<ValueListItem>();
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void DoLogon()
{
wsSEC.IwsSECClient client = new wsSEC.IwsSECClient();
wsMDL.IwsMDLClient clientMDL = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
baseForm.ValidateData(this);
if (this.chkLogonToBasis.Checked)
baseForm.CurrentContextInfo.MiscValue1 = "Modeling";
else
baseForm.CurrentContextInfo.MiscValue1 = "WIP Client";
client.Logon(baseForm.CurrentContextInfo, this.cmbUser.Text, UtilSecurity.EncryptPassword(txtPassword.Text));
#region Set public variables
Parameter.LOGON_USER = this.cmbUser.Text.Trim();
Parameter.SHIFT = (this.cmbShift.SelectedItem as ValueInfo).ValueField;
Parameter.SESSION_ID = GENLSYS.MES.Common.Function.GetGUID();
Parameter.LANGUAGE = (this.cmbLanguage.SelectedItem as ValueInfo).ValueField;
// Parameter.WORKGROUP = "G1";//getWorkGroupByIP
InitResourceFile(Parameter.LANGUAGE);
string machine = Dns.GetHostName();
baseForm.CurrentContextInfo.SessionId = Parameter.SESSION_ID;
baseForm.CurrentContextInfo.CurrentUser = Parameter.LOGON_USER;
baseForm.CurrentContextInfo.WorkGroup = Parameter.WORKGROUP;
client.UpdateLogonTime(baseForm.CurrentContextInfo, Parameter.SESSION_ID, this.cmbUser.Text, machine, Parameter.SHIFT);
//get authorization
Parameter.ALL_FUNCTIONS = client.GetFunctionsRecords(baseForm.CurrentContextInfo,
(new List<MESParameterInfo>()).ToArray<MESParameterInfo>()).Tables[0];
Parameter.USER_FUNCTIONS = client.GetFunctionsByUserId(baseForm.CurrentContextInfo,
Parameter.LOGON_USER).Tables[0];
//get user object
List<tsecuser> lstUser = client.GetUserList(baseForm.CurrentContextInfo,
new List<MESParameterInfo>() {
new MESParameterInfo(){
ParamName ="userid",
ParamValue=Parameter.LOGON_USER
}
}.ToArray<MESParameterInfo>()).ToList<tsecuser>();
if (lstUser.Count > 0)
{
Parameter.CURRENT_USER_OBJECT = lstUser[0];
}
//get employee object
List<tmdlemployee> lstEmployee = clientMDL.GetEmployeeList(baseForm.CurrentContextInfo,
new List<MESParameterInfo>() {
new MESParameterInfo(){
ParamName ="employeeid",
ParamValue=lstUser[0].employeeid
}
}.ToArray()).ToList();
// if (lstEmployee.Count > 0)
// {
// Parameter.WORKGROUP = lstEmployee[0].workgroup;
// baseForm.CurrentContextInfo.WorkGroup = Parameter.WORKGROUP;
// }
//get system config
if (Parameter.CURRENT_SYSTEM_CONFIG == null)
{
Parameter.CURRENT_SYSTEM_CONFIG = baseForm.GetAllSystemConfig();
baseForm.SetParameter();
}
//get static value
if (Parameter.CURRENT_STATIC_VALUE == null)
Parameter.CURRENT_STATIC_VALUE = baseForm.GetAllStaticValue();
//set host name as work group
string host = Dns.GetHostName();
string lineGroup = "unknow";
foreach (tsysstaticvalue item in baseForm.GetStaticValue(MES_StaticValue_Type.LineGroup))
{
if (item.svtext == host)
{
lineGroup = item.svvalue;
break;
}
}
Parameter.WORKGROUP = lineGroup;
baseForm.CurrentContextInfo.WorkGroup = Parameter.WORKGROUP;
//update user profile
UpdateUserProfile();
#endregion
ShowModeling(false);
Parameter.LOGON_FORM = this;
this.Hide();
}
catch (Exception ex)
{
switch (ExceptionParser.Parse(ex))
{
case "-300001":
errorCount++;
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00011"));
break;
case "-300002":
errorCount++;
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00012"));
break;
case "-300003":
errorCount++;
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00013"));
break;
case "-300004":
errorCount++;
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00014"));
break;
case "-300005":
errorCount++;
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00046"));
break;
default:
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, ExceptionParser.Parse(ex));
break;
}
if (errorCount >= 5)
{
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00122"));
this.Dispose();
}
}
finally
{
baseForm.ResetCursor();
if (client.State == System.ServiceModel.CommunicationState.Opened)
baseForm.CloseWCF(client);
}
}
private void GetReasonCode()
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "reasoncategory",
ParamValue = "%" + MES_ReasonCategory.Repair.ToString() + "%",
ParamType = "string"
});
DataTable dt = client.GetReasonCodeRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).Tables[0];
DataView dv = dt.DefaultView;
dv.RowFilter = "reasoncategory LIKE '%全检%'";
dv.Sort = "reasoncategorydesc asc";
dt = dv.ToTable();
int categoryIndex = 0;
string beforecategory = "";
if (dt != null)
{
dt.Columns.Add(new DataColumn("ck", typeof(string)));
dt.Columns.Add(new DataColumn("pairqty", typeof(int)));
dt.Columns.Add(new DataColumn("remark", typeof(string)));
dt.Columns.Add(new DataColumn("categoryindex", typeof(int)));
foreach (DataRow row in dt.Rows)
{
if (!row["reasoncategorydesc"].ToString().Equals(beforecategory))
{
beforecategory = row["reasoncategorydesc"].ToString();
categoryIndex++;
}
row["ck"] = "N";
row["pairqty"] = 0;
row["remark"] = "";
row["categoryindex"] = categoryIndex;
}
this.grdDetail.SetDataBinding(dt, "");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void UpdateEmployeeType(tmdlemployeetype _employeetype)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
client.DoUpdateEmployeeType(baseForm.CurrentContextInfo, _employeetype);
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private tmdlemployeetype GetSingleEmployeeType(string _employeeTypeId)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
tmdlemployeetype result = null;
try
{
baseForm.SetCursor();
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "employeetypeid",
ParamValue = _employeeTypeId,
ParamType = "string"
});
result = client.GetSingleEmployeeType(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
return result;
}
public static void InitCMB_WorkGroup(ComboBox cmb)
{
cmb.Items.Clear();
cmb.DisplayMember = "DisplayField";
cmb.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
List<tmdlworkgroup> lstShift = client.GetWorkGroupList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlworkgroup>();
var q = from p in lstShift orderby p.workgroupdesc ascending select p;
foreach (tmdlworkgroup workgroup in q)
{
cmb.Items.Add(new ValueInfo()
{
DisplayField = workgroup.workgroupdesc,
ValueField = workgroup.workgroup
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void GetData(List<MESParameterInfo> lstParameters)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
DataSet ds = client.GetWorkGroupRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
this.grdQuery.SetDataBinding(ds.Tables[0], "");
if (this.grdQuery.Rows.Count < 1)
{
this.ucToolbar1.SetToolbarWithoutRows();
}
else
{
this.ucToolbar1.SetToolbarWithRows();
}
this.ucStatusBar1.ShowText1(UtilCulture.GetString("Msg.R00006") + ": " + ds.Tables[0].Rows.Count.ToString());
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
public static ValueListItem[] GetValueList_ReasonCode(MES_ReasonCategory reasonCategory)
{
List<ValueListItem> lstVL = new List<ValueListItem>();
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo() {
ParamName="reasoncategory",
ParamValue=reasonCategory.ToString()
});
List<tmdlreasoncode> lstReasonCode = client.GetReasonCodeList((new BaseForm()).CurrentContextInfo,
lstParameters.ToArray<MESParameterInfo>()).ToList();
var q = from p in lstReasonCode orderby p.reasoncodedesc ascending select p;
for (int i = 0; i < q.Count(); i++)
{
ValueListItem item = new ValueListItem()
{
DisplayText = q.ElementAt(i).reasoncodedesc,
DataValue = q.ElementAt(i).reasoncode
};
lstVL.Add(item);
}
return lstVL.ToArray<ValueListItem>();
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void GetContactList(List<MESParameterInfo> lstParameters)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
baseForm.SetCursor();
DataSet ds = client.GetContactRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
this.grdContact.SetDataBinding(ds.Tables[0], "");
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
}
private DataSet GetWorkGroupRecordsByStep(string step)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
DataSet ds = null;
try
{
baseForm.SetCursor();
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "step",
ParamValue = step,
ParamType = "string"
});
ds = client.GetWorkGroupRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>());
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
return ds;
}
private DataTable GetWorkGroup()
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
DataTable dt = null;
try
{
dt = client.GetWorkGroupRecords(baseForm.CurrentContextInfo, (new List<MESParameterInfo>()).ToArray<MESParameterInfo>()).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
return dt;
}
private DataTable GetReasonCodeDataTable()
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "reasoncategory",
ParamValue = "%" + MES_ReasonCategory.Repair.ToString() + "%",
ParamType = "string"
});
return client.GetReasonCodeRecords(baseForm.CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_Customer_All(ComboBox cmb)
{
cmb.Items.Clear();
cmb.DisplayMember = "DisplayField";
cmb.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
List<tmdlcustomer> lstCustomer = client.GetCustomerList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlcustomer>();
for (int i = 0; i < lstCustomer.Count; i++)
{
cmb.Items.Add(new ValueInfo()
{
DisplayField = lstCustomer[i].customername,
ValueField = lstCustomer[i].customerid
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private DataTable GetValidExchange(DateTime date)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
DataTable dt = null;
try
{
dt = client.GetValidExchange(baseForm.CurrentContextInfo, date).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
return dt;
}
public static void InitCMB_EmployeeType_All(ComboBox cmb)
{
cmb.Items.Clear();
cmb.DisplayMember = "DisplayField";
cmb.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
List<tmdlemployeetype> lstemtype = client.GetEmployeeTypeList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlemployeetype>();
var q = from p in lstemtype orderby p.employeetypename ascending select p;
for (int i = 0; i < q.Count(); i++)
{
cmb.Items.Add(new ValueInfo()
{
DisplayField = q.ElementAt(i).employeetypename,
ValueField = q.ElementAt(i).employeetypeid
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
public static void InitCMB_Employee_Valid(ComboBox cmd)
{
cmd.Items.Clear();
cmd.DisplayMember = "DisplayField";
cmd.ValueMember = "ValueField";
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
List<MESParameterInfo> lstParameters = new List<MESParameterInfo>();
lstParameters.Add(new MESParameterInfo()
{
ParamName = "employeestatus",
ParamValue = MES_Flag.Valid.ToString(),
ParamType = "string"
});
List<tmdlemployee> lseEmployee = client.GetEmployeeList((new BaseForm()).CurrentContextInfo, lstParameters.ToArray<MESParameterInfo>()).ToList<tmdlemployee>();
var q = from p in lseEmployee orderby p.employeeid ascending select p;
for (int i = 0; i < q.Count(); i++)
{
cmd.Items.Add(new ValueInfo()
{
DisplayField = q.ElementAt(i).employeeid + "(" + q.ElementAt(i).employeename + ")",
ValueField = q.ElementAt(i).employeeid
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}
private void UpdateShift(tmdlshift _shift)
{
wsMDL.IwsMDLClient client = new wsMDL.IwsMDLClient();
try
{
client.DoUpdateShift(baseForm.CurrentContextInfo, _shift);
}
catch (Exception ex)
{
throw ex;
}
finally
{
baseForm.CloseWCF(client);
}
}