/// <summary> /// 增加一条数据 /// </summary> public void Add(TravelAgent.Model.LineOrderTourist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LineOrderTourist("); strSql.Append("orderId,touristName,touristSex,mobile,papersType,papersNo,birthDate,touristType)"); strSql.Append(" values ("); strSql.Append("@orderId,@touristName,@touristSex,@mobile,@papersType,@papersNo,@birthDate,@touristType)"); SqlParameter[] parameters = { new SqlParameter("@orderId", SqlDbType.Int), new SqlParameter("@touristName", SqlDbType.VarChar), new SqlParameter("@touristSex", SqlDbType.VarChar), new SqlParameter("@mobile", SqlDbType.VarChar), new SqlParameter("@papersType", SqlDbType.Int), new SqlParameter("@papersNo", SqlDbType.VarChar), new SqlParameter("@birthDate", SqlDbType.VarChar), new SqlParameter("@touristType", SqlDbType.Int) }; parameters[0].Value = model.orderId; parameters[1].Value = model.touristName; parameters[2].Value = model.touristSex; parameters[3].Value = model.mobile; parameters[4].Value = model.papersType; parameters[5].Value = model.papersNo; parameters[6].Value = model.birthDate; parameters[7].Value = model.touristType; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.LineOrderTourist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LineOrderTourist set "); strSql.Append("orderId=@orderId,"); strSql.Append("touristName=@touristName,"); strSql.Append("touristSex=@touristSex,"); strSql.Append("mobile=@mobile,"); strSql.Append("papersType=@papersType,"); strSql.Append("papersNo=@papersNo,"); strSql.Append("birthDate=@birthDate,"); strSql.Append("touristType=@touristType"); strSql.Append(" where id=@Id "); SqlParameter[] parameters = { new SqlParameter("@orderId", SqlDbType.Int), new SqlParameter("@touristName", SqlDbType.VarChar), new SqlParameter("@touristSex", SqlDbType.VarChar), new SqlParameter("@mobile", SqlDbType.VarChar), new SqlParameter("@papersType", SqlDbType.Int), new SqlParameter("@papersNo", SqlDbType.VarChar), new SqlParameter("@birthDate", SqlDbType.VarChar), new SqlParameter("@touristType", SqlDbType.Int), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.orderId; parameters[1].Value = model.touristName; parameters[2].Value = model.touristSex; parameters[3].Value = model.mobile; parameters[4].Value = model.papersType; parameters[5].Value = model.papersNo; parameters[6].Value = model.birthDate; parameters[7].Value = model.touristType; parameters[8].Value = model.id; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public TravelAgent.Model.LineOrderTourist GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from LineOrderTourist "); strSql.Append(" where id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; TravelAgent.Model.LineOrderTourist model = new TravelAgent.Model.LineOrderTourist(); 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.orderId = int.Parse(ds.Tables[0].Rows[0]["orderId"].ToString()); model.touristName = ds.Tables[0].Rows[0]["touristName"].ToString(); model.touristSex = ds.Tables[0].Rows[0]["touristSex"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.papersType = int.Parse(ds.Tables[0].Rows[0]["papersType"].ToString()); model.papersNo = ds.Tables[0].Rows[0]["papersNo"].ToString(); model.birthDate = ds.Tables[0].Rows[0]["birthDate"].ToString(); model.touristType = int.Parse(ds.Tables[0].Rows[0]["touristType"].ToString()); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.LineOrderTourist model) { DAL.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TravelAgent.Model.LineOrderTourist model) { DAL.Add(model); return(DAL.GetMaxID("Id")); }