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