public static DataSet GetPPriceList( string aircompany, string departPort, string arrivePort, string cabin,Boolean flag= false ) { string sql = " SELECT ID, AirCompany,DepartCode,ArriveCode,ServerGrade,Cabin,Price,Agio,SaleBeginTime,SaleEndTime,TravelBeginTime,TravelEndTime FROM PPrice WHERE `Status`=1 AND SaleEndTime>NOW() AND TravelEndTime>NOW() " ; if (aircompany != "" ) { sql += " and AirCompany=' " + aircompany + " ' " ; } if (departPort != "" ) { sql += " and DepartCode=' " + departPort + " ' " ; } if (arrivePort != "" ) { sql += " and ArriveCode=' " + arrivePort + " ' " ; } if (cabin != "" ) { sql += " and Cabin=' " + cabin + " ' " ; } sql += " ORDER BY ModifyTime DESC " ; DataSet ds = null ; using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(MySqlHelper.ConnectionString)) { if (ConnectionState.Open != conn.State) conn.Open(); if (flag) { MySql.Data.MySqlClient.MySqlTransaction tra = conn.BeginTransaction(IsolationLevel.ReadUncommitted); ds = MySqlHelper.ExecuteDataset(tra, CommandType.Text, sql); tra.Commit(); } else { ds = MySqlHelper.ExecuteDataset(conn, CommandType.Text, sql); } } return ds; }
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
