//查詢 VDS_CGD_DAILY_RPT
public DataTable QueryVDS_CGD_DAILY_RPT(ArrayList ParameterList)
{
try
{
VDS_CGD38_DBO CGD38 = new VDS_CGD38_DBO(ref USEDB);
return CGD38.QueryVDS_CGD_DAILY_RPT(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// B5 取得工作站數
/// </summary>
public DataTable GetStationCount(ArrayList ParameterList)
{
try
{
VDS_CGD38_DBO CGD38 = new VDS_CGD38_DBO(ref USEDB);
return CGD38.GetStationCount(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
public void CreateBase(ArrayList ParaMaster, DataTable dtBASE, DbTransaction DBT)
{
CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB);
ArrayList Para = new ArrayList();
//先刪除後新增
//0.N_PID in number,
//1.V_SCODE in varchar2,
Para.Clear();
Para.Add(ParaMaster[0]); //0.N_PID
Para.Add(DBNull.Value);
CGDM.DeleteVDS_CGD_DAILY_BASE(Para, DBT);
for (int i = 0; i < dtBASE.Rows.Count; i++)
{
//0.N_PID in number,
//1.D_PICK_DATE in date,
//2.V_SCODE in varchar2,
//3.V_X in varchar2,
//4.V_Y in varchar2,
//5.V_Z in varchar2,
//6.D_CREATEDATE in date,
//7.V_CREATEUID in varchar2,
//8.D_UPDATEDATE in date,
//9.V_UPDATEUID in varchar2
Para.Clear();
Para.Add(ParaMaster[0]); //0.N_PID
Para.Add(ParaMaster[1]); //1.D_PICK_DATE
Para.Add(dtBASE.Rows[i]["SCODE"].ToString()); //2.V_SCODE in varchar2,
Para.Add(dtBASE.Rows[i]["X_VALUE"].ToString()); //3.V_X in varchar2,
Para.Add(dtBASE.Rows[i]["Y_VALUE"].ToString()); //4.V_Y in varchar2,
Para.Add(dtBASE.Rows[i]["Z_VALUE"].ToString()); //5.V_Z in varchar2,
Para.Add(ParaMaster[2]); //6.D_CREATEDATE in date,
Para.Add(ParaMaster[3]); //7.V_CREATEUID in varchar2,
Para.Add(ParaMaster[4]); //8.D_UPDATEDATE in date,
Para.Add(ParaMaster[5]); //9.V_UPDATEUID in varchar2
CGDM.InertVDS_CGD_DAILY_BASE(Para, DBT);
}
}
public void CreateArea(ArrayList ParaMaster, DataTable dtAREA, DbTransaction DBT)
{
CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB);
ArrayList Para = new ArrayList();
//先刪除後新增
//0.N_PID in number,
//1.V_SCODE in varchar2,
Para.Clear();
Para.Add(ParaMaster[0]); //0.N_PID
Para.Add(DBNull.Value);
CGDM.DeleteVDS_CGD_DAILY_AREA(Para, DBT);
for (int i = 0; i < dtAREA.Rows.Count; i++)
{
//0.N_PID in number,
//1.D_PICK_DATE in date,
//2.V_SCODE in varchar2,
//3.V_EXPLAIN in varchar2,
//4.V_FINISH_TIME in varchar2,
//5.D_CREATEDATE in date,
//6.V_CREATEUID in varchar2,
//7.D_UPDATEDATE in date,
//8.V_UPDATEUID in varchar2
Para.Clear();
Para.Add(ParaMaster[0]); //0.N_PID in number,
Para.Add(ParaMaster[1]); //1.D_PICK_DATE in date,
Para.Add(dtAREA.Rows[i]["SCODE"].ToString()); //2.V_SCODE in varchar2,
Para.Add(dtAREA.Rows[i]["EXPLAIN"].ToString()); //3.V_EXPLAIN in varchar2,
Para.Add(dtAREA.Rows[i]["FINISH_TIME"].ToString()); //4.V_FINISH_TIME in varchar2,
Para.Add(ParaMaster[2]); //5.D_CREATEDATE in date,
Para.Add(ParaMaster[3]); //6.V_CREATEUID in varchar2,
Para.Add(ParaMaster[4]); //7.D_UPDATEDATE in date,
Para.Add(ParaMaster[5]); //8.V_UPDATEUID in varchar2
CGDM.InertVDS_CGD_DAILY_AREA(Para, DBT);
}
}
//修改資料
public void UpdateData(ArrayList ParameterList, DataTable dtBASE, DataTable dtAREA)
{
ArrayList Para = new ArrayList();
try
{
CGD.VDS_CGD38_DBO CGDM = new VDS_CGD38_DBO(ref USEDB);
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
CGDM.UpdateVDS_CGD_DAILY_RPT(ParameterList, DBT);
ArrayList ParaMaster = new ArrayList();
ParaMaster.Clear();
ParaMaster.Add(ParameterList[19]); //ID
ParaMaster.Add(ParameterList[0]); //PICK_DATE
ParaMaster.Add(ParameterList[17]); //D_CREATEDATE
ParaMaster.Add(ParameterList[18]); //V_CREATEUID
ParaMaster.Add(ParameterList[17]); //D_UPDATEDATE
ParaMaster.Add(ParameterList[18]); //V_UPDATEUID
CreateBase(ParaMaster, dtBASE, DBT);
CreateArea(ParaMaster, dtAREA, DBT);
DBT.Commit();
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
throw ex;
}
finally
{
if (Conn.State == ConnectionState.Connecting)
{
Conn.Close();
}
}
}
