/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.LineSpePrice model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LineSpePrice(");
strSql.Append("lineId,lineDate,linePrice,tag)");
strSql.Append(" values (");
strSql.Append("@lineId,@lineDate,@linePrice,@tag)");
SqlParameter[] parameters =
{
new SqlParameter("@lineId", SqlDbType.Int, 4),
new SqlParameter("@lineDate", SqlDbType.VarChar, 50),
new SqlParameter("@linePrice", SqlDbType.VarChar, 250),
new SqlParameter("@tag", SqlDbType.Int)
};
parameters[0].Value = model.lineId;
parameters[1].Value = model.lineDate;
parameters[2].Value = model.linePrice;
parameters[3].Value = model.tag;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 根据编号获得集合
/// </summary>
/// <param name="lineid"></param>
/// <returns></returns>
public List <TravelAgent.Model.LineSpePrice> GetlstSpePriceByLineId(int lineid)
{
string strsql = "select * from LineSpePrice where lineId=" + lineid;
List <TravelAgent.Model.LineSpePrice> lstSpePrice = new List <TravelAgent.Model.LineSpePrice>();
using (SqlDataReader odr = DbHelperSQL.ExecuteReader(strsql))
{
TravelAgent.Model.LineSpePrice price = null;
while (odr.Read())
{
price = new TravelAgent.Model.LineSpePrice();
price.Id = odr.GetInt32(0);
price.lineId = odr.GetInt32(1);
price.lineDate = odr.GetString(2);
price.linePrice = odr.GetString(3);
price.tag = odr.GetInt32(4);
lstSpePrice.Add(price);
}
}
return(lstSpePrice);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["lineid"] != null)
{
int lineid = Convert.ToInt32(Request.QueryString["lineid"]);
string content = Request["txtMenshi_adult"] + "," + Request["txtMenshi_child"] + ",";
content += Request["txtPrice_adult"] + "," + Request["txtPrice_child"] + ",";
content += Request["txtUsePoints_adult"] + "," + Request["txtUsePoints_child"] + ",";
content += Request["txtDoPoints_adult"] + "," + Request["txtDoPoints_child"] + ",";
content += Request["txtCheng_adult"] + "," + Request["txtCheng_child"] + ",";
content += Request["txtDFC"] + ",";
content += Request["txtNumber"];
string strsetting = "";
if (Request["rbtnPlanType"].ToString().Equals("1"))
{
strsetting = Request["hidweek"];
}
else if (Request["rbtnPlanType"].ToString().Equals("2"))
{
strsetting = Request["hidday"];
}
string strsql = "update Line set priceSdate='" + Request["txtStartDate"] + "',priceEdate='" + Request["txtEndDate"] + "',";
strsql += "priceEditModel=" + Request["rbtnPlanType"] + ",priceContent='" + content + "',";
strsql += "dealType='" + Request["rbtnDealType"] + "',priceSetting='" + strsetting + "',priceCommon='" + Request["txtPrice_adult"] + "' where Id=" + lineid;
try
{
if (LineBll.Update(strsql) > 0)
{
if (Request["chkClearPrice"] != null)
{
//清除特殊价格
SpePriceBll.Delete(lineid);
}
Response.Write("true");
}
else
{
Response.Write("false");
}
}
catch
{
Response.Write("false");
}
}
if (Request.QueryString["line_id"] != null)
{
int line_id = Convert.ToInt32(Request.QueryString["line_id"]);
string content = Request["menshi_adult"] + "," + Request["menshi_child"] + ",";
content += Request["price_adult"] + "," + Request["price_child"] + ",";
content += Request["points_use_adult"] + "," + Request["points_use_child"] + ",";
content += Request["points_do_adult"] + "," + Request["points_do_child"] + ",";
content += Request["jsprice_adult"] + "," + Request["jsprice_child"] + ",";
content += Request["dfc"] + ",";
content += Request["num"];
//string strprice = Request["hidPrice"];
string strDate = Request["hidDate"];
//先删除后增加
SpePriceBll.Delete(line_id, strDate);
TravelAgent.Model.LineSpePrice price = new TravelAgent.Model.LineSpePrice();
price.lineId = line_id;
price.linePrice = content;
price.lineDate = strDate;
price.tag = 1;
if (SpePriceBll.Add(price) > 0)
{
Response.Write("true");
}
else
{
Response.Write("false");
}
}
if (Request["line_id_delete"] != null)
{
int line_id_delete = Convert.ToInt32(Request["line_id_delete"]);
string strDate = Request["line_date"];
SpePriceBll.Delete(line_id_delete, strDate);
TravelAgent.Model.LineSpePrice price = new TravelAgent.Model.LineSpePrice();
price.lineId = line_id_delete;
price.linePrice = "";
price.lineDate = strDate;
price.tag = 0;
if (SpePriceBll.Add(price) > 0)
{
Response.Write("true");
}
else
{
Response.Write("false");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.LineSpePrice model)
{
TravelAgent.Tool.CacheHelper.Clear("speprice");
return(dal.Add(model));
}