protected void btnSave_Click(object sender, EventArgs e)
{
try
{
PolicyHarmonyInfo Harmony = GetVaule();
if (Request.QueryString["id"] != null)
{
Harmony.Id = Guid.Parse(Request.QueryString["id"]);
}
if (Harmony != null)
{
try
{
PolicyManageService.SetPolicyHarmony(Harmony);
if (Harmony.Id == Guid.Empty)
{
RegisterScript("alert('添加成功');window.location.href='./policy_coordination_manage.aspx'", true);
}
else
{
RegisterScript("alert('修改成功');window.location.href='./policy_coordination_manage.aspx'", true);
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "政策协调添加/修改");
}
}
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "政策协调修改/添加");
}
}
private PolicyHarmonyInfo GetVaule()
{
string airline = "";
foreach (ListItem item in chkAirlineList.Items)
{
if (item.Selected)
{
airline += item.Value + ",";
}
}
if (airline == "")
{
ShowMessage("没有选择航空公司，请先选择！");
return(null);
}
airline = airline.Substring(0, airline.Length - 1);
try
{
hidTime.Value = hidTime.Value == "" ? DateTime.Now + "" : hidTime.Value;
PolicyHarmonyInfo Harmony = new PolicyHarmonyInfo
{
Account = this.CurrentUser.UserName,
Airlines = airline,
Arrival = txtArrivalAirports.AirportsCode.Join("/"),
Departure = txtDepartureAirports.AirportsCode.Join("/"),
//CityLimit = "",
DeductionType = radSubCommission.Checked ? Common.Enums.DeductionType.Subordinate : Common.Enums.DeductionType.Profession,
EffectiveLowerDate = DateTime.Parse(txtTimeStart.Text),
EffectiveUpperDate = DateTime.Parse(txtTimeEnd.Text),
HarmonyValue = decimal.Parse(txtXieTiao.Text) / 100,
// IsVIP = false,
LastModifyTime = DateTime.Now,
LastModifyName = this.CurrentUser.UserName,
CreateTime = DateTime.Parse(hidTime.Value),
Remark = txtRemark.Text
};
if (chkPolicyBargin.Checked)
{
Harmony.PolicyType |= Common.Enums.PolicyType.Bargain;
}
if (chkPolicyNormal.Checked)
{
Harmony.PolicyType |= Common.Enums.PolicyType.Normal;
}
return(Harmony);
}
catch (Exception ex)
{
ShowExceptionMessage(ex, "政策协调修改/添加");
}
return(null);
}
private void InitValue()
{
if (Request.QueryString["id"] != null)
{
PolicyHarmonyInfo hoarmony = PolicyManageService.GetPolicyHarmonyInfo(Guid.Parse(Request.QueryString["id"]));
if (hoarmony != null)
{
//选择曾经的航空公司
foreach (ListItem item in chkAirlineList.Items)
{
foreach (string str in hoarmony.Airlines.Split(','))
{
if (item.Value == str)
{
item.Selected = true;
break;
}
}
}
//始发地
txtDepartureAirports.AirportsCode = hoarmony.Departure.Split('/');
//目的地
txtArrivalAirports.AirportsCode = hoarmony.Arrival.Split('/');
chkPolicyBargin.Checked = (hoarmony.PolicyType & Common.Enums.PolicyType.Bargain) == Common.Enums.PolicyType.Bargain;
chkPolicyNormal.Checked = (hoarmony.PolicyType & Common.Enums.PolicyType.Normal) == Common.Enums.PolicyType.Normal;
radSubCommission.Checked = (hoarmony.DeductionType == Common.Enums.DeductionType.Subordinate);
radIntCommission.Checked = (hoarmony.DeductionType == Common.Enums.DeductionType.Profession);
txtTimeStart.Text = hoarmony.EffectiveLowerDate.Date.ToString("yyyy-MM-dd");
txtTimeEnd.Text = hoarmony.EffectiveUpperDate.Date.ToString("yyyy-MM-dd");
txtXieTiao.Text = (hoarmony.HarmonyValue * 100).TrimInvaidZero();
txtRemark.Text = hoarmony.Remark;
hidTime.Value = hoarmony.CreateTime.ToString();
}
}
}
public IEnumerable <PolicyHarmonyInfo> QueryPolicyHarmonyInfos(Pagination pagination, PolicyHarmonyQueryParameter condition)
{
IList <PolicyHarmonyInfo> result = new List <PolicyHarmonyInfo>();
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
if (!string.IsNullOrEmpty(condition.Departure))
{
dbOperator.AddParameter("@iDeparture", condition.Departure);
}
if (!string.IsNullOrEmpty(condition.Arrival))
{
dbOperator.AddParameter("@iArrival", condition.Arrival);
}
if (!string.IsNullOrEmpty(condition.Airline))
{
dbOperator.AddParameter("@iAirline", condition.Airline);
}
if (condition.PolicyType.HasValue)
{
dbOperator.AddParameter("@iPolicyType", condition.PolicyType.Value);
}
if (condition.EffectTimeStart.HasValue)
{
dbOperator.AddParameter("@iEffectiveLowerDate", condition.EffectTimeStart.Value);
}
if (condition.EffectTimeEnd.HasValue)
{
dbOperator.AddParameter("@iEffectiveUpperDate", condition.EffectTimeEnd.Value);
}
dbOperator.AddParameter("@iPageIndex", pagination.PageIndex);
dbOperator.AddParameter("@iPageSize", pagination.PageSize);
System.Data.Common.DbParameter totalCount = dbOperator.AddParameter("@oTotalCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (var reader = dbOperator.ExecuteReader("[dbo].[P_QueryPolicyHarmonys]", System.Data.CommandType.StoredProcedure))
{
while (reader.Read())
{
var info = new PolicyHarmonyInfo();
info.Id = reader.GetGuid(0);
info.Airlines = reader.GetString(1);
info.Departure = reader.GetString(2);
info.Arrival = reader.GetString(3);
info.PolicyType = (Common.Enums.PolicyType)reader.GetInt32(4);
info.EffectiveLowerDate = reader.GetDateTime(5);
info.EffectiveUpperDate = reader.GetDateTime(6);
info.DeductionType = (Common.Enums.DeductionType)reader.GetInt32(7);
info.HarmonyValue = reader.GetDecimal(8);
info.Remark = reader.GetString(9);
info.Account = reader.GetString(10);
info.CreateTime = reader.GetDateTime(11);
info.LastModifyTime = reader.GetDateTime(12);
info.LastModifyName = reader.GetString(13);
result.Add(info);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
