Exemplo n.º 1
0
        public static void CheckSNperLoadedListandReloadifProblem(string SN, string POnumber)
        {
            POnumber = POnumber.PadLeft(12, '0');
            //do check SN đúng theo PO
            SP_Processing.MySqlConn mycon = new SP_Processing.MySqlConn(strSqlConnection4_608FFCPACKING);
            // DataTable dt= mycon.ExecSProcDS("ame_CheckSNDLSS", POnumber.PadLeft(12, '0')).Tables["Table"];
            string result = mycon.ExecSProcDS("ame_CheckSNvsTFFCCONTROL", SN.ToString(), POnumber.PadLeft(12, '0')).Tables["Table"].Rows[0][0].ToString().Trim();

            //if not, please load

            if ((result.Substring(0, 2) == "OK"))
            {
                //Order good
                MessageBox.Show("Load SN bình thường. No Action!");
            }
            else
            {
                DeleteSerialbyPO(POnumber);

                //load SN
                ReloadSerialbyPO(POnumber);
                UpdateT_InformartionwPOqty(POnumber);
                MessageBox.Show("Hoàn tất update data SN!");
            }
        }
Exemplo n.º 2
0
        public StationReporting()
        {
            //get station name
            StationName = System.Environment.MachineName;
            //get ip
            IP = GetIP();
            //get startup part
            // Get normal filepath of this assembly's permanent directory
            var path = new Uri(
                System.IO.Path.GetDirectoryName(
                    System.Reflection.Assembly.GetExecutingAssembly().CodeBase)
                ).LocalPath;

            this.StartUpPath = path.ToString();
            //getversion
            PPVersion = GetPPVersion();

            //get key
            idKey = cn.ExecSProcDS("GetMaxKey").Tables["Table"].Rows[0][0].ToString();

            //do data
        }