Laserfiche WebLink
<br />cheeksheet_header_ <br />ree <br /> <br />Exchanges are simply handled as elements of the Water Information Sheet and stored <br />in the database table exchanges. An exchange is never released. Instead, an exchange <br />is considered valid over the entire day of the Water Information Sheet with which it <br />was submitted. If it is valid on the following day, it must be resubmitted with that <br />day's sheet. <br /> <br />An exchange is set, or submitted to the database, with the function <br /> <br />void SQLlnsertNewExchange(int wdfromin, int sidfromin, <br />intwdtoin, int sidtoin, double adminnoin, float <br />amountin, char*comment), <br /> <br />which takes all the elements of the new exchange as arguments. <br /> <br />A list of exchanges that were in effect during a period of lime are retrieved with the <br />two functions: <br /> <br />int GetAIIExchangesFromTolnit(char*start_d, <br />char*end_d) <br /> <br />and <br /> <br />int GetAIIExchangesFromToNextSQL( (return arguments)). <br /> <br />The Ini t function opens the cursor, and the Next function fetches rows from the <br />table. <br /> <br />Denver Checksheet <br /> <br />This section describes the design and function of the Denver Checksheet. The <br />following data structures comprise the Denver Checksheet: <br />checksheet_header_recandchecksheet_record. <br /> <br />typedef struct cshr { <br />int new; <br />int dirty; <br />char editable; <br />int edit_day; <br />char date[ll]; <br />char inherit_date [11] ; <br />int number_checksheet_rows: <br />checksheet_record * data; <br />} checksheet_header_rec; <br /> <br />Where: <br /> <br />. new: A flag indicating that the sheet is not stored in the database, but was copied <br />from a previous month. <br /> <br />. dirty: A flag indicating that the sheet has been edited. <br />. edi table: A flag indicating that the user may edit the sbeet. <br /> <br />36 <br />