コード例 #1
0
        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);
        }
コード例 #2
0
ファイル: Frm_NoCloseCtn.cs プロジェクト: fengyubox/SFIS
 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();
     }
 }
コード例 #3
0
        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"));
        }
コード例 #4
0
ファイル: Frm_CloseCarton.cs プロジェクト: fengyubox/SFIS
 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");
         }
     }
 }
コード例 #5
0
 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)));
 }