我不是普通的忙 ＃·￥％……％￥ 很累啊~~~~~

MercyGodlikE

虽然我不了解这些@@
但是我的鼓励了解你的感受
加油加油

MercyGodlikE

虽然我不了解这些咚咚
但是我的鼓励了解你的难受
加油加油

goodhermit95

他们都不知道……某人动不动就摇我……一Online就中摇很烦你知道吗

goodday

1. 
   
2.                 /// <summary>
   
3.                 /// Retrive the a set of bookings information from database base on the pass-in criteria.
   
4.                 /// </summary>
   
5.                 /// <param name="roomid">A Room ID. 0 to search all.</param>
   
6.                 /// <param name="from">A minute stamp value. The begining of a time range to be searched.</param>
   
7.                 /// <param name="to">A minute stamp value. The ending of a time range to be searched.</param>
   
8.                 /// <param name="host">Host of booking. Empty ("") to search all.</param>
   
9.                 /// <param name="part">Participants of booking. Empty ("") to search all.</param>
   
10.                 /// <param name="purposeid">A Purpose ID. 0 to search all.</param>
    
11.                 /// <param name="rem">Remarks of booking. Empty ("") to search all.</param>
    
12.                 /// <param name="active">Search Enabled=1.</param>
    
13.                 /// <param name="canceled">Search Enabled=0.</param>
    
14.                 /// <param name="userid">A User ID. 0 to search all.</param>
    
15.                 /// <returns>Bookings information.</returns>
    
16.                 public static DB.viwBookingDataTable GetBookings( int roomid, long from, long to, string host, string part, int purposeid, string rem, bool active, bool canceled, int userid )
    
17.                 {
    
18.                         string sql = "SELECT * FROM "+db.viwBooking.TableName+" WHERE 1=1 ";
    
19.                         if( roomid!=0 ) sql += "AND "+db.viwBooking._tblbooking_RoomIDColumn.ColumnName +" = "+roomid+" ";
    
20.                         sql += "AND ( ";
    
21.                         sql += "("+db.viwBooking.BookingFromColumn.ColumnName +" >= "+from+" AND "+db.viwBooking.BookingFromColumn.ColumnName +" <= "+to+") OR ";
    
22.                         sql += "("+db.viwBooking.BookingToColumn.ColumnName +" >= "+from+" AND "+db.viwBooking.BookingToColumn.ColumnName +" <= "+to+") ";
    
23.                         sql += ") ";
    
24.                         if( host!="" ) sql += "AND "+db.viwBooking.BookingHostColumn.ColumnName +" LIKE '"+FixLikeStr(host)+"' ";
    
25.                         if( part!="" ) sql += "AND "+db.viwBooking.BookingParticipantColumn.ColumnName +" LIKE '"+FixLikeStr(part)+"' ";
    
26.                         if( purposeid!=0 ) sql += "AND "+db.viwBooking._tblbooking_PurposeIDColumn.ColumnName +" = "+purposeid+" ";
    
27.                         if( rem!="" ) sql += "AND "+db.viwBooking.BookingRemColumn.ColumnName +" LIKE '"+FixLikeStr(rem)+"' ";
    
28.                         if( active && !canceled ) sql += "AND "+db.viwBooking.BookingEnabledColumn.ColumnName +" = 1 ";
    
29.                         else if( !active && canceled ) sql += "AND "+db.viwBooking.BookingEnabledColumn.ColumnName +" = 0 ";
    
30.                         if( userid!=0 ) sql += "AND "+db.viwBooking._tblbooking_UserIDColumn.ColumnName +" = "+userid+" ";
    
31.                         sql += "ORDER BY "+db.viwBooking.BookingFromColumn.ColumnName;
    
32.                         //
    
33.                         DB.viwBookingDataTable dt = new SmartMeeting.DataAccess.DB.viwBookingDataTable();
    
34.                         if( ExecuteQuery(sql,dt) ) return dt;
    
35.                         else return new DB.viwBookingDataTable();
    
36.                 }
    

复制代码

死jason kow 你的东西那么 pro 我怎样跟 啊！！！！！

goodday

30k 行的
死 jason kow
死 jason kow

winform 改 webform　不是人做的

忙到死！！！！！！！！！！！！！

Super-Tomato

一個檔3萬行

怎麼不改用 dll 調用不是更好嗎? 還是 webform 方式不能調用 dll?

goodday

逻辑太复杂咯
算我我要命

goodhermit95

Gox2base里面的Programmer你最强？


goodday: 请用 gox2base 代替啦

[ 本帖最后由 goodday 于 2008-11-28 04:52 PM 编辑 ]

goodday

我是书童而已。。。。。

goodhermit95

为什么不能用gogo？