Beispiel #1
0
    private void BindData()
    {
        ErrorMsgLabel.Text = "";

        CAAModel.MaintainDueRecord BCO = new CAAModel.MaintainDueRecord(ConntionDB);
        ParameterList.Clear();
        ParameterList.Add("");//ID
        ParameterList.Add(ViewState["DUE_NO"].ToString());//DUE_NO
        DataTable dt = BCO.QueryDetail(ParameterList);
        if (dt.Rows.Count > 0)
        {
            txtDUE_NO.Text = dt.Rows[0]["DUE_NO"].ToString().Trim();
            SLP_SOURCE_TYPE.Text = dt.Rows[0]["SOURCE_TYPE"].ToString().Trim();
            txtGROUP_NO.Text = dt.Rows[0]["GROUP_NO"].ToString().Trim();
            SLP_STORE_ID.Text = dt.Rows[0]["STORE_ID"].ToString().Trim();
            txtZ_O.Text = dt.Rows[0]["Z_O"].ToString().Trim();
            txtRFNO.Text = dt.Rows[0]["RFNO"].ToString().Trim();
            txtSAL_ID.Text = dt.Rows[0]["SAL_ID"].ToString().Trim();
            txtAC_ID.Text = dt.Rows[0]["AC_UID"].ToString().Trim();
            SLP_ROOT_NO.Text = dt.Rows[0]["ROOT_NO"].ToString().Trim();
            ddlTaxType.Text = dt.Rows[0]["TAX_TYPE"].ToString().Trim();
            SLP_DUE_AMT.Text = dt.Rows[0]["DUE_AMT"].ToString().Trim();
            SLP_SUM_DUE_AMT.Text = dt.Rows[0]["SUM_DUE_AMT"].ToString().Trim();
            SLP_DUE_REMAIN_AMT.Text = dt.Rows[0]["DUE_REMAIN_AMT"].ToString().Trim();
            txtMEMO.Text = dt.Rows[0]["MEMO"].ToString().Trim();
            txtCLOSE_MONTH.Text = dt.Rows[0]["CLOSE_MONTH"].ToString().Trim();
            SLP_CREATEDATE.Text = dt.Rows[0]["CREATEDATE"].ToString().Trim();
            SLP_CREATEUID.Text = dt.Rows[0]["CREATEUID"].ToString().Trim();
            SLP_UPDATEDATE.Text = dt.Rows[0]["UPDATEDATE"].ToString().Trim();
            SLP_UPDATEUID.Text = dt.Rows[0]["UPDATEUID"].ToString().Trim();
            hdf_Old_CreateDate.Value = dt.Rows[0]["CREATEDATE"].ToString().Trim();
            hdf_Old_UpdateDate.Value = dt.Rows[0]["UPDATEDATE"].ToString().Trim();
            hdf_Old_UpdateUID.Value = dt.Rows[0]["UPDATEUID"].ToString().Trim();
        }
        else
        {
            txtDUE_NO.Text = string.Empty;
            SLP_SOURCE_TYPE.Text = string.Empty;
            txtGROUP_NO.Text = string.Empty;
            SLP_STORE_ID.Text = string.Empty;
            txtZ_O.Text = string.Empty;
            txtRFNO.Text = string.Empty;
            txtSAL_ID.Text = string.Empty;
            txtAC_ID.Text = string.Empty;
            SLP_ROOT_NO.Text = string.Empty;
            ddlTaxType.Text = string.Empty;
            SLP_DUE_AMT.Text = string.Empty;
            SLP_SUM_DUE_AMT.Text = string.Empty;
            SLP_DUE_REMAIN_AMT.Text = string.Empty;
            txtMEMO.Text = string.Empty;
            txtCLOSE_MONTH.Text = string.Empty;
            SLP_CREATEDATE.Text = string.Empty;
            SLP_CREATEUID.Text = string.Empty;
            SLP_UPDATEDATE.Text = string.Empty;
            SLP_UPDATEUID.Text = string.Empty;
            hdf_Old_CreateDate.Value = string.Empty;
            hdf_Old_UpdateDate.Value = string.Empty;
            hdf_Old_UpdateUID.Value = string.Empty;

            ErrorMsgLabel.Text = "查無資料";
            if (ViewState["READMODE"] != null)
                if (ViewState["READMODE"].ToString().Trim() == "TOOLBAR")
                    ErrorMsgLabel.Text = "查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!";
        }
    }