/// <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
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; }
/// <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 }