public bool Update(DateTime pDate, uint pBusCode, string pDriverCode, int pOwnerCode, uint pLineCode, int pZoneCode, uint pPrice) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery(@"SELECT Code FROM AUTDailyPerformanceRportOnBus WHERE CAST(Date as date)=CAST('" + pDate.ToString("yyyy-MM-dd") + @"' as date) AND BusCode=@BusCode AND DriverCode=@DriverCode AND OwnerCode=@OwnerCode AND LineCode=@LineCode AND ZoneCode=@ZoneCode AND DocumentCode <> 0 AND DocumentCode IS NOT Null "); DB.AddParams("Date", pDate); DB.AddParams("BusCode", Convert.ToInt32(pBusCode)); DB.AddParams("DriverCode", pDriverCode); DB.AddParams("OwnerCode", pOwnerCode); DB.AddParams("LineCode", Convert.ToInt32(pLineCode)); DB.AddParams("ZoneCode", pZoneCode); DB.AddParams("Price", Convert.ToInt32(pPrice)); System.Data.DataTable DT = DB.Query_DataTable(); if (DT.Rows.Count > 1) { } else if (DT.Rows.Count == 1) { DB.setQuery(@"UPDATE AUTDailyPerformanceRportOnBus SET Price=Price+@Price , TCount=TCount+1 WHERE Code = " + DT.Rows[0][0].ToString()); if (DB.Query_Execute() >= 0) { return(true); } return(false); } else { DB.setQuery(@"INSERT INTO AUTDailyPerformanceRportOnBus (Code,Date,BusCode,DriverCode,OwnerCode,LineCode,ZoneCode,Price,TCount) Values( isnull((Select MAX(Code) From AUTDailyPerformanceRportOnBus), 0) + 1, @Date, @BusCode, @DriverCode, @OwnerCode, @LineCode, @ZoneCode, @Price, 1 )"); if (DB.Query_Execute() >= 0) { return(true); } return(false); } } finally { DB.Dispose(); } return(false); }