protected void gvProductList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Enabled")
{
var id = (SpecialProductType)Convert.ToInt32(e.CommandArgument);
var air = SpecialProductService.Query(id);
if (air != null)
{
var view = new SpecialProductView(id)
{
Description = air.Description,
Enabled = !air.Enabled,
Explain = air.Explain,
Name = air.Name
};
try
{
SpecialProductService.Update(view, CurrentUser.UserName);
RegisterScript("alert('" + (air.Enabled ? "禁用成功！" : "启用成功！") + "')");
}
catch (Exception ex)
{
ShowExceptionMessage(ex, air.Enabled ? "禁用" : "启用");
return;
}
Datainit();
}
}
}
/// <summary>
/// 修改特殊产品
/// </summary>
/// <param name="view"></param>
public static void Update(SpecialProductView view, string account)
{
SpecialProducts.Instance.Update(view);
// 记录日志
var content = string.Format("将特殊产品 [{0}] 修改为 状态:{1} 名称:{2} 说明:{3} 描述:{4} ", view.SpecialProductType.GetDescription(), view.Enabled, view.Name, view.Explain, view.Description);
var log = new Service.Log.Domain.OperationLog(OperationModule.特殊产品管理, OperationType.Update, account, OperatorRole.Platform, ((int)view.SpecialProductType).ToString(), content, DateTime.Now);
Service.LogService.SaveOperationLog(log);
}
public int Update(SpecialProductView value)
{
string sql = "UPDATE dbo.T_SpecialProduct SET Name=@Name,Explain=@Explain,Description=@Description,Enabled=@Enabled WHERE Type=@Type";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Type", value.SpecialProductType);
dbOperator.AddParameter("Name", value.Name);
dbOperator.AddParameter("Explain", value.Explain);
dbOperator.AddParameter("Description", value.Description);
dbOperator.AddParameter("Enabled", value.Enabled);
return(dbOperator.ExecuteNonQuery(sql));
}
}
private object RecommandSelector(InstructionalFlight flight)
{
Flight f = flight.OriginalFlight;
SpecialProductView specialPolicyInfo = SpecialProductService.Query(flight.OriginalPolicy.Type);
return(new
{
AirlineCode = f.Airline,
f.AirlineName,
f.FlightNo,
Aircraft = f.AirCraft,
f.Departure,
f.Arrival,
YBPrice = f.StandardPrice,
f.AirportFee,
BAF = f.BAF.Adult,
AdultBAF = f.BAF.Adult,
ChildBAF = f.BAF.Child,
f.IsStop,
LowerPrice = flight.SettleAmount,
f.DaysInterval,
TakeoffTime = String.Format("{0:00}:{1:00}", f.TakeoffTime.Hour, f.TakeoffTime.Minute),
f.FlightDate,
LandingTime = String.Format("{0:00}:{1:00}", f.LandingTime.Hour, f.LandingTime.Minute),
SeatCount = flight.ResourceAmount,
SuccessOrderCount = flight.Statistic.Total.SuccessTicketCount,
OrderSuccessRate = (flight.Statistic.Total.OrderSuccessRate * 100).TrimInvaidZero() + "%",
gradeFirst = Math.Floor(flight.CompannyGrade),
gradeSecond = flight.CompannyGrade / 0.1m % 10,
flight.IsRepeated,
policyId = flight.OriginalPolicy.Id,
policyType = (int)flight.OriginalPolicy.PolicyType,
publisher = flight.OriginalPolicy.Owner,
officeNo = flight.OriginalPolicy.OfficeCode,
needAUTH = flight.OriginalPolicy.NeedAUTH,
EIList = getProvisionList(flight.OriginalPolicy),
Condition = ReplaceEnter(flight.OriginalPolicy.Condition),
PolicyDesc = ReplaceEnter(specialPolicyInfo.Description),
spType = ReplaceEnter(specialPolicyInfo.Name),
specialPolicy = ReplaceEnter(flight.OriginalPolicy.Type.ToString()),
needApplication = flight.OriginalPolicy.ConfirmResource,
WarnInfo =
(flight.OriginalPolicy.Type == SpecialProductType.CostFree && !flight.OriginalPolicy.IsSeat)
? "这是候补票<a class='tips_btn standby_ticket'>什么是候补票？</a>"
: flight.OriginalPolicy.ConfirmResource ? "<a class='tips_btn'>什么是申请？</a>" : String.Empty,
});
}
IEnumerable <KeyValuePair <SpecialProductType, SpecialProductView> > Data.RepositoryCache <SpecialProductType, SpecialProductView> .IRepository.Query()
{
var result = new List <KeyValuePair <SpecialProductType, SpecialProductView> >();
string sql = "SELECT Type,Name,Explain,Description,Enabled FROM dbo.T_SpecialProduct";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
using (var reader = dbOperator.ExecuteReader(sql))
{
while (reader.Read())
{
var item = new SpecialProductView((SpecialProductType)reader.GetByte(0))
{
Name = reader.GetString(1),
Explain = reader.GetString(2),
Description = reader.GetString(3),
Enabled = reader.GetBoolean(4)
};
result.Add(new KeyValuePair <SpecialProductType, SpecialProductView>(item.SpecialProductType, item));
}
}
}
return(result);
}
public int Insert(SpecialProductView value)
{
throw new NotImplementedException();
}
public void Update(SpecialProductView value)
{
_repositoryCache.Update(value.SpecialProductType, value);
}
