123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 |
- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- namespace FPER
- {
- public class DacFieldConfig : DacBase
- {
- public DacFieldConfig(int ID)
- : base(ID)
- {
-
-
-
-
-
-
- }
- ~DacFieldConfig()
- {
-
-
-
-
-
-
- }
-
- public bool SelectJumpField(int RECEIVER_ID)
- {
- bool ret = true;
- try
- {
- DataTable dt = null;
- String SQL = "";
- SQL += "SELECT JUMP_FIELD ";
- SQL += "FROM TB_CONFIG ";
- SQL += " WHERE RECEIVER_ID = '{0}'";
- SQL = String.Format(SQL, RECEIVER_ID);
- DataSet dao = Select(SQL);
- dt = dao.Tables[0];
- if (dt.Rows.Count > 0)
- {
- if (dt.Rows[0]["JUMP_FIELD"].ToString() == "Y")
- {
- ret = true;
- }
- else
- {
- ret = false;
- }
- }
- }
- catch (Exception ex)
- {
- Util.UErrorMessage(ex, 0, 0);
-
- }
- return ret;
- }
- public void UpdateJumpField(int RECEIVER_ID, bool Jump_Field)
- {
- try
- {
- String SQL = "UPDATE TB_CONFIG SET JUMP_FIELD = '{0}' ";
- SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
- SQL += " WHERE RECEIVER_ID = {1}";
- SQL = String.Format(SQL, (Jump_Field ? "Y" : "N"), RECEIVER_ID);
- ExecuteNonQuery(SQL);
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- }
- catch (Exception ex)
- {
- Util.UErrorMessage(ex, 0, 0);
-
- }
- }
- }
- }
|