public bool SaveData(ArrayList ParameterList, DataTable dt)
{
bool bResult = false;
ArrayList Para = new ArrayList();
try
{
//ParameterList[0] D_CREATEDATE
//ParameterList[1] V_CREATEUID
VAM21_DBO DBO = new VAM21_DBO(ref USEDB);
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
//先刪除已存在DB內的資料
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["CREATEDATE"].ToString().Trim() != "")
{
Para.Clear();
Para.Add(dt.Rows[i]["ID"].ToString().Trim());
DBO.DeleteData(Para, DBT);
}
}
//全部重新INSERT
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((dt.Rows[i]["ENABLE"].ToString().Trim() == "1") && (dt.Rows[i]["VENDOR"].ToString().Trim() != ""))
{
Para.Clear();
Para.Add(dt.Rows[i]["VENDOR"].ToString().Trim());
Para.Add(ParameterList[0]);
Para.Add(ParameterList[1]);
DBO.InsertData(Para, DBT);
}
}
DBT.Commit();
bResult = true;
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
throw ex;
}
finally
{
//獨立呼叫Transcation,關閉連線
if (Conn.State == ConnectionState.Connecting)
Conn.Close();
}
return bResult;
}
public DataTable QueryData(ArrayList ParameterList)
{
try
{
VAM21_DBO DBO = new VAM21_DBO(ref USEDB);
DataTable dt = DBO.QueryData(ParameterList);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
