/// <summary>
/// downlaod wo info into r_wo_text from sap
/// </summary>
protected void SaveWOText()
{
for (int m = 0; m < dtWOText.Rows.Count; m++)
{
sql = "";
woIsExist = false;
try
{
woIsExist = R_WO_TEXT.CheckWoTextByWo(dtWOText.Rows[m]["AUFNR"].ToString(), true, SFCDB);
if (woIsExist)
{
continue;
}
Row_R_WO_TEXT rowRWOText = (Row_R_WO_TEXT)R_WO_TEXT.NewRow();
rowRWOText.ID = R_WO_TEXT.GetNewID(BU, SFCDB);
rowRWOText.AUFNR = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.MATNR = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.ARBPL = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.LTXA1 = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.ISAVD = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.VORNR = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.MGVRG = dtWOText.Rows[m]["AUFNR"].ToString();
rowRWOText.LMNGA = dtWOText.Rows[m]["AUFNR"].ToString();
sql = rowRWOText.GetInsertString(DB_TYPE_ENUM.Oracle);
SFCDB.ExecSQL(sql);
SFCDB.CommitTrain();
}
catch (Exception ex)
{
//write log
WriteLog.WriteIntoMESLog(SFCDB, BU, "MESInterface", "MESInterface.HWD.DownLoadWO", "SaveWOText", ip + ";" + dtWOText.Rows[m]["AUFNR"].ToString() + ";Down load r_wo_text fail," + ex.Message.ToString(), "", "interface");
continue;
}
}
}
