private DataTable checkAFFW(string text)
{
mssqlConnClass msc = new mssqlConnClass();
var sapInitDB = msc.detectDBName(connClient);
string sql = "select MSGTY, t.TEXT, MSGV1 from " + sapInitDB + ".AFFW a " +
" left join " + sapInitDB + ".T100 t on a.MSGNO = t.MSGNR and a.MSGID = t.ARBGB" +
" where AUFNR like '%" + text + "%' and t.SPRSL = 'M'";
var dt = execQuery(sql);
return(dt);
}
public Form1()
{
setConnEnv(isTesting);
var mssqlConn = new mssqlConnClass();
chkFormStatusClass chkForm = new chkFormStatusClass();
var isFormActive = chkForm.isFormActive(formName);
dbConnStr = mssqlConn.toSBSDB(packingDB);
if (isFormActive)
{
InitializeComponent();
}
else
{
MessageBox.Show("目前程式停用中，可能是特定時間或缺乏使用權限，請連絡資訊組");
}
}
private DataTable execQuery(string sql)
{
mssqlConnClass msc = new mssqlConnClass();
string connString = msc.toSAPDB(connClient);
DataTable result = new DataTable();
var sqlConn = new SqlConnection(connString);
try
{
sqlConn.Open();
SqlCommand sCmd = new SqlCommand(sql, sqlConn);
var value = sCmd.ExecuteReader();
result.Load(value);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "執行 execQuery() 出現問題");
}
finally
{
sqlConn.Close();
}
return(result);;
}
