public DataTable QueryDistributionOEMList(DistributionOEMCondition condition, Pagination pagination)
{
System.Data.DataTable result = null;
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
if (condition.RegisterBeginTime.HasValue)
{
dbOperator.AddParameter("i_RegisterBeginTime", condition.RegisterBeginTime);
}
if (condition.RegisterEndTime.HasValue)
{
dbOperator.AddParameter("i_RegisterEndTime", condition.RegisterEndTime);
}
if (!string.IsNullOrWhiteSpace(condition.UserNo))
{
dbOperator.AddParameter("i_UserNo", condition.UserNo);
}
if (condition.AutorizationStatus.HasValue)
{
dbOperator.AddParameter("i_AuthorizationStatus", condition.AutorizationStatus);
}
if (!string.IsNullOrWhiteSpace(condition.DomainName))
{
dbOperator.AddParameter("i_DomainName", condition.DomainName);
}
if (!string.IsNullOrWhiteSpace(condition.AbbreviateName))
{
dbOperator.AddParameter("i_AbbreviateName", condition.AbbreviateName);
}
if (!string.IsNullOrWhiteSpace(condition.SiteName))
{
dbOperator.AddParameter("i_SiteName", condition.SiteName);
}
if (pagination != null)
{
dbOperator.AddParameter("i_PageSize", pagination.PageSize);
dbOperator.AddParameter("i_PageIndex", pagination.PageIndex);
}
DbParameter totalCount = dbOperator.AddParameter("o_RowCount");
totalCount.Direction = ParameterDirection.Output;
totalCount.DbType = DbType.Int32;
result = dbOperator.ExecuteTable("dbo.P_DistributionListPagination", CommandType.StoredProcedure);
if (pagination != null && pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
public static string Appsecret()
{
using (DbOperator dboperator = ConnectionManager.CreateReadConnection())
{
DataTable dt = dboperator.ExecuteTable(sqlstr, 30000);
if (dt.Columns.Count > 0)
{
//appid = dt.Rows[0][0].ToString();
return(dt.Rows[0][1].ToString());
}
else
{
//throw new MyException("获取AppId失败!");
return("");
}
}
}
public string GetUrl(string plateno)
{
if (string.IsNullOrEmpty(plateno))
{
throw new ArgumentNullException("plateno");
}
StringBuilder sb = new StringBuilder();
sb.Append("select * from ParkIORecord where PlateNumber=@plateno order by ");
using (DbOperator dboperator = ConnectionManager.CreateConnection()) {
dboperator.ClearParameters();
dboperator.AddParameter("plateno", plateno);
using (DataTable dt = dboperator.ExecuteTable(sb.ToString()))
{
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["EntranceImage"].ToString());
}
return(string.Empty);
}
}
}
public DataTable QueryInformRecords(InfomrRecordSearchConditoin conditoin)
{
DataTable dt = null;
using (var op = new DbOperator("System.Data.SqlClient", ConnectionManager.B3BConnectionString))
{
ClearParameters();
if (!string.IsNullOrWhiteSpace(conditoin.Carrier))
{
AddParameter("@Carrier", conditoin.Carrier);
}
else
{
AddParameter("@Carrier", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.FlightNo))
{
AddParameter("@FlightNo", conditoin.FlightNo);
}
else
{
AddParameter("@FlightNo", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Departure))
{
AddParameter("@Departure", conditoin.Departure);
}
else
{
AddParameter("@Departure", DBNull.Value);
}
if (conditoin.TransferType.HasValue)
{
AddParameter("@TransferType", (byte)conditoin.TransferType.Value);
}
else
{
AddParameter("@TransferType", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Arrival))
{
AddParameter("@Arrival", conditoin.Arrival);
}
else
{
AddParameter("@Arrival", DBNull.Value);
}
if (conditoin.PurchaserId.HasValue)
{
AddParameter("@PurchaserId", conditoin.PurchaserId.Value);
}
else
{
AddParameter("@PurchaserId", DBNull.Value);
}
if (conditoin.InformType.HasValue)
{
AddParameter("@InformMethod", (byte)conditoin.InformType.Value);
}
else
{
AddParameter("@InformMethod", DBNull.Value);
}
if (conditoin.InformResult.HasValue)
{
AddParameter("@InformResult", (byte)conditoin.InformResult.Value);
}
else
{
AddParameter("@InformResult", DBNull.Value);
}
if (conditoin.InformTimeFrom.HasValue)
{
AddParameter("@InformTimeFrom", conditoin.InformTimeFrom.Value);
}
else
{
AddParameter("@InformTimeFrom", DBNull.Value);
}
if (conditoin.InformTimeTo.HasValue)
{
AddParameter("@InformTimeTo", conditoin.InformTimeTo.Value);
}
else
{
AddParameter("@InformTimeTo", DBNull.Value);
}
System.Data.Common.DbParameter oTotalTicketCount = op.AddParameter("@oTotalCount");
oTotalTicketCount.DbType = System.Data.DbType.Int32;
oTotalTicketCount.Direction = System.Data.ParameterDirection.Output;
dt = op.ExecuteTable("dbo.P_QueryFlightInformDetail", System.Data.CommandType.StoredProcedure);
}
return(dt);
}
