private void MakeUPDPP(ArrayList parameterList, string filePath)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
DataTable dt = dbo.MakeUPDPP(parameterList);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
File.Delete(filePath + "\\UPDPP.TXT");
using (StreamWriter sw = new StreamWriter(filePath + "\\UPDPP.TXT"))
{
StringBuilder sb = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
sb = new StringBuilder();
string chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? " " : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
sb.Append("B").Append(chanSourceNo.PadRight(11, ' '));
sb.Append("71163".PadLeft(5, ' '));
sb.Append(dt.Rows[i]["STORE"].ToString().Substring(0, 3)).Append(" ");
sb.Append(dt.Rows[i]["PURCHASE_DATE"].ToString().PadLeft(7, '0')).Append(" ");
sb.Append("0".PadLeft(7, ' ')).Append(" "); //預送日
sb.Append("0".PadLeft(7, ' ')).Append(" "); //到貨日
sb.Append("0".PadLeft(7, ' ')).Append(" "); //核單日
sb.Append("0".PadLeft(7, ' ')).Append(" "); //進貨日
sb.Append("0".PadLeft(7, ' ')).Append(" "); //出貨日
sb.Append("0".PadLeft(7, ' ')).Append("20").Append(" "); //結款日
sb.Append(dt.Rows[i]["TOT_QTY"].ToString().PadLeft(7, ' ')).Append(" ").Append(dt.Rows[i]["TOT_PRICE"].ToString().PadLeft(8, ' ')).Append(" ");
sb.Append(dt.Rows[i]["TOT_COST_DIS"].ToString().PadLeft(8, ' ')).Append(" ").Append("0".PadLeft(7, ' ')).Append(" "); //驗收總量
sb.Append("0".PadLeft(8, ' ')).Append(" "); //驗收總定價
sb.Append("0".PadLeft(8, ' ')).Append(" "); //驗收總成本
//2010/06/04:kevin:對應金石堂銷售訂單格式修改要改成
sb.Append("1.0000");
//sb.Append(dt.Rows[i]["TAX_RATE"].ToString()).Append(" ").Append(dt.Rows[i]["KIND_NUM"].ToString().PadLeft(5, ' '));
if (i != dt.Rows.Count - 1)
{
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
}
sw.Close();
}
}
public void CheckTempX_CA(DbTransaction RootDBT, ArrayList ParameterList)
{
try
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
if (RootDBT == null)
{
//獨立呼叫啟動Transcation
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
}
else
{
DBT = RootDBT;
}
dbo.doCheckTempX_CA(DBT, ParameterList);
if (RootDBT == null)
DBT.Commit();
}
catch (Exception ex)
{
#region 交易失敗
if (RootDBT == null)
DBT.Rollback();
#endregion
throw ex;
}
finally
{
#region 判斷是否關閉交易連線
if (RootDBT == null) //獨立呼叫Transcation,關閉連線
if (Conn.State == ConnectionState.Connecting)
Conn.Close();
#endregion
}
}
public string ExportDDD_02(ArrayList parameterList, string filePath)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
DataTable dt = dbo.GetCBData(parameterList);
//下載檔名及路徑 誠品文字檔資料主檔名須為大寫.副檔名須小寫
string time = DateTime.Now.ToString("yyyyMMddhhmmss");
string fileName = filePath + "\\AUTOPO_" + time + ".txt";
string okFile = filePath + "\\AUTOPO_" + time + ".ok";
using (StreamWriter sw = new StreamWriter(fileName))
{
StringBuilder sb = null;
int seq = 0;
string v_chanSourceNo = null;
string ean = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
//誠品二段碼超過2碼不上傳
if (dt.Rows[i]["PERIOD_BARCODE"].ToString().Length > 2)
{
ean = dt.Rows[i]["BARCODE"].ToString();
}
else
{
ean = dt.Rows[i]["BARCODE"].ToString() + dt.Rows[i]["PERIOD_BARCODE"].ToString();
}
sb = new StringBuilder();
string chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? " " : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
string coverPrice = dt.Rows[i]["COVER_PRICE"].ToString();
coverPrice = string.Format("{0:##########.00}", decimal.Parse(coverPrice));
string price = dt.Rows[i]["PRICE"].ToString();
price = string.Format("{0:##########.00}", decimal.Parse(price));
string salePrice = dt.Rows[i]["SALE_PRICE"].ToString();
salePrice = string.Format("{0:##########.00}", decimal.Parse(salePrice));
if ((v_chanSourceNo == null ? "*" : v_chanSourceNo) != (dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString()))
{
seq = 1;
}
else
{
seq = seq + 1;
}
sb.Append(chanSourceNo.PadRight(10, ' '));
sb.Append(seq.ToString().PadLeft(5, ' '));
sb.Append(dt.Rows[i]["VENDOR"].ToString().PadRight(10, ' '));
sb.Append(dt.Rows[i]["STORE"].ToString().PadRight(4, ' '));
sb.Append(dt.Rows[i]["CHAN_ITEM"].ToString().PadRight(18, ' '));
sb.Append(dt.Rows[i]["ST_ACCEPT_QTY"].ToString().PadLeft(13, ' '));
sb.Append(dt.Rows[i]["ST_ACCEPT_DATE"].ToString().PadRight(8, ' '));
sb.Append(dt.Rows[i]["ITEM"].ToString().PadRight(35, ' '));
sb.Append(ean.PadRight(18, ' '));
sb.Append(coverPrice.PadLeft(14, ' '));
sb.Append(price.PadLeft(14, ' '));
sb.Append(salePrice.PadLeft(14, ' '));
if (i != dt.Rows.Count - 1)
{
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
v_chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
}
sw.Close();
using (StreamWriter swOK = new StreamWriter(okFile))
{
swOK.Close();
}
MakeBatFile(filePath, time);
string zipName = filePath + "\\AUTOPO_" + time + ".zip";
ZipFile z = ZipFile.Create(zipName);
Environment.CurrentDirectory = filePath + "\\";
z.BeginUpdate();
z.Add("AUTOPO_" + time + ".txt");
z.Add("AUTOPO_" + time + ".ok");
z.Add("AUTOPO_" + time + ".bat");
z.CommitUpdate();
z.Close();
return zipName;
}
}
private void MakeUPDSP(ArrayList parameterList, string filePath)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
DataTable dt = dbo.MakeUPDSP(parameterList);
File.Delete(filePath + "\\UPDSP.TXT");
using (StreamWriter sw = new StreamWriter(filePath + "\\UPDSP.TXT"))
{
StringBuilder sb = null;
int seq = 0;
string v_chanSourceNo = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
sb = new StringBuilder();
string chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? " " : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
string costDis = dt.Rows[i]["TOT_COST_DIS"].ToString();
costDis = Math.Round(decimal.Parse(costDis)).ToString();
string orderNo = dt.Rows[i]["ORDER_NO"].ToString();
orderNo = orderNo.Substring(orderNo.Length - 10, 10);
string price = dt.Rows[i]["TOT_PRICE"].ToString();
price = string.Format("{0:######.00}", Math.Round(decimal.Parse(price), 2));
if ((v_chanSourceNo == null ? "*" : v_chanSourceNo) != (dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString()))
{
seq = 1;
}
else
{
seq = seq + 1;
}
sb.Append("B").Append(chanSourceNo.PadRight(11, ' ')).Append(" ");
sb.Append(seq.ToString().PadLeft(5, ' '));
sb.Append(dt.Rows[i]["STORE"].ToString().Substring(0, 3)).Append(dt.Rows[i]["ITEM_MAP"].ToString().PadRight(13, ' ')).Append(" ");
sb.Append(dt.Rows[i]["PURCHASE_QTY"].ToString().PadLeft(5, ' ')).Append(" ");
sb.Append(costDis.PadLeft(7, ' ')).Append(" "); //採購成本
sb.Append("0".PadLeft(4, ' ')).Append(" "); //驗收量
sb.Append(".00".PadLeft(9, ' ')).Append(" "); //驗收成本
sb.Append(".00".PadLeft(9, ' ')).Append(" "); //驗收定價
sb.Append("B").Append(orderNo).Append(" ");
sb.Append(dt.Rows[i]["ORDER_DATE"].ToString().PadLeft(7, '0')).Append(" ");
sb.Append(dt.Rows[i]["QTY"].ToString().PadLeft(4, ' ')).Append("K").Append(" "); //原訂量
sb.Append(price.PadLeft(9, ' ')).Append(" ").Append("N"); //採購定價
if (i != dt.Rows.Count - 1)
{
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
v_chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
}
sw.Close();
}
}
private void MakeUPDDP(ArrayList parameterList, string filePath)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
DataTable dt = dbo.MakeUPDDP(parameterList);
File.Delete(filePath + "\\UPDDP.TXT");
using (StreamWriter sw = new StreamWriter(filePath + "\\UPDDP.TXT"))
{
StringBuilder sb = null;
int seq = 0;
string v_chanSourceNo = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
sb = new StringBuilder();
string chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? " " : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
string itemMap = dt.Rows[i].IsNull("ITEM_MAP") ? " " : dt.Rows[i]["ITEM_MAP"].ToString();
//2010/06/04:kevin:對應金石堂銷售訂單格式修改要改成
//string discount = ".7300";
string discount = dt.Rows[i].IsNull("DISCOUNT") ? ".7300" : dt.Rows[i]["DISCOUNT"].ToString();
discount = string.Format("{0:.0000}", decimal.Parse(discount));
string price = dt.Rows[i]["TOT_PRICE"].ToString();
price = string.Format("{0:#######.00}", decimal.Parse(price));
string costDis = dt.Rows[i]["TOT_COST_DIS"].ToString();
costDis = string.Format("{0:#######.00}", decimal.Parse(costDis));
if ((v_chanSourceNo == null ? "*" : v_chanSourceNo) != (dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString()))
{
seq = 1;
}
else
{
seq = seq + 1;
}
sb.Append("B").Append(chanSourceNo.PadRight(11, ' ')).Append(" ");
sb.Append(seq.ToString().PadLeft(5, ' '));
sb.Append(itemMap.PadRight(13, ' '));
sb.Append(dt.Rows[i]["ITEM"].ToString().PadRight(10, ' ')).Append(" ");
sb.Append(dt.Rows[i]["PRICE"].ToString().PadLeft(6, ' ')).Append(" ");
sb.Append(discount.PadLeft(6, ' ')); //折扣
sb.Append(" ".PadLeft(12, ' ')).Append(" ");
sb.Append(dt.Rows[i]["PURCHASE_QTY"].ToString().PadLeft(6, ' ')).Append(" "); //採購量
sb.Append("0".PadLeft(6, ' ')).Append(" "); //驗收量
sb.Append("0.00".PadLeft(10, ' ')).Append(" "); //商品驗收定價
sb.Append("0.00".PadLeft(10, ' ')).Append(" "); //商品驗收成本
sb.Append("Y").Append("71163").Append(" ").Append("1").Append("N").Append(" ");
sb.Append(dt.Rows[i]["QTY"].ToString().PadLeft(5, ' ')).Append(" ").Append("K").Append(" ");
sb.Append(price.PadLeft(10, ' ')).Append(" ");
sb.Append(costDis.PadLeft(10, ' ')).Append(" ").Append("N");
if (i != dt.Rows.Count - 1)
{
sb.Append(Environment.NewLine);
}
sw.Write(sb.ToString());
v_chanSourceNo = dt.Rows[i].IsNull("CHAN_SOURCE_NO") ? null : dt.Rows[i]["CHAN_SOURCE_NO"].ToString();
}
sw.Close();
}
}
public void LoadDataToTempTableX(DbTransaction transaction, ArrayList ParameterList)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
dbo.LoadDataToTempTableX(transaction, ParameterList);
}
public void LoadDataToTempTable(DbTransaction transaction, string data, int intID)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
dbo.LoadDataToTempTable(transaction, data, intID);
}
public DataTable Query_VDS_CAM_CHAN_LOG_BK(ArrayList ParameterList)
{
try
{
CAM07DBO DBO = new CAM07DBO(ref USEDB);
return DBO.doQuery_VDS_CAM_CHAN_LOG_BK(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryErrorByFind(ArrayList ParameterList)
{
try
{
CAM07DBO DBO = new CAM07DBO(ref USEDB);
return DBO.doQueryErrorByFind(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string[] LoadPOSX(ArrayList ParameterList)
{
try
{
CAM07DBO DBO = new CAM07DBO(ref USEDB);
return DBO.DoLoadPOSX(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 取得CA期別
/// </summary>
/// <param name="ParameterList"></param>
/// <returns></returns>
public void Get_CA_Period(ArrayList ParameterList,out string strNewItem,out string strNewPeriod)
{
try
{
CAM07DBO DBO = new CAM07DBO(ref USEDB);
DBO.DoGet_CA_Period(ParameterList, out strNewItem, out strNewPeriod);
}
catch (Exception ex)
{
throw ex;
}
}
public void ClearTempTablesX(ArrayList ParameterList)
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
dbo.ClearTempTablesX(ParameterList);
}
public void ClearTempTables()
{
CAM07DBO dbo = new CAM07DBO(ref USEDB);
dbo.ClearTempTables();
}