/// <summary>
/// GridView1_向下鈕事件
/// </summary>
protected void btnXRouteDown_Click(object sender, EventArgs e)
{
if (GridView1.Rows.Count <= 0)
{
return;
}
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
DataTable Dt = null;
try
{
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
}
else
{
//從DB讀取一空table回來
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
Dt = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.Empty, ParameterList);
}
string oldCheckPlace = "";//for記錄舊的選取點
#region 計算目前查詢所得之DataTable的PickOrder欄位最大值(maxPickOrder)是多少
int maxPickOrder = 0;
for (int max = 0; max <= Dt.Rows.Count - 1; max++)
{
if ((hidSLPDate1.Text.Trim() == Convert.ToDateTime(Dt.Rows[max]["ST_ACCEPT_DATE"].ToString()).ToShortDateString()) && (hidtxtPickBatch.Text.Trim() == Dt.Rows[max]["PICK_BATCH"].ToString().Trim()) && (Dt.Rows[max]["LINE"].ToString().Trim() == "X"))
{
if (Convert.ToInt32(Dt.Rows[max]["PICK_ORDER"].ToString()) > maxPickOrder)
{
maxPickOrder = Convert.ToInt32(Dt.Rows[max]["PICK_ORDER"].ToString());
}
}
}
#endregion
for (int i = GridView1.Rows.Count - 1; i >= 0; i--)
{
if (((CheckBox)(GridView1.Rows[i].FindControl("CheckBox1"))).Checked == true)
{
oldCheckPlace += Convert.ToString(i) + ",";
for (int j = 0; j <= Dt.Rows.Count - 1; j++)
{
int oldPICK_ORDER = 0;
int newPICK_ORDER = 0;
if ((((Label)(GridView1.Rows[i].FindControl("Label3"))).Text == Dt.Rows[j]["ROUTE"].ToString()) && (hidSLPDate1.Text.Trim() == Convert.ToDateTime(Dt.Rows[j]["ST_ACCEPT_DATE"].ToString()).ToShortDateString()) && (hidtxtPickBatch.Text.Trim() == Dt.Rows[j]["PICK_BATCH"].ToString().Trim()))
{
oldPICK_ORDER = Convert.ToInt32(Dt.Rows[j]["PICK_ORDER"].ToString());
string found = "";
for (int l = oldPICK_ORDER + 1; l <= maxPickOrder; l++)
{
if (found == "")
{
for (int k = 0; k <= Dt.Rows.Count - 1; k++)
{
if ((Convert.ToString(Convert.ToInt32(Dt.Rows[k]["PICK_ORDER"].ToString())) == Convert.ToString(l)) && (hidSLPDate1.Text.Trim() == Convert.ToDateTime(Dt.Rows[k]["ST_ACCEPT_DATE"].ToString()).ToShortDateString()) && (hidtxtPickBatch.Text.Trim() == Dt.Rows[k]["PICK_BATCH"].ToString().Trim()) && (Dt.Rows[k]["LINE"].ToString().Trim() == "X"))
{
newPICK_ORDER = Convert.ToInt32(Dt.Rows[k]["PICK_ORDER"].ToString());
string _oldPICK_ORDER = Convert.ToString(oldPICK_ORDER);
string _newPICK_ORDER = Convert.ToString(newPICK_ORDER);
if (_oldPICK_ORDER.Length == 1)
{
_oldPICK_ORDER = "00" + _oldPICK_ORDER;
}
else if (_oldPICK_ORDER.Length == 2)
{
_oldPICK_ORDER = "0" + _oldPICK_ORDER;
}
if (_newPICK_ORDER.Length == 1)
{
_newPICK_ORDER = "00" + _newPICK_ORDER;
}
else if (_newPICK_ORDER.Length == 2)
{
_newPICK_ORDER = "0" + _newPICK_ORDER;
}
Dt.Rows[k]["PICK_ORDER"] = _oldPICK_ORDER;
Dt.Rows[j]["PICK_ORDER"] = _newPICK_ORDER;
found = "Y";
}
}
}
}
}
}
}
}
Session[SessionIDName] = Dt;
DataTable tempDT1 = Dt.Copy();
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
Session[SessionIDName1] = tempDT1;
DataView DV1 = tempDT1.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV1.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView1.PageIndex = 0;
GridView1.DataBind();
//依已記錄下的選取點重新勾選回去
string[] strAryArg = oldCheckPlace.Split(",".ToCharArray());
for (int i = 0; i <= strAryArg.Length - 1; i++)
{
int tempI = 0;
if ((strAryArg[i].ToString() != "") && (strAryArg[i].ToString() != Convert.ToString(GridView1.Rows.Count - 1)))
{
tempI = Convert.ToInt32(strAryArg[i].ToString());
((CheckBox)(GridView1.Rows[tempI + 1].FindControl("CheckBox1"))).Checked = true;
}
if (strAryArg[i].ToString() == Convert.ToString(GridView1.Rows.Count - 1))
{
tempI = Convert.ToInt32(strAryArg[i].ToString());
((CheckBox)(GridView1.Rows[tempI].FindControl("CheckBox1"))).Checked = true;
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// GridView1_換線鈕事件
/// </summary>
protected void btnXChangeLine_Click(object sender, EventArgs e)
{
if (GridView1.Rows.Count <= 0)
{
return;
}
if (ddlXChangeLine.SelectedItem.Text == "")
{
ErrorMsgLabel.Text = "路線未選擇";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 路線未選擇 ');", true);
return;
}
else if (ddlXChangeLine.SelectedItem.Text == "X")
{
ErrorMsgLabel.Text = "請選舉與原路線不同之路線";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 請選舉與原路線不同之路線 ');", true);
return;
}
try
{
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
DataTable Dt = null;
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
}
else if (Dt.Rows.Count == 0)
{
//從DB讀取一空table回來
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
Dt = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.Empty, ParameterList);
}
else
{
//從DB讀取一空table回來
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
Dt = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.Empty, ParameterList);
}
for (int i = GridView1.Rows.Count - 1; i >= 0; i--)
{
if (((CheckBox)(GridView1.Rows[i].FindControl("CheckBox1"))).Checked == true)
{
for (int j = 0; j <= Dt.Rows.Count - 1; j++)
{
if ((((Label)(GridView1.Rows[i].FindControl("Label3"))).Text == Dt.Rows[j]["ROUTE"].ToString()) && (Convert.ToDateTime(hidSLPDate1.Text.Trim()).ToShortDateString() == Convert.ToDateTime(Dt.Rows[j]["ST_ACCEPT_DATE"].ToString()).ToShortDateString()) && (hidtxtPickBatch.Text.Trim() == Dt.Rows[j]["PICK_BATCH"].ToString().Trim()))
{
int tempID = 0;
DataView dv = new DataView();
dv.Table = Dt.Copy();
dv.RowFilter = "LINE ='" + ddlXChangeLine.SelectedItem.Text + "'";
dv.Sort = "PICK_ORDER ASC";
DataTable tempDT = dv.ToTable();
if (tempDT.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT.Rows[tempDT.Rows.Count - 1]["PICK_ORDER"].ToString());
}
Dt.Rows[j]["LINE"] = ddlXChangeLine.SelectedItem.Text;
#region 將tempID轉換為3碼之newPICK_ORDER
string newPICK_ORDER = Convert.ToString(tempID + 1);
if (newPICK_ORDER.Length == 1)
{
newPICK_ORDER = "00" + newPICK_ORDER;
}
else if (newPICK_ORDER.Length == 2)
{
newPICK_ORDER = "0" + newPICK_ORDER;
}
#endregion
Dt.Rows[j]["PICK_ORDER"] = newPICK_ORDER;
}
}
}
}
Session[SessionIDName] = Dt;
DataTable tempDT1 = Dt.Copy();
DataTable tempDT2 = Dt.Copy();
DataTable tempDT3 = Dt.Copy();
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
string SessionIDName2 = "CGD011_2_" + PageTimeStamp.Value;
string SessionIDName3 = "CGD011_3_" + PageTimeStamp.Value;
Session[SessionIDName1] = tempDT1;
Session[SessionIDName2] = tempDT2;
Session[SessionIDName3] = tempDT3;
DataView DV1 = tempDT1.DefaultView;
DataView DV2 = tempDT2.DefaultView;
DataView DV3 = tempDT3.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV2.RowFilter = "LINE = 'Y'";
DV3.RowFilter = "LINE = 'Z'";
DV1.Sort = "PICK_ORDER ASC";
DV2.Sort = "PICK_ORDER ASC";
DV3.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView2.DataSource = DV2;
GridView3.DataSource = DV3;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView2.PageIndex = 0;
GridView3.PageIndex = 0;
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
#region 計算總店數
DataTable exchange1 = DV1.ToTable();
DataTable exchange2 = DV2.ToTable();
DataTable exchange3 = DV3.ToTable();
int totalStoreX = 0;
for (int i = 0; i <= exchange1.Rows.Count - 1; i++)
{
if (exchange1.Rows[i][16].ToString() != "")
{
totalStoreX += Convert.ToInt32(exchange1.Rows[i][16].ToString());
}
}
lblTotalX.Text = "總計店數：" + Convert.ToString(totalStoreX);
int totalStoreY = 0;
for (int i = 0; i <= exchange2.Rows.Count - 1; i++)
{
if (exchange2.Rows[i][16].ToString() != "")
{
totalStoreY += Convert.ToInt32(exchange2.Rows[i][16].ToString());
}
}
lblTotalY.Text = "總計店數：" + Convert.ToString(totalStoreY);
int totalStoreZ = 0;
for (int i = 0; i <= exchange3.Rows.Count - 1; i++)
{
if (exchange3.Rows[i][16].ToString() != "")
{
totalStoreZ += Convert.ToInt32(exchange3.Rows[i][16].ToString());
}
}
lblTotalZ.Text = "總計店數：" + Convert.ToString(totalStoreZ);
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// databind 繫結查詢資料到GridView1,2,3
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
string SessionIDName2 = "CGD011_2_" + PageTimeStamp.Value;
string SessionIDName3 = "CGD011_3_" + PageTimeStamp.Value;
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
DataTable Dt;
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
}
else
{
ParameterList.Clear();
ParameterList.Add(this.hidSLPDate1.Text.Trim());
ParameterList.Add(this.hidtxtPickBatch.Text.Trim());
Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
}
if (Dt.Rows.Count == 0)
{
CrystalReportViewer1.Visible = false;
if (showNoDataMessage == "Y")
ErrorMsgLabel.Text = "查無資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 查無資料 ');", true);
txtRouteADD.Text = "";
txtRouteSort.Text = "";
Panel1.Visible = false;
Panel2.Visible = false;
lblTotalX.Text = "總計店數：";
lblTotalY.Text = "總計店數：";
lblTotalZ.Text = "總計店數：";
}
Session[SessionIDName] = Dt;
DataTable tempDT1 = Dt.Copy();
DataTable tempDT2 = Dt.Copy();
DataTable tempDT3 = Dt.Copy();
Session[SessionIDName1] = tempDT1;
Session[SessionIDName2] = tempDT2;
Session[SessionIDName3] = tempDT3;
DataView DV1 = tempDT1.DefaultView;
DataView DV2 = tempDT2.DefaultView;
DataView DV3 = tempDT3.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV2.RowFilter = "LINE = 'Y'";
DV3.RowFilter = "LINE = 'Z'";
DV1.Sort = "PICK_ORDER ASC";
DV2.Sort = "PICK_ORDER ASC";
DV3.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView2.DataSource = DV2;
GridView3.DataSource = DV3;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView2.PageIndex = 0;
GridView3.PageIndex = 0;
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
#region 計算總店數
DataTable exchange1 = DV1.ToTable();
DataTable exchange2 = DV2.ToTable();
DataTable exchange3 = DV3.ToTable();
int totalStoreX = 0;
for (int i = 0; i <= exchange1.Rows.Count - 1; i++)
{
if (exchange1.Rows[i][16].ToString() != "")
{
totalStoreX += Convert.ToInt32(exchange1.Rows[i][16].ToString());
}
}
lblTotalX.Text = "總計店數：" + Convert.ToString(totalStoreX);
int totalStoreY = 0;
for (int i = 0; i <= exchange2.Rows.Count - 1; i++)
{
if (exchange2.Rows[i][16].ToString() != "")
{
totalStoreY += Convert.ToInt32(exchange2.Rows[i][16].ToString());
}
}
lblTotalY.Text = "總計店數：" + Convert.ToString(totalStoreY);
int totalStoreZ = 0;
for (int i = 0; i <= exchange3.Rows.Count - 1; i++)
{
if (exchange3.Rows[i][16].ToString() != "")
{
totalStoreZ += Convert.ToInt32(exchange3.Rows[i][16].ToString());
}
}
lblTotalZ.Text = "總計店數：" + Convert.ToString(totalStoreZ);
#endregion
}
/// <summary>
/// 檢查路線履歷是否已過期
/// </summary>
private string CheckRoute()
{
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim());
ParameterList.Add(txtRouteADD.Text.Trim());
return BCO.CheckRoute(ParameterList);
}
/// <summary>
/// 插入鈕
/// </summary>
protected void btnInsert_Click(object sender, EventArgs e)
{
hidtxtPickBatch.Text = txtPickBatch.Text;
if (SLP_SLPDate1.Text != "")
{
hidSLPDate1.Text = Convert.ToDateTime(SLP_SLPDate1.Text).ToShortDateString();
}
#region 檢查輸入值
if (ddlLineADD.SelectedItem.Text == "")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('[理貨線]不得為空白');", true);
return;
}
if (txtRouteADD.Text.Trim() == "")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('[路線]不得為空白');", true);
return;
}
TextBox tmpBox = (TextBox)txtRouteADD.FindControl("TextBoxName");
if (tmpRouteName == "查無資料")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('所輸入之[路線]不正確');", true);
return;
}
string checkResult = CheckRoute();
if (checkResult != "1")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert(' 查無所輸入之[路線]之履歷，或該[路線]之履歷已過期 ');", true);
return;
}
#endregion
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
DataTable Dt = null;
try
{
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
}
else
{
//從DB讀取一空table回來
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
Dt = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.Empty, ParameterList);
}
tempID = 0;
DataView tempDT = new DataView();
tempDT.Table = Dt.Copy();
tempDT.Sort = "ID ASC";
if (Dt.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[tempDT.Count - 1]["ID"].ToString());
}
DataRow dRow = Dt.NewRow();
//ID和CODE暫自訂, 真正寫入CO時會重取
int v_ID = tempID + 1;
int v_CODE = tempID + 1;
dRow["ID"] = v_ID;
dRow["CODE"] = v_CODE;
dRow["CREATEDATE"] = DateTime.Now;
dRow["UPDATEDATE"] = DateTime.Now;
dRow["CREATEUID"] = Session["UID"].ToString();
dRow["UPDATEUID"] = Session["UID"].ToString();
dRow["STATUS"] = "0";
dRow["ENABLE"] = "1";
if (Dt.Columns.Contains("NAME") != null)
{
dRow["NAME"] = ddlLineADD.SelectedItem.Text + "-" + txtRouteADD.Text;
}
dRow["DPS_CODE"] = "A";
dRow["ST_ACCEPT_DATE"] = Convert.ToDateTime(hidSLPDate1.Text);
dRow["PICK_BATCH"] = hidtxtPickBatch.Text;
dRow["LINE"] = ddlLineADD.SelectedItem.Text;
#region 取路線名
TextBox _tmpRouteName = (TextBox)txtRouteADD.FindControl("TextBoxName");
tmpRouteName = Request[_tmpRouteName.UniqueID].ToString();
#endregion
dRow["ROUTE_NAME"] = tmpRouteName;
dRow["STORE_CNT"] = "0";
string repeat = "";
int tempPickOrder = 0;
if (txtRouteSort.Text.Trim() == "") //使用者無輸入序號
{
#region 找出該線最後一號()
tempPickOrder = 0;
DataView dv = new DataView();
dv.Table = Dt.Copy();
dv.RowFilter = "LINE ='" + ddlLineADD.SelectedItem.Text + "'";
dv.Sort = "PICK_ORDER ASC";
DataTable tempDt = dv.ToTable();
if (tempDt.Rows.Count != 0)
{
tempPickOrder = Convert.ToInt32(tempDt.Rows[tempDt.Rows.Count - 1]["PICK_ORDER"].ToString());
}
else
{
tempPickOrder = 0;
}
#endregion
tempPickOrder += 1;
string _tempPickOrder = Convert.ToString(tempPickOrder);
if (_tempPickOrder.Length == 1)
{
_tempPickOrder = "00" + _tempPickOrder;
}
else if (_tempPickOrder.Length == 2)
{
_tempPickOrder = "0" + _tempPickOrder;
}
dRow["PICK_ORDER"] = _tempPickOrder;
}
else
{
#region Check使用者所輸入之序號是否有重複
tempPickOrder = 0;
DataView dv = new DataView();
dv.Table = Dt.Copy();
dv.RowFilter = "LINE ='" + ddlLineADD.SelectedItem.Text + "'";
dv.Sort = "PICK_ORDER ASC";
DataTable tempDt = dv.ToTable();
for (int i = 0; i <= tempDt.Rows.Count - 1; i++)
{
if (tempDt.Rows[i].RowState != DataRowState.Deleted)
{
if (tempDt.Rows[i]["PICK_ORDER"].ToString() == txtRouteSort.Text.Trim())
{
repeat = "Y";
}
}
}
#endregion
if (repeat == "Y")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('所輸入之序號已重複');", true);
return;
}
else
{
dRow["PICK_ORDER"] = txtRouteSort.Text.Trim();
}
}
#region Check使用者所輸入之路線是否有重複
tempPickOrder = 0;
DataView dv2 = new DataView();
dv2.Table = Dt.Copy();
//dv2.RowFilter = "LINE ='" + ddlLineADD.SelectedItem.Text + "'";
//dv2.Sort = "PICK_ORDER ASC";
DataTable tempDt2 = dv2.ToTable();
for (int i = 0; i <= tempDt2.Rows.Count - 1; i++)
{
if (tempDt2.Rows[i].RowState != DataRowState.Deleted)
{
if (tempDt2.Rows[i]["ROUTE"].ToString() == txtRouteADD.Text.Trim())
{
repeat = "Y";
}
}
}
if (repeat == "Y")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('所輸入之路線已重複');", true);
return;
}
else
{
dRow["ROUTE"] = txtRouteADD.Text.Trim();
}
#endregion
Dt.Rows.Add(dRow);
ddlLineADD.SelectedIndex = 0;
txtRouteADD.Text = "";
txtRouteSort.Text = "";
Panel1.Visible = false;
Session[SessionIDName] = Dt;
DataTable tempDT1 = Dt.Copy();
DataTable tempDT2 = Dt.Copy();
DataTable tempDT3 = Dt.Copy();
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
string SessionIDName2 = "CGD011_2_" + PageTimeStamp.Value;
string SessionIDName3 = "CGD011_3_" + PageTimeStamp.Value;
Session[SessionIDName1] = tempDT1;
Session[SessionIDName2] = tempDT2;
Session[SessionIDName3] = tempDT3;
DataView DV1 = tempDT1.DefaultView;
DataView DV2 = tempDT2.DefaultView;
DataView DV3 = tempDT3.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV2.RowFilter = "LINE = 'Y'";
DV3.RowFilter = "LINE = 'Z'";
DV1.Sort = "PICK_ORDER ASC";
DV2.Sort = "PICK_ORDER ASC";
DV3.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView2.DataSource = DV2;
GridView3.DataSource = DV3;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView2.PageIndex = 0;
GridView3.PageIndex = 0;
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
Panel2.Visible = true;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
/// <summary>
/// 複製鈕(複製視窗內的)
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
#region 輸入檢查
if (SLP_CopyFromDate.Text == "")
{
ErrorMsgLabel.Text = "舊[門市進貨日]欄位不得空白";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 舊[門市進貨日]欄位不得空白 ');", true);
return;
}
if (txtPickBatchCopyFrom.Text == "")
{
ErrorMsgLabel.Text = "舊[理貨批次]欄位不得空白";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 舊[理貨批次]欄位不得空白 ');", true);
return;
}
if (SLP_CopyToDate.Text == "")
{
ErrorMsgLabel.Text = "新[門市進貨日]欄位不得空白";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[門市進貨日]欄位不得空白 ');", true);
return;
}
if (Convert.ToDateTime(SLP_CopyToDate.Text) <= DateTime.Now)
{
ErrorMsgLabel.Text = "新[門市進貨日]欄位不得小於等於系統日";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[門市進貨日]欄位不得小於等於系統日 ');", true);
return;
}
if (txtPickBatchCopyTo.Text == "")
{
ErrorMsgLabel.Text = "新[理貨批次]欄位不得空白";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[理貨批次]欄位不得空白 ');", true);
return;
}
#endregion
System.IO.TextReader tr;
CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
try
{
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
string strWhere = "";
// 檢查新日期是否有資料-----------------------------------------------------------------------------------------
#region checking
DataTable DtCheckNew;
ParameterList.Clear();
ParameterList.Add(this.SLP_CopyToDate.Text.Trim());
ParameterList.Add(this.txtPickBatchCopyTo.Text.Trim());
DtCheckNew = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
if (DtCheckNew.Rows.Count > 0)
{
ErrorMsgLabel.Text = "輸入的新門市進貨日已有資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 輸入的新門市進貨日已有資料 ');", true);
return;
}
#endregion
// 檢查舊日期是否有資料 , 如有資料則進行複製--------------------------------------------------------------------
#region checking
DataTable DtCheckOld;
ParameterList.Clear();
ParameterList.Add(this.SLP_CopyFromDate.Text.Trim());
ParameterList.Add(this.txtPickBatchCopyFrom.Text.Trim());
DtCheckOld = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
if (DtCheckOld.Rows.Count == 0)
{
ErrorMsgLabel.Text = "輸入的舊門市進貨日沒有資料可以複製";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 輸入的舊門市進貨日沒有資料可以複製 ');", true);
return;
}
else
{
for (int i = 0; i <= DtCheckOld.Rows.Count - 1; i++)
{
ParameterList.Clear();
ParameterListDel.Clear();
ParameterList.Add(DtCheckOld.Rows[i]["NAME"]);
ParameterList.Add(DtCheckOld.Rows[i]["CREATEDATE"]);
ParameterList.Add(DtCheckOld.Rows[i]["CREATEUID"]);
ParameterList.Add(System.DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DtCheckOld.Rows[i]["STATUS"]);
ParameterList.Add(DtCheckOld.Rows[i]["ENABLE"]);
ParameterList.Add(DtCheckOld.Rows[i]["DPS_CODE"]);
ParameterList.Add(Convert.ToDateTime(this.SLP_CopyToDate.Text.Trim()));
ParameterList.Add(this.txtPickBatchCopyTo.Text.Trim());
ParameterList.Add(DtCheckOld.Rows[i]["LINE"]);
ParameterList.Add(DtCheckOld.Rows[i]["PICK_ORDER"]);
ParameterList.Add(DtCheckOld.Rows[i]["ROUTE"]);
ParameterList.Add(DtCheckOld.Rows[i]["STORE_CNT"]);
BCO.InsertRouteOrder(ParameterList, DBT);
}
DBT.Commit();//交易成功
}
#endregion
ErrorMsgLabel.Text = "複製完畢";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 複製完畢 ');", true);
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
ErrorMsgLabel.Text = ex.Message;
}
btnCloseCopy_Click(null, null);
}
/// <summary>
/// 列印鈕
/// </summary>
protected void btnPrintReport_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
try
{
ErrorMsgLabel.Text = "";
this.hid_PageStatus.Value = "PRINT";
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(this.SLP_SLPDate1.Text.Trim());
ParameterList.Add(this.txtPickBatch.Text.Trim());
Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
if (Dt.Rows.Count == 0)
{
this.hid_PageStatus.Value = "QUERY";
ErrorMsgLabel.Text = "查無資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 查無資料 ');", true);
txtRouteADD.Text = "";
txtRouteSort.Text = "";
Panel1.Visible = false;
Panel2.Visible = false;
//CrystalReportViewer1.Visible = false;
return;
}
else
{
#region 顯示報表
string s_FileName = ""; //設定輸出檔名
string s_rptFilePath = ""; //設定報表路徑
s_rptFilePath = Server.MapPath("./REPORT/CGD011.rpt");
s_FileName = HttpUtility.UrlEncode("理貨線順序設定.PDF", System.Text.Encoding.UTF8);
LoadCrystalReport(s_FileName, s_rptFilePath, Dt, "PDF");
#endregion
}
//預覽報表
// ShowReport(Dt);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
}
/// <summary>
/// 店數計算鈕
/// </summary>
protected void btnCount_Click(object sender, EventArgs e)
{
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
DataTable Dt = null;
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
}
if (Dt == null)
{
ErrorMsgLabel.Text = "請先查詢資料";
return;
}
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "請先查詢資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 請先查詢資料 ');", true);
return;
}
try
{
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
for (int i = 0; i <= Dt.Rows.Count - 1; i++)
{
ParameterList.Clear();
ParameterList.Add(Convert.ToDateTime(Dt.Rows[i]["ST_ACCEPT_DATE"].ToString()).ToShortDateString());
ParameterList.Add(Dt.Rows[i]["PICK_BATCH"].ToString());
ParameterList.Add(Dt.Rows[i]["ROUTE"].ToString());
DataTable Dt2 = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.CountStore, ParameterList);
Dt.Rows[i]["STORE_CNT"] = Dt2.Rows[0][0].ToString().Trim();
}
Session[SessionIDName] = Dt;
//將temp資料重新bind一次至GridView1,2,3
if (Dt != null)
{
DataTable tempDT1 = Dt.Copy();
DataTable tempDT2 = Dt.Copy();
DataTable tempDT3 = Dt.Copy();
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
string SessionIDName2 = "CGD011_2_" + PageTimeStamp.Value;
string SessionIDName3 = "CGD011_3_" + PageTimeStamp.Value;
Session[SessionIDName1] = tempDT1;
Session[SessionIDName2] = tempDT2;
Session[SessionIDName3] = tempDT3;
DataView DV1 = tempDT1.DefaultView;
DataView DV2 = tempDT2.DefaultView;
DataView DV3 = tempDT3.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV2.RowFilter = "LINE = 'Y'";
DV3.RowFilter = "LINE = 'Z'";
DV1.Sort = "PICK_ORDER ASC";
DV2.Sort = "PICK_ORDER ASC";
DV3.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView2.DataSource = DV2;
GridView3.DataSource = DV3;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView2.PageIndex = 0;
GridView3.PageIndex = 0;
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
#region 計算總店數
int totalStoreX = 0;
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
totalStoreX += Convert.ToInt32(((Label)(GridView1.Rows[i].FindControl("Label5"))).Text);
}
lblTotalX.Text = "總計店數：" + Convert.ToString(totalStoreX);
int totalStoreY = 0;
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
totalStoreY += Convert.ToInt32(((Label)(GridView2.Rows[i].FindControl("Label5"))).Text);
}
lblTotalY.Text = "總計店數：" + Convert.ToString(totalStoreY);
int totalStoreZ = 0;
for (int i = 0; i <= GridView3.Rows.Count - 1; i++)
{
totalStoreZ += Convert.ToInt32(((Label)(GridView3.Rows[i].FindControl("Label5"))).Text);
}
lblTotalZ.Text = "總計店數：" + Convert.ToString(totalStoreZ);
#endregion
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
/// <summary>
/// 匯出確定鈕
/// </summary>
protected void btnExportSubmit_Click(object sender, EventArgs e)
{
#region 檢查輸入值
if (txtExportPath.Text.Trim() == "")
{
ErrorMsgLabel.Text = "[匯出路徑]欄位不得空白";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' [匯出路徑]欄位不得空白 ');", true);
return;
}
if (txtExportCount.Text.Trim() == "0")
{
ErrorMsgLabel.Text = "無資料可匯出";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 無資料可匯出 ');", true);
return;
}
#endregion
try
{
//---讀取資料
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim());
ParameterList.Add(txtPickBatch.Text.Trim());
Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.ExpRoute, ParameterList);
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "無資料可匯出";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 無資料可匯出 ');", true);
return;
}
//---輸出至文字檔
System.Text.StringBuilder sb_Out_String = new System.Text.StringBuilder();
Response.Clear();
Response.Buffer = true;
Response.Charset = "BIG5";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(txtExportPath.Text.Trim()));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.ContentType = "application/ms-txt";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
foreach (DataRow dRow in Dt.Rows)
{
sb_Out_String.Remove(0, sb_Out_String.Length);
sb_Out_String.Append(dRow["DATA"].ToString());
Response.Write(sb_Out_String.ToString());
Response.Write(oHtmlTextWriter.NewLine);
}
Response.End();
ErrorMsgLabel.Text = "匯出完畢";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 匯出完畢 ');", true);
}
catch (System.UnauthorizedAccessException a)
{
ErrorMsgLabel.Text = "匯出失敗，對該路徑無寫入權限";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 匯出失敗，對該路徑無寫入權限 ');", true);
}
catch (System.IO.DirectoryNotFoundException b)
{
ErrorMsgLabel.Text = "匯出失敗，請確認儲存路徑正確";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 匯出失敗，請確認儲存路徑正確 ');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// 匯出鈕
/// </summary>
protected void btnExport_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
DataTable Dt = null;
try
{
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(this.SLP_SLPDate1.Text.Trim());
ParameterList.Add(this.txtPickBatch.Text.Trim());
Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
txtExportPath.Text = @"P:\DPS\理貨優先順序.TXT";
txtExportCount.Text = Convert.ToString(Dt.Rows.Count);
panExport.Visible = true;
}
}
/// <summary>
/// 確定鈕(匯入視窗)
/// </summary>
protected void btnPanImportSubmit_Click(object sender, EventArgs e)
{
#region 檢查輸入值
if (ddlRouteImport.SelectedItem.Text == "")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('請先選擇理貨路線');", true);
return;
}
#endregion
DataTable Dt = null;
DataTable DtImport = null;
DataView tempDT = new DataView();
try
{
//從DB讀取匯入資料
string SessionIDNameM = "CGD011_" + PageTimeStamp.Value;
string SessionIDName = "CGD011_ImportDB_" + PageTimeStamp.Value;
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(hidSLPDate1.Text);
ParameterList.Add(hidtxtPickBatch.Text);
DtImport = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.ImpRoute, ParameterList);
if (Session[SessionIDNameM] != null)
{
Dt = (DataTable)Session[SessionIDNameM];
}
else
{
ParameterList.Clear();
Dt = BCO.QuerySwitch(CGDModel.MaintainSetRouteOrder.QueryType.Empty, ParameterList);
}
tempID = 0;
tempDT.Table = Dt.Copy();
tempDT.Sort = "ID ASC";
if (Dt.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[tempDT.Count - 1]["ID"].ToString());
}
for (int M = 0; M <= DtImport.Rows.Count - 1; M++)
{
DataRow dRow = Dt.NewRow();
//ID和CODE暫自訂, 真正寫入CO時會重取
int v_ID = tempID + 1;
int v_CODE = tempID + 1;
dRow["ID"] = v_ID;
dRow["CODE"] = v_CODE;
dRow["CREATEDATE"] = DateTime.Now;
dRow["UPDATEDATE"] = DateTime.Now;
dRow["CREATEUID"] = Session["UID"].ToString();
dRow["UPDATEUID"] = Session["UID"].ToString();
dRow["STATUS"] = "1";
dRow["ENABLE"] = "1";
dRow["NAME"] = "";
dRow["DPS_CODE"] = "A";
dRow["ST_ACCEPT_DATE"] = hidSLPDate1.Text;
dRow["PICK_BATCH"] = hidtxtPickBatch.Text;
dRow["LINE"] = ddlRouteImport.SelectedItem.Text;
dRow["ROUTE_NAME"] = DtImport.Rows[M]["ROUTE_NAME"].ToString();
dRow["STORE_CNT"] = 0;
string repeat = "";
int tempPickOrder = 0;
#region 找出該線最後一號
tempPickOrder = 0;
DataView dv = new DataView();
dv.Table = Dt.Copy();
dv.RowFilter = "LINE ='" + ddlRouteImport.SelectedItem.Text + "'";
dv.Sort = "PICK_ORDER ASC";
DataTable tempDt = dv.ToTable();
if (tempDt.Rows.Count != 0)
{
tempPickOrder = Convert.ToInt32(tempDt.Rows[tempDt.Rows.Count - 1]["PICK_ORDER"].ToString());
}
else
{
tempPickOrder = 0;
}
#endregion
tempPickOrder += 1;
string _tempPickOrder = Convert.ToString(tempPickOrder);
if (_tempPickOrder.Length == 1)
{
_tempPickOrder = "00" + _tempPickOrder;
}
else if (_tempPickOrder.Length == 2)
{
_tempPickOrder = "0" + _tempPickOrder;
}
dRow["PICK_ORDER"] = _tempPickOrder;
#region Check使用者所輸入之路線是否有重複
for (int i = 0; i <= Dt.Rows.Count - 1; i++)
{
if (Dt.Rows[i]["ROUTE"].ToString() == DtImport.Rows[M]["ROUTE"].ToString().Trim())
{
repeat = "Y";
}
}
if (repeat == "Y")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('欲匯入之路線已重複');", true);
return;
}
else
{
dRow["ROUTE"] = DtImport.Rows[M]["ROUTE"].ToString();
}
#endregion
Dt.Rows.Add(dRow);
}
Session[SessionIDNameM] = Dt;
DataTable tempDT1 = Dt.Copy();
DataTable tempDT2 = Dt.Copy();
DataTable tempDT3 = Dt.Copy();
string SessionIDName1 = "CGD011_1_" + PageTimeStamp.Value;
string SessionIDName2 = "CGD011_2_" + PageTimeStamp.Value;
string SessionIDName3 = "CGD011_3_" + PageTimeStamp.Value;
Session[SessionIDName1] = tempDT1;
Session[SessionIDName2] = tempDT2;
Session[SessionIDName3] = tempDT3;
DataView DV1 = tempDT1.DefaultView;
DataView DV2 = tempDT2.DefaultView;
DataView DV3 = tempDT3.DefaultView;
DV1.RowFilter = "LINE = 'X'";
DV2.RowFilter = "LINE = 'Y'";
DV3.RowFilter = "LINE = 'Z'";
DV1.Sort = "PICK_ORDER ASC";
DV2.Sort = "PICK_ORDER ASC";
DV3.Sort = "PICK_ORDER ASC";
GridView1.DataSource = DV1;
GridView2.DataSource = DV2;
GridView3.DataSource = DV3;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView2.PageIndex = 0;
GridView3.PageIndex = 0;
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
Panel2.Visible = true;
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('匯入完畢');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
/// <summary>
/// 匯入鈕(開啟匯入視窗)
/// </summary>
protected void btnImport_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
try
{
this.hidSLPDate1.Text = this.SLP_SLPDate1.Text.Trim();
this.hidtxtPickBatch.Text = this.txtPickBatch.Text.Trim();
if (Convert.ToDateTime(hidSLPDate1.Text) <= DateTime.Now)
{
ErrorMsgLabel.Text = "[門市進貨日]小於等於系統日時無法執行匯入功能";
//ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert('[門市進貨日]小於等於系統日時無法執行匯入功能');", true);
return;
}
// 檢查新日期是否有資料-----------------------------------------------------------------------------------------
DataTable DtCheckNew;
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(this.hidSLPDate1.Text.Trim());
ParameterList.Add(this.hidtxtPickBatch.Text.Trim());
DtCheckNew = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList);
if (DtCheckNew.Rows.Count > 0)
{
ErrorMsgLabel.Text = "所輸入的門市進貨日已有資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 所輸入的門市進貨日已有資料 ');", true);
return;
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
panImport.Visible = true;
ddlRouteImport.SelectedIndex = 0;
}
}
/// <summary>
/// 儲存鈕
/// </summary>
protected void btnSave_Click1(object sender, EventArgs e)
{
string SessionIDName = "CGD011_" + PageTimeStamp.Value;
DataTable Dt = null;
DataTable DT_Add = null;
DataTable DT_Mod = null;
DataTable DT_Del = null;
if (Session[SessionIDName] != null)
{
Dt = (DataTable)Session[SessionIDName];
DT_Add = Dt.GetChanges(DataRowState.Added);
DT_Mod = Dt.GetChanges(DataRowState.Modified);
DT_Del = Dt.GetChanges(DataRowState.Deleted);
}
else
{
ErrorMsgLabel.Text = "目前無資料異動";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 目前無資料異動 ');", true);
return;
}
if (DT_Add == null && DT_Mod == null && DT_Del == null)
{
ErrorMsgLabel.Text = "目前無資料異動";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 目前無資料異動 ');", true);
return;
}
CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB);
try
{
//刪除----------------------------------------------------------------------------------------------------------
if (DT_Del != null)
{
foreach (DataRow dRow in DT_Del.Rows)
{
ParameterList.Clear();
ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Original].ToString());
ParameterList.Add(Convert.ToDateTime(dRow["ST_ACCEPT_DATE", DataRowVersion.Original].ToString()).ToShortDateString());
ParameterList.Add(dRow["ROUTE", DataRowVersion.Original].ToString());
ParameterList.Add(Convert.ToDateTime(dRow["UPDATEDATE", DataRowVersion.Original].ToString()));
ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Original].ToString());
string MSG = BCO.DeleteRouteOrder(ParameterList, DBT);
if (MSG == "NODATA")
{
throw new Exception("DB_NODATA");
}
}
}
//新增----------------------------------------------------------------------------------------------------------
if (DT_Add != null)
{
foreach (DataRow dRow in DT_Add.Rows)
{
ParameterList.Clear();
if (DT_Add.Columns.Contains("NAME").ToString() == "True")
{
ParameterList.Add(dRow["NAME"]);
}
else
{
ParameterList.Add(dRow["LINE"].ToString() + "-" + dRow["ROUTE"].ToString());
}
ParameterList.Add(dRow["CREATEDATE"]);
ParameterList.Add(dRow["CREATEUID"]);
ParameterList.Add(dRow["UPDATEDATE"]);
ParameterList.Add(dRow["UPDATEUID"]);
if (DT_Add.Columns.Contains("STATUS").ToString() == "True")
{
ParameterList.Add(dRow["STATUS"]);
}
else
{
ParameterList.Add(0);
}
ParameterList.Add(dRow["ENABLE"]);
ParameterList.Add(dRow["DPS_CODE"]);
ParameterList.Add(Convert.ToDateTime(dRow["ST_ACCEPT_DATE"]).ToShortDateString());
ParameterList.Add(dRow["PICK_BATCH"]);
ParameterList.Add(dRow["LINE"]);
ParameterList.Add(dRow["PICK_ORDER"]);
ParameterList.Add(dRow["ROUTE"]);
ParameterList.Add(dRow["STORE_CNT"]);
BCO.InsertRouteOrder(ParameterList, DBT);
}
}
//修改----------------------------------------------------------------------------------------------------------
if (DT_Mod != null)
{
foreach (DataRow dRow in DT_Mod.Rows)
{
ParameterList.Clear();
ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["NAME", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["DPS_CODE", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["ST_ACCEPT_DATE", DataRowVersion.Current]);
ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["LINE", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["PICK_ORDER", DataRowVersion.Current].ToString());
ParameterList.Add(dRow["ROUTE", DataRowVersion.Current].ToString());
ParameterList.Add(Convert.ToInt32(dRow["STORE_CNT", DataRowVersion.Current].ToString()));
ParameterList.Add(Convert.ToDateTime(dRow["CREATEDATE", DataRowVersion.Original].ToString()));
ParameterList.Add(dRow["CREATEUID", DataRowVersion.Original].ToString());
ParameterList.Add(Convert.ToDateTime(dRow["UPDATEDATE", DataRowVersion.Original].ToString()));
ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Original].ToString());
ParameterList.Add(Convert.ToInt16(dRow["STATUS", DataRowVersion.Original].ToString()));
ParameterList.Add(Convert.ToInt16(dRow["ENABLE", DataRowVersion.Original].ToString()));
ParameterList.Add(dRow["NAME", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["DPS_CODE", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["ST_ACCEPT_DATE", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["LINE", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["PICK_ORDER", DataRowVersion.Original].ToString());
ParameterList.Add(dRow["ROUTE", DataRowVersion.Original].ToString());
ParameterList.Add(Convert.ToInt32(dRow["STORE_CNT", DataRowVersion.Original].ToString()));
string MSG = BCO.UpdateRouteOrder(ParameterList, DBT);
if (MSG == "NODATA")
{
throw new Exception("DB_NODATA");
}
}
}
DBT.Commit();//交易成功
btnQuery_Click(null, null);
ErrorMsgLabel.Text = "儲存完畢";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 儲存完畢 ');", true);
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
if (ex.Message.IndexOf("違反必須為唯一的限制條件") > 0)
{
ErrorMsgLabel.Text = "新增之站所已重複";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD281.aspx", "alert(' 新增之站所已重複 ');", true);
return;
}
if (ex.Message.IndexOf("NODATA") > 0)
{
ErrorMsgLabel.Text = "原資料已異動過，請重新查詢資料後再作處理";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD281.aspx", "alert(' 原資料已異動過，請重新查詢資料後再作處理 ');", true);
return;
}
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}