不輕的部落格

#在SERVER端

 public object GetSysCloseDate(object[] objParam)
        {

            //創建資料庫連接
            IDbConnection connection = (IDbConnection)AllocateConnection(GetClientInfo(ClientInfoType.LoginDB).ToString());

            //打開連接
            if (connection.State != ConnectionState.Open)
            {
                connection.Open();
            }
            IDbTransaction transaction = connection.BeginTransaction();
            try
            {
                string execsql = "SELECT  convert(varchar(10), SysCloseDate, 111) SysCloseDate FROM SYS_PARM";
                DataSet ds = ExecuteSql(execsql, connection, transaction);
                string retval = ds.Tables[0].Rows[0]["SysCloseDate"].ToString();
                return new object[] { 0, retval };
            }
            catch
            {
                transaction.Rollback();
                return new object[] { 0, false };
            }
            finally
            {
                ReleaseConnection(GetClientInfo(ClientInfoType.LoginDB).ToString(), connection);
            }
        }

#在JqHttpHandler.cs

case "_sysclosedate":
                {
                    strval = EFClientTools.ClientUtility.Client.CallMethod(EFClientTools.ClientUtility.ClientInfo, "SSYS_PARM", "GetSysCloseDate", null).ToString();
                    break;
                }