public void addDb(getModifyAndRefundStipulatesReply rep)
{
try
{
string seatId = "0";
string lastModifiedAt = "2000-01-01 00:00:00";
int i = 0;
FlightAirRuleDAL airRuleBll = new FlightAirRuleDAL();
ShowProcessIngLog(DateTime.Now + ":开始添加退改签规定包：" + rep.modifyAndRefundStipulateList.Length);
//获取记录并添加到数据库中
for (i = 0; i < rep.modifyAndRefundStipulateList.Length; i++)
{
FlightAirRule airRule = new FlightAirRule();
airRule.id = System.Guid.NewGuid().ToString();
airRule.returnn = HttpUtility.UrlDecode(rep.modifyAndRefundStipulateList[i].refundStipulate, System.Text.Encoding.UTF8);
airRule.endorsement = HttpUtility.UrlDecode(rep.modifyAndRefundStipulateList[i].modifyStipulate, System.Text.Encoding.UTF8);
lastModifiedAt = rep.modifyAndRefundStipulateList[i].modifiedAt;
seatId = rep.modifyAndRefundStipulateList[i].seatId.ToString();
airRule.seatclass = rep.modifyAndRefundStipulateList[i].seatCode;
airRule.change = HttpUtility.UrlDecode(rep.modifyAndRefundStipulateList[i].changeStipulate, System.Text.Encoding.UTF8);
airRule.airline = rep.modifyAndRefundStipulateList[i].airlineCode;
try
{
int r = airRuleBll.Add(airRule);
if (r == 0)
{
ShowProcessIngLog("添加航空公司客规失败：" + rep.modifyAndRefundStipulateList[i].airlineCode + rep.modifyAndRefundStipulateList[i].seatCode + rep.modifyAndRefundStipulateList[i].seatId);
}
}
catch (Exception ex)
{
}
}
if (i >= rep.modifyAndRefundStipulateList.Length)
{
ShowProcessIngLog(DateTime.Now + ":添加完成：" + rep.modifyAndRefundStipulateList.Length + ",保存最后一次信息:Info=" + lastModifiedAt + "|" + seatId);
SaveLastUpTimeAndId(lastModifiedAt + "|" + seatId, "AirKGLog");
}
}
catch (Exception ex)
{ }
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FlightAirRule model)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FlightAirRule(");
strSql.Append("id,airline,seatclass,returnn,endorsement,returnndis,isdel,createby,createtime,change)");
strSql.Append(" values (");
strSql.Append("@id,@airline,@seatclass,@returnn,@endorsement,@returnndis,@isdel,@createby,@createtime,@change)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar, 50),
new SqlParameter("@airline", SqlDbType.VarChar, 50),
new SqlParameter("@seatclass", SqlDbType.VarChar, 50),
new SqlParameter("@returnn", SqlDbType.NVarChar),
new SqlParameter("@endorsement", SqlDbType.NVarChar),
new SqlParameter("@returnndis", SqlDbType.VarChar, 50),
new SqlParameter("@isdel", SqlDbType.Bit, 1),
new SqlParameter("@createby", SqlDbType.Int, 4),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@change", SqlDbType.NVarChar)
};
parameters[0].Value = model.id;
parameters[1].Value = model.airline;
parameters[2].Value = model.seatclass;
parameters[3].Value = model.returnn;
parameters[4].Value = model.endorsement;
parameters[5].Value = model.returnndis;
parameters[6].Value = model.isdel;
parameters[7].Value = model.createby;
parameters[8].Value = model.createtime;
parameters[9].Value = model.change;
int r = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(r);
}
catch (Exception ex)
{
return(1);
}
}
