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元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
