public DataTable QueryData(ArrayList ParameterList)
{
try
{
VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB);
DataTable dt = DBO.QueryData(ParameterList);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
//取得最大和最小路線
public DataTable GetRouteRange()
{
try
{
VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB);
DataTable dt = DBO.GetRouteRange();
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
public bool SaveData(ArrayList ParameterList, DataTable dt)
{
bool bResult = false;
ArrayList Para = new ArrayList();
try
{
//ParameterList[0] D_CREATEDATE
//ParameterList[1] V_CREATEUID
VDS_TRN31_DBO DBO = new VDS_TRN31_DBO(ref USEDB);
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["UPDATEDATE"].ToString().Trim() == "") //新增
{
//0.STORE VARCHAR2(6)
//1.ROUTE VARCHAR2(3)
//2.STEP VARCHAR2(3)
//3.OLD_STORE VARCHAR2(6)
//4.ST_ACCEPT_DATE DATE
//5.QTY_BOXNUM NUMBER(5)
//6.QTY_BACKBOXNUM NUMBER(5)
//7.UPDATEUID VARCHAR2(10)
//8.UPDATEDATE DATE
Para.Clear();
Para.Add(dt.Rows[i]["STORE"].ToString().Trim());
Para.Add(dt.Rows[i]["ROUTE"].ToString().Trim());
Para.Add(dt.Rows[i]["STEP"].ToString().Trim());
Para.Add(dt.Rows[i]["OLD_STORE"].ToString().Trim());
Para.Add(dt.Rows[i]["ST_ACCEPT_DATE"]);
Para.Add(DBPara(dt.Rows[i]["QTY_BOXNUM"].ToString().Trim(),ParaType.Number));
Para.Add(DBPara(dt.Rows[i]["QTY_BACKBOXNUM"].ToString().Trim(), ParaType.Number));
Para.Add(ParameterList[1]);
Para.Add(ParameterList[0]);
DBO.InsertData(Para, DBT);
}
else //更新
{
//0.STORE VARCHAR2(6)
//1.ST_ACCEPT_DATE DATE
//2.QTY_BOXNUM NUMBER(5)
//3.QTY_BACKBOXNUM NUMBER(5)
//4.UPDATEUID VARCHAR2(10)
//5.UPDATEDATE DATE
//6.OLD_UPDATEUID VARCHAR2(10)
//7.OLD_UPDATEDATE DATE
Para.Clear();
Para.Add(dt.Rows[i]["STORE"].ToString().Trim());
Para.Add(dt.Rows[i]["ST_ACCEPT_DATE"]);
Para.Add(DBPara(dt.Rows[i]["QTY_BOXNUM"].ToString().Trim(),ParaType.Number));
Para.Add(DBPara(dt.Rows[i]["QTY_BACKBOXNUM"].ToString().Trim(), ParaType.Number));
Para.Add(ParameterList[1]);
Para.Add(ParameterList[0]);
Para.Add(dt.Rows[i]["UPDATEUID"].ToString().Trim());
Para.Add(DBPara(dt.Rows[i]["UPDATEDATE"].ToString().Trim(), ParaType.Date));
DBO.UpdateData(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;
}
