public static List <string> Get_Line_List()
{
List <string> LsLine = new List <string>();
DataTable dt = ReleaseData.arrByteToDataTable(refWebtLineInfo.Instance.GetAllLineInfo());
DataTable dttemp = Function.DataTableToSort(dt, dt.Columns[0].ColumnName);
foreach (DataRow dr in dttemp.Rows)
{
LsLine.Add(dr[0].ToString());
}
return(LsLine);
}
private void tb_wo_KeyDown(object sender, KeyEventArgs e)
{
if (!string.IsNullOrEmpty(tb_wo.Text) && e.KeyCode == Keys.Enter)
{
DataTable dtNoCloseCtn = ReleaseData.arrByteToDataTable(refWebtPalletInfo.Instance.Get_Pallet_Info_bywo(tb_wo.Text, 1, 0));
this.lv_Carton.Items.Clear();
int x = 1;
foreach (DataRow dr in dtNoCloseCtn.Rows)
{
ListViewItem lvi = new ListViewItem();
this.lv_Carton.View = System.Windows.Forms.View.Details;
lvi.SubItems[0].Text = x++.ToString();
lvi.SubItems.AddRange(new string[] { dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[6].ToString(), dr[7].ToString() });
this.lv_Carton.Items.Add(lvi);
lv_Carton.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
tb_wo.SelectAll();
}
}
public static DataTable Get_All_Station()
{
DataTable dt = ReleaseData.arrByteToDataTable(refWebtCraftInfo.Instance.GetAllCraftInfo());
DataTable temp = null;
if (dt.Rows.Count > 0)
{
temp = Function.getNewTable(dt, string.Format("TESTFLAG='{0}'", "0"));
}
DataTable dtLine = new DataTable();
dtLine.Columns.Add("SECTION", typeof(string));
dtLine.Columns.Add("GROUP", typeof(string));
dtLine.Columns.Add("STATION", typeof(string));
foreach (DataRow dr in temp.Rows)
{
dtLine.Rows.Add(dr["BEWORKSEG"].ToString(), dr["CRAFTNAME"].ToString(), dr["CRAFTPARAMETERURL"].ToString());
}
return(Function.DataTableToSort(dtLine, "GROUP"));
}
private void imbt_OK_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txt_data.Text))
{
string _Colnum = string.Empty;
if (radESN.Checked)
{
_Colnum = "ESN";
}
if (radSN.Checked)
{
_Colnum = "SN";
}
if (radIMEI.Checked)
{
_Colnum = "IMEI";
}
if (radCarton.Checked)
{
_Colnum = "CARTONNUMBER";
}
DataTable dt = ReleaseData.arrByteToDataTable(refWebtWipTracking.Instance.GetQueryWipAllInfo(_Colnum, txt_data.Text));
if (dt.Rows.Count > 0)
{
mFrm.Close_Carton(dt.Rows[0]["CARTONNUMBER"].ToString());
// mFrm.PrintCartonLabel_CodeSoft(dt.Rows[0]["CARTONNUMBER"].ToString());
txt_data.Text = string.Empty;
txt_data.Focus();
MessageBox.Show("This Carton Already Closed");
}
else
{
txt_data.SelectAll();
MessageBox.Show("NO DATA");
}
}
}
public static DataTable Get_User_Info(string EMP_NO, string EMP_PWD)
{//.GetJurUserInfoByIdandpwd(EMP_NO,EMP_PWD)
return(ReleaseData.arrByteToDataTable(refWebtUserInfo.Instance.GetUserInfo(EMP_NO, null, EMP_PWD)));
}
