/// <summary>
/// 查詢 VDS_CGD_DAILY_SPEC
/// </summary>
public DataTable QueryVDS_CGD_DAILY_SPEC(ArrayList ParameterList)
{
try
{
VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB);
return CGD39.QueryVDS_CGD_DAILY_SPEC(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// C8-> 取《非理貨商品門市資料》區塊的《冊數》欄位合計值
/// C4-> count 資料列數
/// </summary>
public DataTable GetPickOutItem(ArrayList ParameterList)
{
try
{
VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB);
return CGD39.GetPickOutItem(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// C6 副代理明細資料-數量
/// C7 理貨明細資料-比數
/// </summary>
public DataTable QueryDeilyDPSitem(ArrayList ParameterList)
{
try
{
VDS_CGD39_DBO CGD39 = new VDS_CGD39_DBO(ref USEDB);
return CGD39.QueryDeilyDPSitem(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
//儲存資料
public void SaveData(ArrayList ParameterList, DataTable dtINFO, ArrayList ParameterSPEC, DataTable dtITEM)
{
//ParameterList
//0.PID
//1.PICK_DATE
//2.PICK_BATCH
//3.UID
//4.UPDATE_TIME
//5.CREATEUID
//6.CreateDate
//7.V_GET_TIME
//8.N_SPEC_ITEMNUM
//9.N_CTRL_ITEMNUM
//10.N_PICK_ITEMNUM
//11.N_AMT
//12.OLD_RPT_UPDATEUID
//13.OLD_RPT_UPDATE_TIME
ArrayList Para = new ArrayList();
try
{
CGD.VDS_CGD39_DBO CGDM = new VDS_CGD39_DBO(ref USEDB);
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
#region 寫入 VDS_CGD_DAILY_RPT
Para.Clear();
Para.Add(ParameterList[1]);//0.D_PICK_DATE in date,
Para.Add(ParameterList[2]);//1.V_PICK_BATCH in varchar2,
Para.Add(ParameterList[7]);//2.V_GET_TIME in varchar2,
Para.Add(ParameterList[8]);//3.N_SPEC_ITEMNUM in number,
Para.Add(ParameterList[9]);//4.N_CTRL_ITEMNUM in number,
Para.Add(ParameterList[10]);//5.N_PICK_ITEMNUM in number,
Para.Add(ParameterList[11]);//6.N_AMT in number,
Para.Add(ParameterList[4]);//7.D_UPDATEDATE in date,
Para.Add(ParameterList[3]);//8.V_UPDATEUID in varchar2,
Para.Add(ParameterList[0]);//9.N_ID in number,
Para.Add(ParameterList[13]);//10.D_OLD_UPDATEDATE in date,
Para.Add(ParameterList[12]);//11.V_OLD_UPDATEUID in varchar2
CGDM.UpdateVDS_CGD_DAILY_RPT(Para, DBT);
#endregion
#region 寫入VDS_CGD_DAILY_INFO
//先刪除後寫入
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2
CGDM.DeleteVDS_CGD_DAILY_INFO(Para, DBT);
for (int i = 0; i < dtINFO.Rows.Count; i++)
{
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(dtINFO.Rows[i]["VENDOR"].ToString()); //3.V_VENDOR in varchar2,
Para.Add(DBPara(dtINFO.Rows[i]["SHORTNUM"].ToString(), ParaType.Number)); //4.N_SHORTNUM in number,
Para.Add(DBPara(dtINFO.Rows[i]["OVERNUM"].ToString(), ParaType.Number)); //5.N_OVERNUM in number,
Para.Add(DBPara(dtINFO.Rows[i]["NORMAOL_STAFFNUM"].ToString(), ParaType.Number)); //6.N_NORMAOL_STAFFNUM in number,
Para.Add(DBPara(dtINFO.Rows[i]["ADD_STAFFNUM"].ToString(), ParaType.Number)); //7.N_ADD_STAFFNUM in number,
Para.Add(DBPara(dtINFO.Rows[i]["FRONT_STAFFNUM"].ToString(), ParaType.Number)); //8.N_FRONT_STAFFNUM in number,
Para.Add(DBPara(dtINFO.Rows[i]["NORMAOL_HR"].ToString(), ParaType.Number)); //9.N_NORMAOL_HR in number,
Para.Add(DBPara(dtINFO.Rows[i]["ADD_HR"].ToString(), ParaType.Number)); //10.N_ADD_HR in number,
Para.Add(DBPara(dtINFO.Rows[i]["FRONT_HR"].ToString(), ParaType.Number)); //11.N_FRONT_HR in number,
if (ParameterList[5].ToString().Trim() == "")
{
//如果沒有CREATEUID代表新資料
Para.Add(ParameterList[4]); //12.D_CREATEDATE in date,
Para.Add(ParameterList[3]); //13.V_CREATEUID in varchar2,
}
else
{
//如果有CREATEUID 再把舊的CREATEUID寫回去
Para.Add(ParameterList[6]); //12.D_CREATEDATE in date,
Para.Add(ParameterList[5]); //13.V_CREATEUID in varchar2,
}
Para.Add(ParameterList[4]); //14.D_UPDATEDATE in date,
Para.Add(ParameterList[3]); //15.V_UPDATEUID in varchar2
CGDM.InsertVDS_CGD_DAILY_INFO(Para, DBT);
}
#endregion
#region 寫入VDS_CGD_DAILY_SPEC
//先刪除後寫入
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2
CGDM.DeleteVDS_CGD_DAILY_SPEC(Para, DBT);
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(ParameterSPEC[0]); //3.N_SPEC_STORENUM_ALL in number,
Para.Add(ParameterSPEC[1]); //4.N_SPEC_STORENUM in number,
Para.Add(ParameterSPEC[2]); //5.N_SPEC_PERIODNUM_ALL in number,
Para.Add(ParameterSPEC[3]); //6.N_SPEC_PERIODNUM in number,
Para.Add(ParameterSPEC[4]); //7.N_SPEC_ITEMNUM in number,
Para.Add(ParameterSPEC[5]); //8.N_SPEC_STAFFNUM in number,
Para.Add(ParameterSPEC[6]); //9.N_SEPC_HR in number,
Para.Add(ParameterSPEC[7]); //10.N_VDS_TRANSNUM in number,
Para.Add(ParameterSPEC[8]); //11.N_DPS_TRANSNUM in number,
Para.Add(ParameterSPEC[9]); //12.V_NOTES in varchar2
if (ParameterList[5].ToString().Trim() == "")
{
//如果沒有CREATEUID代表新資料
Para.Add(ParameterList[4]); //13.D_CREATEDATE in date,
Para.Add(ParameterList[3]); //14.V_CREATEUID in varchar2,
}
else
{
//如果有CREATEUID 再把舊的CREATEUID寫回去
Para.Add(ParameterList[6]); //13.D_CREATEDATE in date,
Para.Add(ParameterList[5]); //14.V_CREATEUID in varchar2,
}
Para.Add(ParameterList[4]); //15.D_UPDATEDATE in date,
Para.Add(ParameterList[3]); //16.V_UPDATEUID in varchar2
CGDM.InsertVDS_CGD_DAILY_SPEC(Para, DBT);
#endregion
#region 寫入VDS_CGD_DAILY_ITEM
//先刪除後寫入
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(ParameterList[3]); //3.V_UPDATEUID in varchar2
CGDM.DeleteVDS_CGD_DAILY_ITEM(Para, DBT);
for (int i = 0; i < dtITEM.Rows.Count; i++)
{
if ((dtITEM.Rows[i]["ITEM"].ToString().Trim() != "") && (dtITEM.Rows[i]["PERIOD"].ToString() != ""))
{
Para.Clear();
Para.Add(ParameterList[0]); //0.N_PID in number,
Para.Add(ParameterList[1]); //1.D_PICK_DATE in date,
Para.Add(ParameterList[2]); //2.V_PICK_BATCH in varchar2,
Para.Add(dtITEM.Rows[i]["ITEM"].ToString()); //3.V_ITEM in varchar2,
Para.Add(dtITEM.Rows[i]["PERIOD"].ToString()); //4.V_PERIOD in varchar2,
Para.Add(dtITEM.Rows[i]["SHORT_NUM"].ToString()); //5.N_SHORT_NUM in number,
Para.Add(dtITEM.Rows[i]["OVER_NUM"].ToString()); //6.N_OVER_NUM in number,
Para.Add(ParameterList[4]); //7.D_CREATEDATE in date,
Para.Add(ParameterList[3]); //8.V_CREATEUID in varchar2,
Para.Add(ParameterList[4]); //9.D_UPDATEDATE in date,
Para.Add(ParameterList[3]); //10.V_UPDATEUID in varchar2
CGDM.InsertVDS_CGD_DAILY_ITEM(Para, DBT);
}
}
#endregion
DBT.Commit();
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
throw ex;
}
finally
{
if (Conn.State == ConnectionState.Connecting)
{
Conn.Close();
}
}
}
