/// <summary>
/// ALO21_1報表_轉單前檢查差異EXCEL
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable ALO21_1(ArrayList ParameterList,
ref ReportList.ExcelOtherType EOT)
{
#region
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConntionDB);
DataTable Dt = BCO.QueryCheckErrorInfo(ParameterList);
if (Dt != null && Dt.Rows.Count > 0)
{
#region 表頭：如要指定表頭必設定
Dt.Columns[0].ColumnName = "配本序號";
Dt.Columns[1].ColumnName = "品號";
Dt.Columns[2].ColumnName = "品名";
Dt.Columns[3].ColumnName = "通路";
Dt.Columns[4].ColumnName = "店號";
Dt.Columns[5].ColumnName = "店名";
Dt.Columns[6].ColumnName = "期別";
Dt.Columns[7].ColumnName = "差異原因";
#endregion
EOT = ReportList.ExcelOtherType.Normal;//如要匯出EXCEL此為必要設定
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
#endregion
}
private void QueryData()
{
#region
try
{
string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim() == "" ? null : SLP_SLPDate1.Text.Trim());
ParameterList.Add(txt_PickBatch.Text.Trim() == "" ? null : txt_PickBatch.Text.Trim());
ParameterList.Add(Request.QueryString["UserIDKey"]);
ParameterList.Add(string.Format("{0}_{1}", Request.QueryString["SessionIDKey"], Request.QueryString["UserIDKey"]));
DataTable dt = BCO.QueryCheckErrorInfo(ParameterList);
if (dt != null && dt.Rows.Count > 0)
{
gv_Result.DataSource = dt;
gv_Result.PageSize = (TextBoxPagesize_Query.Text == "") ? 20 : (int.Parse(TextBoxPagesize_Query.Text) <= 0) ? 20 : int.Parse(TextBoxPagesize_Query.Text);
gv_Result.DataBind();
Session[SessionIDName] = dt;
btn_Export.Enabled = true;
}
else
{
btn_Export.Enabled = false;
gv_Result.DataBind();
ResultMsgLabel.Text = "查無資料";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
/// <summary>
/// ALO21_2報表_列印鈕(已轉單)
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
/// <param name="EOT">匯出Excel方式</param>
/// <returns>回傳查詢結果</returns>
public DataTable ALO21_2(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
#region
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConntionDB);
DataTable Dt = null;
string strErrMsg = "";
Dt = BCO.QueryStOutAcceptData(ParameterList, out strErrMsg);
if (Dt == null || Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
return Dt;
#endregion
}
/// <summary>
/// BUTTON [匯出]鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void but_GetOnHandResult_Click(object sender, EventArgs e)
{
DataTable dtReturn = new DataTable();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
ArrayList ParameterList = new ArrayList();
try
{
#region 檢查必填欄位
BCO.CRMCommon CRMComm = new BCO.CRMCommon();
sb.Append(CRMComm.Check_MustFillIN_Column(this.slp_ST_ACCEPT_DATE.Text, "[門市進貨日]為必填欄位", "0"));
if (sb.ToString().Length > 0)
{
throw new Exception(sb.ToString().Trim());
}
#endregion
#region 從資料庫取得資料
ParameterList.Add(slp_ST_ACCEPT_DATE.Text);
ParameterList.Add(Session["UID"].ToString());
PIC.VDS2G.BSM.ALO.MaintainStAccept alo_bco = new PIC.VDS2G.BSM.ALO.MaintainStAccept(ConntionDB);
//ALOBCO.MaintainStAccept alo_bco = new ALOBCO.MaintainStAccept();
dtReturn = alo_bco.QueryOnHandResult(ParameterList);
if (dtReturn == null || dtReturn.Rows.Count < 1)
{
throw new Exception("查無資料,門市進貨日[" + slp_ST_ACCEPT_DATE.Text + "]無手開單轉單");
}
#endregion
#region 匯出資料
string[] NameArr = { "類別", "店數", "品項數", "總冊數" };
for (int i = 0; i < NameArr.Length; i++)
{
dtReturn.Columns[i].ColumnName = NameArr[i];
}
string FileCode = "CRM17_手開單轉單品項_" + slp_ST_ACCEPT_DATE.Text.Replace("/", "") + ".xls";
//ExcelExportHelper.RenderDataTableToExcel(dt_Return, FileCode);
WriteToXls2(dtReturn, FileCode);
#endregion
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
protected void gv_Result_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
#region
try
{
bool bResult = false;
Label lbl_N_DATA_STATUS = (Label)gv_Result.Rows[e.RowIndex].FindControl("lbl_N_DATA_STATUS");
Label lbl_DIS_NO = (Label)gv_Result.Rows[e.RowIndex].FindControl("lbl_DIS_NO");
Label lbl_ITEM = (Label)gv_Result.Rows[e.RowIndex].FindControl("lbl_ITEM");
Label lbl_PERIOD = (Label)gv_Result.Rows[e.RowIndex].FindControl("lbl_PERIOD");
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(lbl_N_DATA_STATUS.Text.Trim());//門市進貨日
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(lbl_DIS_NO.Text.Trim());//配本序號
ParameterList.Add(lbl_ITEM.Text.Trim());//品號
ParameterList.Add(lbl_PERIOD.Text.Trim());//期別
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(DateTime.Now);//執行日期
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID
bResult = BCO.DeleteStOutAccept(ParameterList, out strErrMsg, null);
if (bResult)
ResultMsgLabel.Text = "刪除成功";
else
ResultMsgLabel.Text = "刪除失敗";
DataTable dt = dt_QueryResult;
for (Int32 i = 0; i <= dt.Rows.Count - 1; i++)
{
//2010/01/12 因為同一個配本序號要同生共滅，所以從GridView刪除某筆資料時，同一筆配本序號的資料要一起刪除
if (dt.Rows[i].RowState != DataRowState.Deleted &&
lbl_DIS_NO.Text.Trim() == dt.Rows[i]["DIS_NO"].ToString().Trim()
//&& lbl_ITEM.Text.Trim() == dt.Rows[i]["ITEM"].ToString().Trim()
//&& lbl_PERIOD.Text.Trim() == dt.Rows[i]["PERIOD"].ToString().Trim()
)
{
dt.Rows[i].Delete();
}
}
dt_QueryResult = dt;
gv_Result.DataSource = dt_QueryResult;
gv_Result.DataBind();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void QueryData()
{
#region
try
{
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
DataTable dt = null;
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(SLP_SLPDate2.Text);//轉門市進貨單日
ParameterList.Add(GetDisTypeSelectedValue());//配本方式
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(DateTime.Now);//執行日期
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID :Session_ID
ParameterList.Add(TextBoxRowCountLimit.Text.Trim());//最大筆數
TransStatusType tst = GetCurrentTransStatus();
if (tst == TransStatusType.Transfered)
{
#region
dt = BCO.QueryStOutAcceptData(ParameterList, out strErrMsg);
#endregion
}
if (tst == TransStatusType.Untransfered)
{
#region
dt = BCO.QueryForFind(ParameterList, out strErrMsg);
#endregion
}
dt_QueryResult = dt;
txt_DisNo_Filtered.Text = "";
SLP_SKU1_Filtered.Text = "";
SLP_SKU1_Filtered.Name = "";
SLP_ItemPeriod1_Filtered.Text = "";
Int32 iRowCount = 0;
if (dt != null && dt.Rows.Count > 0)
{
#region
iRowCount = dt.Rows.Count;
gv_Result.PageSize = iCurrentGvPageSize;
gv_Result.PageIndex = iCurrentGvPageIndex;
gv_Result.DataSource = dt;
gv_Result.DataBind();
btn3_Save.Enabled = true;
Panel_ResultFilteredAll.Visible = true;
btn_QueryFiltered.Visible = true;
btn_QueryFiltered.Enabled = true;
if (rbtn_TransStatus0.Checked)//未轉單
{
btn0_CheckOutItem.Enabled = true;
btn1_CheckDisItem.Enabled = true;
if (iInsertCnt > 0)
{
btn3_Save.Enabled = true;
btn6_BatchDelete.Enabled = false;
}
else
{
btn3_Save.Enabled = false;
btn6_BatchDelete.Enabled = true;
}
btn4_CountItem.Enabled = true;
btn5_CountDisNo.Enabled = true;
btn7_Print.Enabled = true;
}
else//已轉單
{
btn3_Save.Enabled = false;
btn6_BatchDelete.Enabled = false;
btn4_CountItem.Enabled = true;
btn5_CountDisNo.Enabled = true;
btn7_Print.Enabled = true;
}
#region
hidden_DIS_NO.Value = "";
foreach (DataRow dr in dt.Rows)
{
hidden_DIS_NO.Value += string.Format("[{0}],", dr["DIS_NO"].ToString());
}
if (hidden_DIS_NO.Value.Trim() != "")
{
if (hidden_DIS_NO.Value.Substring(hidden_DIS_NO.Value.Length - 1, 1) == ",")
{
hidden_DIS_NO.Value = hidden_DIS_NO.Value.Substring(0, hidden_DIS_NO.Value.Length - 1);
}
}
#endregion
#endregion
}
else
{
#region
iRowCount = 0;
btn3_Save.Enabled = false;
Panel_ResultFilteredAll.Visible = false;
btn_QueryFiltered.Enabled = false;
ResultMsgLabel.Text = "查無資料";
gv_Result.DataBind();
#endregion
}
dt_Filtered = null;
gv_ResultFiltered.DataSource = dt_Filtered;
gv_ResultFiltered.DataBind();
AuthorityControls(this);
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount);
hiddenGvRowCounts.Value = iRowCount.ToString();
//2010/04/27 added:clear Session value
Session[string.Format("ALO21_StAcceptDate_{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())] = null;
Session[string.Format("ALO21_PickBatch_{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())] = null;
Session[string.Format("ALO21_DisType_{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString())] = null;
}
catch (Exception ex)
{
gv_Result.DataBind();
gv_ResultFiltered.DataBind();
LabelQueryRecordCount.Text = "";
throw ex;
}
#endregion
}
protected void btn11_ClearAbnormal_Click(object sender, EventArgs e)
{
#region
try
{
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(Session["UID"].ToString());
BCO.CLEAR_PROCESS_FLAG(ParameterList, null);
string strJS = "alert('清除前次異常轉單狀態成功');location.href='ALO211.aspx?Code=ALO21';";
ScriptManager.RegisterStartupScript(this, this.GetType(), "CLEARABNORMAL", strJS, true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void ShowReport()
{
#region
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
try
{
string strFileName = "";
report.Load(Server.MapPath("./REPORT/ALO21/ALO21R01.rpt"));
strFileName = HttpUtility.UrlEncode("轉門市進貨單明細表.pdf", System.Text.Encoding.UTF8);
#region 2010/02/11 重新查詢
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(SLP_SLPDate2.Text);//轉門市進貨單日
ParameterList.Add(GetDisTypeSelectedValue());//配本方式
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(DateTime.Now);//執行日期
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID :Session_ID
ParameterList.Add(-1);//最大筆數
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
DataTable Dt = null;
if (rbtn_TransStatus1.Checked)//已轉單
{
#region
Dt = BCO.QueryStOutAcceptData(ParameterList, out strErrMsg);
#endregion
}
else//未轉單
{
#region
Dt = BCO.QueryForFind(ParameterList, out strErrMsg);
#endregion
}
#endregion
report.SetDataSource(Dt);
string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString();
report.SetParameterValue("par_Program_ID", "ALO21R01");
report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name);
report.SetParameterValue("par_StAcceptDate", SLP_SLPDate1.Text);
report.SetParameterValue("par_OutStAcceptDate", SLP_SLPDate2.Text);
report.SetParameterValue("par_DisType", GetDisTypeSelectedText());
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + strFileName);//pdf檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally
{
report.Close();
}
#endregion
}
private bool ProcessCreateMultiStoreAccepts(string strStAcceptDate, string strDisType, string strPickBatch, string strUserID, string strSessionID, out string strErrMsg)
{
#region
bool bResult = false;
try
{
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strStAcceptNoArr = "";
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strStAcceptDate);//門市進貨日
ParameterList.Add(strPickBatch);//理貨批次
ParameterList.Add(strDisType);//配本方式
ParameterList.Add(strUserID);//執行者
ParameterList.Add(string.Format("{0}_{1}", strSessionID, strUserID));//PageTimeStamp_LoginID
bResult = BCO.ProcessCreateMultiStoreAccepts(ParameterList, out strStAcceptNoArr, out strErrMsg, null);
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}
private bool DeleteMultiStoreOutAccept()
{
#region
bool bResult = false;
try
{
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(GetDisTypeSelectedValue());//配本方式
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID
bResult = BCO.DeleteMultiStoreOutAccept(ParameterList, out strErrMsg, null);
if (bResult)
{
ResultMsgLabel.Text = "批次刪除成功";
gv_Result.DataBind();
gv_ResultFiltered.DataBind();
}
else
ResultMsgLabel.Text = "批次刪除失敗";
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}
private bool SaveData()
{
#region
bool bResult = false;
try
{
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
string strErrMsg = "";
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text);//門市進貨日
ParameterList.Add(GetDisTypeSelectedValue());//配本方式
ParameterList.Add(SLP_SLPNumber1.Text);//理貨批次
ParameterList.Add(Session["UID"].ToString());//執行者
ParameterList.Add(DateTime.Now);//執行日期
ParameterList.Add(string.Format("{0}_{1}", PageTimeStamp.Value, Session["UID"].ToString()));//PageTimeStamp_LoginID
bResult = BCO.SaveMultiOutStAcccept(ParameterList, out strErrMsg, null);
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}