private bool CheckPK(string strID)
{
ErrorMsgLabel.Text = "";
string N_ID = string.Empty;
string D_PICK_DATE_S = SLP_PICK_DATE.Text;
string D_PICK_DATE_E = SLP_PICK_DATE.Text;
string V_LINE_S = ddlLine.Text;
string V_LINE_E = ddlLine.Text;
string V_STATION_NO_S = txtSTATION_NO.Text;
string V_STATION_NO_E = txtSTATION_NO.Text;
string V_VENDOR = SLP_CGDVENDOR1.Text;
string V_EMP_ID = SLP_CGDEMP1.Text;
string V_ERROR_NUM_OP = string.Empty;
string N_ERROR_NUM = string.Empty;
string V_NOTES = string.Empty;
string N_ROWNUM = string.Empty;
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(D_PICK_DATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_PICK_DATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_LINE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_LINE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_STATION_NO_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_STATION_NO_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_EMP_ID, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_ERROR_NUM_OP, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_ERROR_NUM, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_ROWNUM, ParaType.Number, ParaSQL.Equal));
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConnectionDB);
DataTable dt = BCO.DoQuery(ParameterList);
if (strID == "")
{
if (dt.Rows.Count > 0)
ErrorMsgLabel.Text = "已經有相同的[理貨日期]、[理貨線]、[工作站]、[委外商]、[員工]設定資料存在";
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["ID"].ToString().Trim() != strID.Trim())
{
ErrorMsgLabel.Text = "已經有相同的[理貨日期]、[理貨線]、[工作站]、[委外商]、[員工]設定資料存在";
break;
}
}
}
if (ErrorMsgLabel.Text.Trim() == "")
return true;
else
return false;
}
protected void Btn_Delete_Click(object sender, EventArgs e)
{
if (this.hid_PageStatus.Value == "VIEW")
{
ErrorMsgLabel.Text = "";
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConnectionDB);
string N_ID = hiddenID.Value;
string D_OLD_UPDATEDATE = txtUpdateDate.Text;
string V_OLD_UPDATEUID = SLP_UPDATEUID.Text;
string D_NEW_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_NEW_UPDATEUID = Session["UID"].ToString();
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_OLD_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_OLD_UPDATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_NEW_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_NEW_UPDATEUID, ParaType.Varchar2));
BCO.DeleteOne(ParameterList);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "MSG", "alert('刪除完成');location.href='CGD331.aspx?code=CGD33';", true);
}
}
/// <summary>
/// 繫結資料到畫面控制項
/// </summary>
private bool databind(string strID)
{
bool bResult = false; //false:無資料 true:有資料
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(strID);
for (int i = 0; i < 12; i++)
{
ParameterList.Add(DBNull.Value);
}
DataTable dtData = BCO.DoQuery(ParameterList);
if (dtData.Rows.Count == 0)
{
hiddenID.Value = strID;
SLP_PICK_DATE.Text = "";
SLP_ERR.Text = "";
ddlLine.SelectedIndex = 0;
txtSTATION_NO.Text = "";
SLP_CGDVENDOR1.Text = "";
SLP_CGDEMP1.Text = "";
txtNote.Text = "";
txtCreateDate.Text = "";
SLP_CREATEUID.Text = "";
txtUpdateDate.Text = "";
SLP_UPDATEUID.Text = "";
bResult = false;
ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!";
}
else
{
hiddenID.Value = dtData.Rows[0]["ID"].ToString();
SLP_PICK_DATE.Text = dtData.Rows[0]["PICK_DATE"].ToString();
SLP_ERR.Text = dtData.Rows[0]["ERROR_NUM"].ToString();
ddlLine.Text = dtData.Rows[0]["LINE"].ToString();
txtSTATION_NO.Text = dtData.Rows[0]["STATION_NO"].ToString();
SLP_CGDVENDOR1.Text = dtData.Rows[0]["VENDOR"].ToString();
SLP_CGDEMP1.Text = dtData.Rows[0]["EMP_ID"].ToString();
txtNote.Text = dtData.Rows[0]["NOTES"].ToString();
txtCreateDate.Text = dtData.Rows[0]["CREATEDATE"].ToString();
SLP_CREATEUID.Text = dtData.Rows[0]["CREATEUID"].ToString();
txtUpdateDate.Text = dtData.Rows[0]["UPDATEDATE"].ToString();
SLP_UPDATEUID.Text = dtData.Rows[0]["UPDATEUID"].ToString();
bResult = true;
}
Session["CGD332_DT" + PageTimeStamp.Value] = dtData;
return bResult;
}//databind
protected void Btn_Save_Click(object sender, EventArgs e)
{
try
{
if (this.hid_PageStatus.Value == "INSERT")
{
if (SaveCheck() == false)
{
return;
}
if (CheckPK("") == false)
{
return;
}
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConnectionDB);
string D_PICK_DATE = SLP_PICK_DATE.Text.Trim();
string V_LINE = ddlLine.Text.Trim();
string V_STATION_NO = txtSTATION_NO.Text.Trim();
string V_VENDOR = SLP_CGDVENDOR1.Text.Trim();
string V_EMP_ID = SLP_CGDEMP1.Text.Trim();
string N_ERROR_NUM = SLP_ERR.Text.Trim();
string V_NOTES = txtNote.Text.Trim();
string D_CREATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_CREATEUID = Session["UID"].ToString();
string D_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_UPDATEUID = Session["UID"].ToString();
string strID = string.Empty;
ParameterList.Clear();
ParameterList.Add(DBPara(D_PICK_DATE, ParaType.Date));
ParameterList.Add(DBPara(V_LINE, ParaType.Varchar2));
ParameterList.Add(DBPara(V_STATION_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_EMP_ID, ParaType.Varchar2));
ParameterList.Add(DBPara(N_ERROR_NUM, ParaType.Number));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2));
ParameterList.Add(DBPara(D_CREATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_CREATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_UPDATEUID, ParaType.Varchar2));
BCO.InsertOne(ParameterList, out strID);
ArrayList arl_Key = new ArrayList();
arl_Key.Add(strID);
Session["CGD33_SortKey" + this.PageTimeStamp.Value] = arl_Key;
//用本頁新增的 PageTimeStamp
Response.Redirect("CGD332.aspx?code=CGD33&MSG=NEW&mode=VIEW&ID=" + strID + "&CGD332_PageTimeStamp=" + this.PageTimeStamp.Value, false);
}
else if (this.hid_PageStatus.Value == "EDIT")
{
if (SaveCheck() == false)
{
return;
}
if (CheckPK(hiddenID.Value.Trim()) == false)
{
return;
}
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConnectionDB);
string N_ID = hiddenID.Value;
string D_PICK_DATE = SLP_PICK_DATE.Text.Trim();
string V_LINE = ddlLine.Text.Trim();
string V_STATION_NO = txtSTATION_NO.Text.Trim();
string V_VENDOR = SLP_CGDVENDOR1.Text.Trim();
string V_EMP_ID = SLP_CGDEMP1.Text.Trim();
string N_ERROR_NUM = SLP_ERR.Text.Trim();
string V_NOTES = txtNote.Text.Trim();
string D_UPDATEDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string V_UPDATEUID = Session["UID"].ToString();
string D_OLD_UPDATEDATE = txtUpdateDate.Text;
string V_OLD_UPDATEUID = SLP_UPDATEUID.Text;
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Number));
ParameterList.Add(DBPara(D_PICK_DATE, ParaType.Date));
ParameterList.Add(DBPara(V_LINE, ParaType.Varchar2));
ParameterList.Add(DBPara(V_STATION_NO, ParaType.Varchar2));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2));
ParameterList.Add(DBPara(V_EMP_ID, ParaType.Varchar2));
ParameterList.Add(DBPara(N_ERROR_NUM, ParaType.Number));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2));
ParameterList.Add(DBPara(D_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_UPDATEUID, ParaType.Varchar2));
ParameterList.Add(DBPara(D_OLD_UPDATEDATE, ParaType.Date));
ParameterList.Add(DBPara(V_OLD_UPDATEUID, ParaType.Varchar2));
BCO.UpdateOne(ParameterList);
//用查詢頁進來的 PageTimeStamp
Response.Redirect("CGD332.aspx?code=CGD33&MSG=EDIT&mode=VIEW&ID=" + N_ID + "&CGD332_PageTimeStamp=" + Request.QueryString["CGD332_PageTimeStamp"] + "&refreshid=" + Guid.NewGuid(), false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
/// <summary>
/// 查詢資料庫取得資料
/// </summary>
private void databind()
{
string SessionIDName = "CGD331_" + PageTimeStamp.Value;
CGDModel.CGD33_BCO BCO = new CGDModel.CGD33_BCO(ConntionDB);
//N_ID in number,
//D_PICK_DATE_S in date,
//D_PICK_DATE_E in date,
//V_LINE_S in VARCHAR2,
//V_LINE_E in VARCHAR2,
//V_STATION_NO_S in VARCHAR2,
//V_STATION_NO_E in VARCHAR2,
//V_VENDOR in VARCHAR2,
//V_EMP_ID in VARCHAR2,
//V_ERROR_NUM_OP in VARCHAR2,
//N_ERROR_NUM in number,
//V_NOTES in VARCHAR2,
//N_ROWNUM in number,
string N_ID = string.Empty;
string D_PICK_DATE_S = SLP_PICK_DATE.StartDate;
string D_PICK_DATE_E = SLP_PICK_DATE.EndDate;
string V_LINE_S = ddlLineStart.Text;
string V_LINE_E = ddlLineEnd.Text;
string V_STATION_NO_S = txtSTATION_NO_S.Text;
string V_STATION_NO_E = txtSTATION_NO_E.Text;
string V_VENDOR = SLP_CGDVENDOR1.Text;
string V_EMP_ID = SLP_CGDEMP1.Text;
string V_ERROR_NUM_OP = ConvertSign(SLP_ERR.Operator);
string N_ERROR_NUM = SLP_ERR.Text;
string V_NOTES = txtNote.Text.Trim();
string N_ROWNUM = TextBoxRowCountLimit.Text.Trim();
ParaSQL PSQL = ParaSQL.Equal;
if (CheckBoxLikeSearch.Checked == true)
PSQL = ParaSQL.Like;
ParameterList.Clear();
ParameterList.Add(DBPara(N_ID, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(D_PICK_DATE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(D_PICK_DATE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_LINE_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_LINE_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_STATION_NO_S, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_STATION_NO_E, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_VENDOR, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_EMP_ID, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(V_ERROR_NUM_OP, ParaType.Varchar2, ParaSQL.Equal));
ParameterList.Add(DBPara(N_ERROR_NUM, ParaType.Number, ParaSQL.Equal));
ParameterList.Add(DBPara(V_NOTES, ParaType.Varchar2, PSQL));
ParameterList.Add(DBPara(N_ROWNUM, ParaType.Number, ParaSQL.Equal));
DataTable Dt = BCO.DoQuery(ParameterList);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
if (TextBoxPagesize.Text == "0")
{
GridView1.PageSize = 1;
}
else
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
}
GridView1.PageIndex = 0;
GridView1.DataBind();
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in Dt.Rows)
{ arl_Key.Add(drRow["ID"].ToString()); }
Session["CGD33_SortKey" + this.PageTimeStamp.Value] = arl_Key;
#endregion
#region 檢查回傳資料
if (Dt.Rows.Count == 0)
{ this.ErrorMsgLabel.Text = "查無資料"; }
#endregion
}
