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 static void UpdateT_InformartionwPOqty(string strPONumber)
{
strPONumber = strPONumber.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"];
mycon.ExecSProc("[ame_T_Information_Update_POqty]", strPONumber.PadLeft(12, '0'));
}
public void DoCloseStation()
{
SP_Processing.MySqlConn cn = new SP_Processing.MySqlConn(PhanMem.chuoi_ket_noivnmsrv601_FFCPacking);
cn.ExecSProc("DoCloseStation", idKey);
}
public static void DeleteSerialbyPO(string POnumber)
{
SP_Processing.MySqlConn mycon = new SP_Processing.MySqlConn(strSqlConnection4_608FFCPACKING);
mycon.ExecSProc("usp_TFFC_SerialNumbersDelete", POnumber.PadLeft(12, '0'));
}