/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void QueryData() { #region string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); DataTable dt = null; dt = BCO.QUERY_TRN_CODE_MAIN(GetQueryParams()); Session[SessionIDName] = dt; Int32 iRowCount = 0; aryParamsPKey.Clear(); GridView1.DataSource = dt; GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); if (dt != null && dt.Rows.Count > 0) { iRowCount = dt.Rows.Count; foreach (DataRow dr in dt.Rows) { #region aryParamsPKey.Add(dr["ID"].ToString()); #endregion } } else { ErrorMsgLabel.Text = "查無資料"; } Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey; LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount); #endregion }
}//btn_Save_Click protected void btn_Delete_Click(object sender, EventArgs e) { #region try { #region if (txt_CODE.Text != "") { #region bool bResult = false; string strErrMsg = ""; TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); bResult = BCO.DEL_TRN_CODE_MAIN(GetQueryParams(), null, out strErrMsg); if (bResult) { ErrorMsgLabel.Text = "刪除成功"; string strJS = string.Format("alert('刪除成功');location.replace('TRN101.aspx?Code=TRN10&PageTimeStamp={0}');", PageTimeStamp.Value); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DELETE_OK", strJS, true); } else { ErrorMsgLabel.Text = "刪除失敗:" + strErrMsg; } #endregion } else { ErrorMsgLabel.Text = "請輸入代碼"; } #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }//btn_Delete_Click
/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void QueryData() { #region try { txt_CODE.Text = ""; txt_NAME.Text = ""; txt_EXPLAIN.Text = ""; TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); DataTable dt = null; ArrayList ParameterList = new ArrayList(); ParameterList.Add(s_ID); dt = BCO.QUERY_TRN_CODE_MAIN_BY_ID(ParameterList); if (dt != null && dt.Rows.Count > 0) { txt_CODE.Text = dt.Rows[0]["CODE"].ToString().Trim(); txt_NAME.Text = dt.Rows[0]["NAME"].ToString().Trim(); txt_EXPLAIN.Text = dt.Rows[0]["EXPLAIN"].ToString().Trim(); } else { ErrorMsgLabel.Text = "查無資料或原始資料已被刪除"; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
protected void btn_Save_Click(object sender, EventArgs e) { #region try { #region if (txt_CODE.Text != "") { if (CurrentPageMode == PageCurrentMode.Insert) { #region TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); string strID = "", strErrMsg = ""; bool bResult = false; bResult = BCO.ADD_TRN_CODE_MAIN(GetQueryParams(), null, out strID, out strErrMsg); if (bResult && strErrMsg == "") { ArrayList aryTmp = new ArrayList(); aryTmp.Clear(); aryTmp.Add(strID); aryParamsPKey = aryTmp; s_ID = strID; CurrentPageMode = PageCurrentMode.Readonly; SetControlsByCurrentPageMode(); ErrorMsgLabel.Text = "新增成功"; } else { ErrorMsgLabel.Text = strErrMsg; } #endregion } else if (CurrentPageMode == PageCurrentMode.Edit) { #region TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); string strID = "", strErrMsg = ""; bool bResult = false; bResult = BCO.UPDATE_TRN_CODE_MAIN(GetQueryParams(), null, out strErrMsg); if (bResult && strErrMsg == "") { CurrentPageMode = PageCurrentMode.Readonly; SetControlsByCurrentPageMode(); ErrorMsgLabel.Text = "更新成功"; } else { ErrorMsgLabel.Text = strErrMsg; } #endregion } } else { ErrorMsgLabel.Text = "請輸入代碼"; } #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; UpdatePanel1.Update(); } #endregion }//btn_Save_Click
public static string GetCategoryNameAtServer(string str_CATEGORY) { #region string strResult = ""; try { string strPID = "", strCategory_Name = ""; TRNModel.VDS_TRN10_BCO BCO = new TRNModel.VDS_TRN10_BCO(ConnectionDB); DataTable dt = null; ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(str_CATEGORY); ParameterList.Add(null); ParameterList.Add(1); dt = BCO.QUERY_TRN_CODE_MAIN(ParameterList); /* m.ID, m.code, m.NAME, m.createdate, m.createuid, m.updatedate, m.updateuid, m.ENABLE, m.EXPLAIN */ if (dt != null && dt.Rows.Count > 0) { strPID = dt.Rows[0][0].ToString(); strCategory_Name = dt.Rows[0][2].ToString(); } else { strCategory_Name = "查無資料"; } strResult = string.Format("{0}||{1}||{2}", strPID, str_CATEGORY, strCategory_Name); } catch (Exception ex) { throw ex; } return strResult; #endregion }