//取数据库中最新的LogID
private object GetLastLogID(long LinkedLogID)
{
string sql = string.Format("select LogID from IRAP..stb_Log_WebServiceShuttling where LinkedLogID ={0} and Retried = 0", LinkedLogID);
object rlt = null;
try
{
rlt = DBhelp.getSingle(sql);
}
catch (SqlException e)
{
MessageBox.Show("获取最新logID失败:" + e.Message);
WriteLog.Instance.Write(e.Message, "获取最新logID失败");
}
return(rlt);
}
private void PICKForm_Load(object sender, EventArgs e)
{
if (Skuid != "")
{
string sql = string.Format("select QtyLoaded from IRAPMES..RSFact_PWOMaterialTrack where " +
"WFInstanceID in (SELECT WFInstanceID from IRAPMES..AuxFact_PWOIssuing where MONumber = '{0}' and MOLineNo = '{1}') and SKUID = '{2}'", textEdit12.Text, textEdit13.Text, Skuid);
try
{
textEdit32.Text = Check[2][1] = Check[2][2] = DBhelp.getSingle(sql).ToString();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
WriteLog.Instance.Write(err.Message, "查询Qtyloaded出错");
}
}
}