/// <summary> /// 增加一条数据 /// </summary> public int Add(TravelAgent.Model.CustomOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CustomOrder("); strSql.Append("Jindians,CustomType,LineDay,LinePeopleNumber,PeoplePrice,TravelDate,LinkName,LinkTelephone,OtherMsg)"); strSql.Append(" values ("); strSql.Append("@Jindians,@CustomType,@LineDay,@LinePeopleNumber,@PeoplePrice,@TravelDate,@LinkName,@LinkTelephone,@OtherMsg)"); SqlParameter[] parameters = { new SqlParameter("@Jindians", SqlDbType.NVarChar, 500), new SqlParameter("@CustomType", SqlDbType.Int), new SqlParameter("@LineDay", SqlDbType.Int), new SqlParameter("@LinePeopleNumber", SqlDbType.Int), new SqlParameter("@PeoplePrice", SqlDbType.Int), new SqlParameter("@TravelDate", SqlDbType.VarChar, 50), new SqlParameter("@LinkName", SqlDbType.VarChar, 50), new SqlParameter("@LinkTelephone", SqlDbType.VarChar, 50), new SqlParameter("@OtherMsg", SqlDbType.Text) }; parameters[0].Value = model.Jindians; parameters[1].Value = model.CustomType; parameters[2].Value = model.LineDay; parameters[3].Value = model.LinePeopleNumber; parameters[4].Value = model.PeoplePrice; parameters[5].Value = model.TravelDate; parameters[6].Value = model.LinkName; parameters[7].Value = model.LinkTelephone; parameters[8].Value = model.OtherMsg; return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
protected void Page_Load(object sender, EventArgs e) { if (Request["jingdian"] != null) { TravelAgent.Model.CustomOrder order = new TravelAgent.Model.CustomOrder(); order.Jindians = Request["jingdian"]; order.CustomType = Convert.ToInt32(Request["type"]); order.LineDay = Convert.ToInt32(Request["days"]); order.LinePeopleNumber = Convert.ToInt32(Request["renshu"]); order.PeoplePrice = Convert.ToInt32(Request["price"]); order.TravelDate = Request["shijian"]; order.LinkName = Request["xingming"]; order.LinkTelephone = Request["dianhua"]; order.OtherMsg = Request["remark"]; try { if (bll.Add(order) > 0) { Response.Write("true"); } else { Response.Write("false"); } } catch { Response.Write("false"); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TravelAgent.Model.CustomOrder model) { int lineid = 0; if (dal.Add(model) > 0) { lineid = dal.GetMaxID("Id"); } return(lineid); }
/// <summary> /// 得到一个对象实体 /// </summary> public TravelAgent.Model.CustomOrder GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from CustomOrder "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; TravelAgent.Model.CustomOrder model = new TravelAgent.Model.CustomOrder(); 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.Jindians = ds.Tables[0].Rows[0]["Jindians"].ToString(); model.CustomType = int.Parse(ds.Tables[0].Rows[0]["CustomType"].ToString()); model.LineDay = int.Parse(ds.Tables[0].Rows[0]["LineDay"].ToString()); model.LinePeopleNumber = int.Parse(ds.Tables[0].Rows[0]["LinePeopleNumber"].ToString()); model.PeoplePrice = int.Parse(ds.Tables[0].Rows[0]["PeoplePrice"].ToString()); model.TravelDate = ds.Tables[0].Rows[0]["TravelDate"].ToString(); model.LinkName = ds.Tables[0].Rows[0]["LinkName"].ToString(); model.LinkTelephone = ds.Tables[0].Rows[0]["LinkTelephone"].ToString(); model.AddDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["AddDate"].ToString()); return(model); } else { return(null); } }