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 }