/// <summary>
/// 返回线路名称
/// </summary>
/// <param name="id"></param>
/// <param name="orderType"></param>
public string getOrderName(int id, int orderType)
{
string strvalue = "";
if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.线路))
{
TravelAgent.Model.Line l = LineBll.GetModel(id);
if (l != null)
{
strvalue = l.LineName;
}
}
else if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.签证))
{
TravelAgent.Model.VisaList v = VisaListBll.GetModel(id);
if (v != null)
{
strvalue = v.visaName;
}
}
else if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.租车))
{
TravelAgent.Model.CarList c = CarBll.GetModel(id);
if (c != null)
{
strvalue = c.CarName;
}
}
return(strvalue);
}
/// <summary>
/// 返回线路名称
/// </summary>
/// <param name="id"></param>
/// <param name="orderType"></param>
public string getOrderName(int id, int orderType)
{
string strvalue = "";
if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.线路))
{
TravelAgent.Model.Line l = LineBll.GetModel(id);
if (l != null)
{
strvalue = "<a href=\"/Line.aspx?id=" + id + "\" target=\"_blank\" class=\"tablelink\">" + l.LineName + "</a>";
}
}
else if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.签证))
{
TravelAgent.Model.VisaList v = VisaListBll.GetModel(id);
if (v != null)
{
strvalue = "<a href=\"/visa/VisaDetail.aspx?id=" + id + "\" target=\"_blank\" class=\"tablelink\">" + v.visaName + "</a>";
}
}
else if (orderType == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.租车))
{
TravelAgent.Model.CarList c = CarBll.GetModel(id);
if (c != null)
{
strvalue = "<a href=\"/car/CarDetail.aspx?id=" + id + "\" target=\"_blank\" class=\"tablelink\">" + c.CarName + "</a>";
}
}
return(strvalue);
}
/// <summary>
/// 显示线路订单
/// </summary>
public string ShowLineOrder()
{
StringBuilder sbLineOrder = new StringBuilder();
DataSet dsLineOrder = LineOrderBll.GetList(5, "clubid=" + club.id, "orderDate desc");
string proname = "";
string propic = "";
TravelAgent.Model.Line linem = null;
TravelAgent.Model.VisaList visa = null;
foreach (DataRow r in dsLineOrder.Tables[0].Rows)
{
sbLineOrder.Append("<tr>");
sbLineOrder.Append("<td class=\"arial\">" + r["ordercode"] + "</td>");
if (Convert.ToInt32(r["orderType"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.线路))
{
linem = LineBll.GetModel(Convert.ToInt32(r["lineId"]));
if (linem != null)
{
proname = linem.LineName;
propic = linem.LinePic;
}
sbLineOrder.Append("<td class=\"order_pic\"><a href=\"/Line.aspx?id=" + r["lineId"] + "\"><img src=\"" + propic + "\" />" + proname + "</a></td>");
}
else if (Convert.ToInt32(r["orderType"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.签证))
{
visa = VisaListBll.GetModel(Convert.ToInt32(r["lineId"]));
if (visa != null)
{
proname = visa.visaName;
propic = visa.picurl;
}
sbLineOrder.Append("<td class=\"order_pic\"><a href=\"/visa/VisaDetail.aspx?id=" + r["lineId"] + "\" target=\"_blank\"><img src=\"" + propic + "\" />" + proname + "</a></td>");
}
//sbLineOrder.Append("<td class=\"order_pic\"><a href=\"/Line.aspx?id=" + r["lineId"] + "\"><img src=\"" + r["LinePic"] + "\" />" + r["ProName"] + "</a></td>");
sbLineOrder.Append("<td class=\"arial\">" + TravelAgent.Tool.EnumHelper.GetMemberName <TravelAgent.Tool.EnumSummary.OrderType>(r["orderType"]) + "</td>");
sbLineOrder.Append("<td class=\"arial order_price\">¥" + (Convert.ToInt32(r["orderPrice"]) + Convert.ToInt32(r["attachPrice"])).ToString() + "</td>");
sbLineOrder.Append("<td>" + TravelAgent.Tool.EnumHelper.GetMemberName <TravelAgent.Tool.EnumSummary.OrderState>(r["orderState"]) + "</td>");
sbLineOrder.Append("<td class=\"arial\">" + r["orderDate"] + "</td>");
if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.填写信息))
{
sbLineOrder.Append("<td class=\"order_operate\"><a target=\"_blank\" href=\"/Order2.aspx?oid=" + r["Id"] + "\">补充游客信息</a>");
}
else if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.核对订单))
{
sbLineOrder.Append("<td class=\"order_operate\"><a target=\"_blank\" href=\"/Order3.aspx?oid=" + r["Id"] + "\">核对订单</a>");
}
else if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.待付款))
{
sbLineOrder.Append("<td class=\"order_operate\"><a target=\"_blank\" href=\"/Order4.aspx?t=line&oid=" + r["Id"] + "\">付款</a>");
}
else
{
sbLineOrder.Append("<td class=\"order_operate\">");
}
sbLineOrder.Append("</td>");
sbLineOrder.Append("</tr>");
}
return(sbLineOrder.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
int id;
int uid;
if (int.TryParse(Request.QueryString["id"], out id))
{
visa = VisaListBll.GetModel(id);
if (visa != null)
{
this.Title = visa.visaName + "-" + Master.webinfo.WebName;
}
}
if (int.TryParse(TravelAgent.Tool.CookieHelper.GetCookieValue("uid"), out uid))
{
club = ClubBll.GetModel(uid);
}
}
if (visa == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false); visa = new Model.VisaList();
}
if (club == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false); club = new Model.Club();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
orderid = Convert.ToInt32(Request.QueryString["id"]);
}
if (!this.IsPostBack)
{
DataBindState();
DataBindPay();
if (orderid > 0)
{
TravelAgent.Model.Order order = VisaOrderBll.GetModel(orderid);
if (order != null)
{
TravelAgent.Model.VisaList visa = VisaBll.GetModel(order.lineId);
if (visa != null)
{
this.hddonate.Value = visa.donatePoints.ToString();
}
this.hdordercode.Value = order.ordercode;
this.lblVisaName.Text = order.proName;
this.lblOrderCode.Text = order.ordercode;
this.lblOrderDate.Text = order.orderDate.ToString();
this.lblTravelDate.Text = order.TravelDate;
this.lblOrderRemark.Text = order.orderRemark;
TravelAgent.Model.Club club = ClubBll.GetModel(order.clubid);
if (club != null)
{
this.lblClubInfo.Text = club.clubName + " / " + club.clubMobile + " / " + club.clubEmail;
}
this.lblLinkName.Text = order.contactName;
this.lblEmail.Text = order.contactEmail;
this.lblTel.Text = order.contactMobile;
this.lblSex.Text = !order.contactSex.Equals("")?TravelAgent.Tool.EnumHelper.GetMemberName <TravelAgent.Tool.EnumSummary.TouristSex>(order.contactSex):"";
this.lblOrderTotalPrice.Text = order.orderPrice.ToString();
this.txtJiaJian.Value = order.subPrice.ToString();
this.txtuserPoints.Value = order.usePoints.ToString();
this.lblPayCost.Text = (order.orderPrice - order.usePoints + order.subPrice).ToString();
this.ddlPayType.SelectedValue = order.payType.ToString();
this.ddlState.SelectedValue = order.orderState.ToString();
this.txtRemark.Value = order.operRemark;
this.lblPeopleNum.Text = order.peopleNumber.ToString();
if (order.orderState == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.已付款))
{
this.lblPayState.Text = "已付款";
}
else
{
this.lblPayState.Text = "未付款";
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id;
if (Request.QueryString["id"] != null && int.TryParse(Request.QueryString["id"], out id))
{
Visa = VisaBll.GetModel(id);
}
if (Visa == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.VisaList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into VisaList(");
strSql.Append("visaName,typeId,signId,countryId,price,usePoints,donatePoints,dealTime,stayTime,enterNumber,interview,expiryDate,dealType,State,tips,needMaterial,adddate,Sort,isLock)");
strSql.Append(" values (");
strSql.Append("@visaName,@typeId,@signId,@countryId,@price,@usePoints,@donatePoints,@dealTime,@stayTime,@enterNumber,@interview,@expiryDate,@dealType,@State,@tips,@needMaterial,@adddate,@Sort,@isLock)");
SqlParameter[] parameters =
{
new SqlParameter("@visaName", SqlDbType.NVarChar, 50),
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@signId", SqlDbType.Int, 4),
new SqlParameter("@countryId", SqlDbType.Int, 4),
new SqlParameter("@price", SqlDbType.Int, 50),
new SqlParameter("@usePoints", SqlDbType.Int, 4),
new SqlParameter("@donatePoints", SqlDbType.Int, 4),
new SqlParameter("@dealTime", SqlDbType.VarChar, 50),
new SqlParameter("@stayTime", SqlDbType.VarChar, 50),
new SqlParameter("@enterNumber", SqlDbType.VarChar, 50),
new SqlParameter("@interview", SqlDbType.VarChar, 50),
new SqlParameter("@expiryDate", SqlDbType.VarChar, 50),
new SqlParameter("@dealType", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@tips", SqlDbType.Text),
new SqlParameter("@needMaterial", SqlDbType.Text),
new SqlParameter("@adddate", SqlDbType.DateTime),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@isLock", SqlDbType.Int, 4)
};
parameters[0].Value = model.visaName;
parameters[1].Value = model.typeId;
parameters[2].Value = model.signId;
parameters[3].Value = model.countryId;
parameters[4].Value = model.price;
parameters[5].Value = model.usePoints;
parameters[6].Value = model.donatePoints;
parameters[7].Value = model.dealTime;
parameters[8].Value = model.stayTime;
parameters[9].Value = model.enterNumber;
parameters[10].Value = model.interview;
parameters[11].Value = model.expiryDate;
parameters[12].Value = model.dealType;
parameters[13].Value = model.State;
parameters[14].Value = model.tips;
parameters[15].Value = model.needMaterial;
parameters[16].Value = model.adddate;
parameters[17].Value = model.Sort;
parameters[18].Value = model.isLock;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataBindType();
DataBindCountry();
DataBindCity();
DataBindCheckBoxList();
if (Request.QueryString["id"] != null)
{
TravelAgent.Model.VisaList model = VisaBll.GetModel(Convert.ToInt32(Request.QueryString["id"]));
if (model != null)
{
this.ltTag1.Text = "修改签证";
this.txtTitle.Text = model.visaName;
this.ddlType.SelectedValue = model.typeId.ToString();
this.ddlSign.SelectedValue = model.signId.ToString();
this.ddlCountry.SelectedValue = model.countryId.ToString();
this.txtPrice.Text = model.price.ToString();
this.txtUsePoints.Text = model.usePoints.ToString();
this.txtDonatePoints.Text = model.donatePoints.ToString();
this.txtDealTime.Text = model.dealTime;
this.txtStayTime.Text = model.stayTime;
this.txtEnterNumber.Text = model.enterNumber;
this.txtInterview.Text = model.interview;
this.txtExpiryDate.Text = model.expiryDate;
this.rbtnDealType.SelectedValue = model.dealType.ToString();
foreach (ListItem item in chkState.Items)
{
if (TravelAgent.Tool.CommonOprate.IsContainValue(item.Value, model.State))
{
item.Selected = true;
}
}
this.txtTips.Value = model.tips;
this.txtMaterial.Value = model.needMaterial;
this.txtSort.Text = model.Sort.ToString();
this.chkIsLock.Checked = model.isLock == 1;
}
}
else
{
this.txtSort.Text = (VisaBll.GetMaxID("Sort") + 1).ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id;
if (!this.IsPostBack && int.TryParse(Request.QueryString["id"], out id))
{
visa = VisaListBll.GetModel(id);
if (visa != null)
{
this.Title = visa.visaName + "-" + Master.webinfo.WebName;
}
}
if (visa == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false); visa = new Model.VisaList();
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
TravelAgent.Model.VisaList model = new TravelAgent.Model.VisaList();
model.visaName = this.txtTitle.Text.Trim();
model.typeId = Convert.ToInt32(this.ddlType.SelectedValue);
model.signId = Convert.ToInt32(this.ddlSign.SelectedValue);
model.countryId = Convert.ToInt32(this.ddlCountry.SelectedValue);
model.price = Convert.ToInt32(this.txtPrice.Text);
model.usePoints = Convert.ToInt32(this.txtUsePoints.Text);
model.donatePoints = Convert.ToInt32(this.txtDonatePoints.Text);
model.dealTime = this.txtDealTime.Text.Trim();
model.stayTime = this.txtStayTime.Text.Trim();
model.enterNumber = this.txtEnterNumber.Text.Trim();
model.interview = this.txtInterview.Text.Trim();
model.expiryDate = this.txtExpiryDate.Text.Trim();
model.dealType = Convert.ToInt32(this.rbtnDealType.SelectedValue);
model.State = this.hidState.Value;
model.tips = this.txtTips.Value;
model.needMaterial = this.txtMaterial.Value;
model.adddate = DateTime.Now;
model.Sort = Convert.ToInt32(this.txtSort.Text);
model.isLock = this.chkIsLock.Checked ? 1 : 0;
string stringUrl = Request.Url.ToString();
try
{
if (Request.QueryString["id"] != null)
{
model.id = Convert.ToInt32(Request.QueryString["id"]);
VisaBll.Update(model);
JscriptPrint("保存成功！", "VisaList.aspx", "Success");
}
else
{
VisaBll.Add(model);
JscriptPrint("添加成功！", "VisaList.aspx", "Success");
}
}
catch
{
JscriptPrint("保存失败！", stringUrl, "Error");
}
}
/// <summary>
/// 显示线路订单
/// </summary>
public string ShowVisaOrder()
{
StringBuilder sbVisaOrder = new StringBuilder();
DataSet dsVisaOrder = OrderBll.GetList(0, "orderType=" + Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderType.签证) + " and clubid=" + clubid, "orderDate desc");
TravelAgent.Model.VisaList model = null;
string strpicurl = "";
foreach (DataRow r in dsVisaOrder.Tables[0].Rows)
{
model = VisaListBll.GetModel(Convert.ToInt32(r["lineId"]));
if (model != null)
{
sbVisaOrder.Append("<tr>");
sbVisaOrder.Append("<td class=\"arial\">" + r["ordercode"] + "</td>");
strpicurl = model.picurl.Equals("") ? "/images/no_image.gif" : model.picurl;
sbVisaOrder.Append("<td class=\"order_pic\"><a href=\"/visa/VisaDetail.aspx?id=" + r["lineId"] + "\" target=\"_blank\"><img src=\"" + strpicurl + "\" />" + model.visaName + "</a></td>");
sbVisaOrder.Append("<td class=\"arial order_price\">¥" + (Convert.ToInt32(r["orderPrice"]) + Convert.ToInt32(r["attachPrice"]) + Convert.ToInt32(r["subPrice"])) + "</td>");
sbVisaOrder.Append("<td>" + TravelAgent.Tool.EnumHelper.GetMemberName <TravelAgent.Tool.EnumSummary.OrderState>(r["orderState"]) + "</td>");
sbVisaOrder.Append("<td class=\"arial\">" + r["orderDate"] + "</td>");
sbVisaOrder.Append("<td class=\"order_operate\">");
if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.填写信息))
{
sbVisaOrder.Append("<a target=\"_blank\" href=\"/Order2.aspx?oid=" + r["Id"] + "\">补充游客信息</a>");
}
else if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.核对订单))
{
sbVisaOrder.Append("<a target=\"_blank\" href=\"/Order3.aspx?oid=" + r["Id"] + "\">核对订单</a>");
}
else if (Convert.ToInt32(r["orderState"]) == Convert.ToInt32(TravelAgent.Tool.EnumSummary.OrderState.待付款))
{
sbVisaOrder.Append("<a target=\"_blank\" href=\"/Order4.aspx?t=visa&oid=" + r["Id"] + "\">付款</a>");
}
sbVisaOrder.Append("</td>");
sbVisaOrder.Append("</tr>");
}
}
return(sbVisaOrder.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "付款-" + Master.webinfo.WebName;
int.TryParse(Request.QueryString["oid"], out oid);
int strUid;
if (!int.TryParse(TravelAgent.Tool.CookieHelper.GetCookieValue("uid"), out strUid))
{
Response.Redirect("/member/Login.aspx");
}
else
{
club = clubBll.GetModel(strUid);
}
if (Request.QueryString["t"] != null)
{
strTag = Request.QueryString["t"];
}
if (!this.IsPostBack)
{
if (!string.IsNullOrEmpty(strTag))
{
if (oid > 0)
{
TravelAgent.Model.Order order = OrderBll.GetModel(oid);
if (order != null)
{
strOrdercode = order.ordercode;
intPeopleNumber = order.peopleNumber;
intTotalPrice = order.orderPrice + order.attachPrice + order.subPrice;
orderdate = order.orderDate;
if (strTag.Equals("line"))//线路
{
Line = LineBll.GetModel(order.lineId);
if (Line != null)
{
strOrderName = Line.LineName;
donatePoints = Line.DonatePoints;
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
else if (strTag.Equals("visa"))
{
TravelAgent.Model.VisaList visa = VisaBll.GetModel(order.lineId);
if (visa != null)
{
strOrderName = visa.visaName;
donatePoints = visa.donatePoints;
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
else if (strTag.Equals("car"))
{
TravelAgent.Model.CarList car = CarBll.GetModel(order.lineId);
if (car != null)
{
strOrderName = car.CarName;
donatePoints = 0;
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
if (club == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false); club = new Model.Club();
}
if (Line == null)
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false); Line = new Model.Line();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.VisaList model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.VisaList model)
{
dal.Add(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelAgent.Model.VisaList GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 *,(select PicUrl from VisaCountry where Id=countryId) as PicUrl,(select Name from VisaCountry where Id=countryId) as cname from VisaList ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
TravelAgent.Model.VisaList model = new TravelAgent.Model.VisaList();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.visaName = ds.Tables[0].Rows[0]["visaName"].ToString();
if (ds.Tables[0].Rows[0]["typeId"].ToString() != "")
{
model.typeId = int.Parse(ds.Tables[0].Rows[0]["typeId"].ToString());
}
if (ds.Tables[0].Rows[0]["signId"].ToString() != "")
{
model.signId = int.Parse(ds.Tables[0].Rows[0]["signId"].ToString());
}
if (ds.Tables[0].Rows[0]["countryId"].ToString() != "")
{
model.countryId = int.Parse(ds.Tables[0].Rows[0]["countryId"].ToString());
}
if (ds.Tables[0].Rows[0]["price"].ToString() != "")
{
model.price = int.Parse(ds.Tables[0].Rows[0]["price"].ToString());
}
if (ds.Tables[0].Rows[0]["usePoints"].ToString() != "")
{
model.usePoints = int.Parse(ds.Tables[0].Rows[0]["usePoints"].ToString());
}
if (ds.Tables[0].Rows[0]["donatePoints"].ToString() != "")
{
model.donatePoints = int.Parse(ds.Tables[0].Rows[0]["donatePoints"].ToString());
}
model.dealTime = ds.Tables[0].Rows[0]["dealTime"].ToString();
model.stayTime = ds.Tables[0].Rows[0]["stayTime"].ToString();
model.enterNumber = ds.Tables[0].Rows[0]["enterNumber"].ToString();
model.interview = ds.Tables[0].Rows[0]["interview"].ToString();
model.expiryDate = ds.Tables[0].Rows[0]["expiryDate"].ToString();
if (ds.Tables[0].Rows[0]["dealType"].ToString() != "")
{
model.dealType = int.Parse(ds.Tables[0].Rows[0]["dealType"].ToString());
}
model.State = ds.Tables[0].Rows[0]["State"].ToString();
model.tips = ds.Tables[0].Rows[0]["tips"].ToString();
model.needMaterial = ds.Tables[0].Rows[0]["needMaterial"].ToString();
if (ds.Tables[0].Rows[0]["adddate"].ToString() != "")
{
model.adddate = DateTime.Parse(ds.Tables[0].Rows[0]["adddate"].ToString());
}
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
model.isLock = int.Parse(ds.Tables[0].Rows[0]["isLock"].ToString());
model.picurl = ds.Tables[0].Rows[0]["PicUrl"].ToString();
model.countryName = ds.Tables[0].Rows[0]["cname"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.VisaList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update VisaList set ");
strSql.Append("visaName=@visaName,");
strSql.Append("typeId=@typeId,");
strSql.Append("signId=@signId,");
strSql.Append("countryId=@countryId,");
strSql.Append("price=@price,");
strSql.Append("usePoints=@usePoints,");
strSql.Append("donatePoints=@donatePoints,");
strSql.Append("dealTime=@dealTime,");
strSql.Append("stayTime=@stayTime,");
strSql.Append("enterNumber=@enterNumber,");
strSql.Append("interview=@interview,");
strSql.Append("expiryDate=@expiryDate,");
strSql.Append("dealType=@dealType,");
strSql.Append("State=@State,");
strSql.Append("tips=@tips,");
strSql.Append("needMaterial=@needMaterial,");
strSql.Append("adddate=@adddate,");
strSql.Append("Sort=@Sort,");
strSql.Append("isLock=@isLock ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@visaName", SqlDbType.NVarChar, 50),
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@signId", SqlDbType.Int, 4),
new SqlParameter("@countryId", SqlDbType.Int, 4),
new SqlParameter("@price", SqlDbType.Int, 50),
new SqlParameter("@usePoints", SqlDbType.Int, 4),
new SqlParameter("@donatePoints", SqlDbType.Int, 4),
new SqlParameter("@dealTime", SqlDbType.VarChar, 50),
new SqlParameter("@stayTime", SqlDbType.VarChar, 50),
new SqlParameter("@enterNumber", SqlDbType.VarChar, 50),
new SqlParameter("@interview", SqlDbType.VarChar, 50),
new SqlParameter("@expiryDate", SqlDbType.VarChar, 50),
new SqlParameter("@dealType", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@tips", SqlDbType.Text),
new SqlParameter("@needMaterial", SqlDbType.Text),
new SqlParameter("@adddate", SqlDbType.DateTime),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@isLock", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.visaName;
parameters[1].Value = model.typeId;
parameters[2].Value = model.signId;
parameters[3].Value = model.countryId;
parameters[4].Value = model.price;
parameters[5].Value = model.usePoints;
parameters[6].Value = model.donatePoints;
parameters[7].Value = model.dealTime;
parameters[8].Value = model.stayTime;
parameters[9].Value = model.enterNumber;
parameters[10].Value = model.interview;
parameters[11].Value = model.expiryDate;
parameters[12].Value = model.dealType;
parameters[13].Value = model.State;
parameters[14].Value = model.tips;
parameters[15].Value = model.needMaterial;
parameters[16].Value = model.adddate;
parameters[17].Value = model.Sort;
parameters[18].Value = model.isLock;
parameters[19].Value = model.id;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
