tourismproh.cs.svn-base

走吧旅游网站前后台源代码

					new SqlParameter("@SetAddres", SqlDbType.NVarChar,200)};
			parameters[0].Value = model.LinesProID;
			parameters[1].Value = model.LinesID;
			parameters[2].Value = model.ReceiveCityID;
			parameters[3].Value = model.LinesProName;
			parameters[4].Value = model.LinesProType;
			parameters[5].Value = model.LinesProGroup;
			parameters[6].Value = model.TeamCode;
			parameters[7].Value = model.DayAmount;
			parameters[8].Value = model.OutTeamDate;
			parameters[9].Value = model.OutTeamTime;
			parameters[10].Value = model.ReBackTeamDate;
			parameters[11].Value = model.ReBackTeamTime;
			parameters[12].Value = model.OverDate;
			parameters[13].Value = model.SendTeamPlan;
			parameters[14].Value = model.ReturnRules;
			parameters[15].Value = model.Insurance;
			parameters[16].Value = model.AmountMan;
			parameters[17].Value = model.LeastAmountMan;
			parameters[18].Value = model.OutTraffic;
			parameters[19].Value = model.ReBackTraffic;
			parameters[20].Value = model.EmergancyPhone;
			parameters[21].Value = model.SalesAuthority;
			parameters[22].Value = model.RecUserID;
			parameters[23].Value = model.RecDate;
			parameters[24].Value = model.State;
			parameters[25].Value = model.OutCityID;
			parameters[26].Value = model.InCityID;
			parameters[27].Value = model.Traffic;
			parameters[28].Value = model.ShopManPrice;
			parameters[29].Value = model.PeerManPrice;
			parameters[30].Value = model.InterManPrice;
			parameters[31].Value = model.ShopChildrenPrice;
			parameters[32].Value = model.PeerChildrenPrice;
			parameters[33].Value = model.InterChildrenPrice;
			parameters[34].Value = model.SetAddres;

			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public void Delete(string LinesProID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete TourismProH ");
			strSql.Append(" where LinesProID=@LinesProID ");
			SqlParameter[] parameters = {
					new SqlParameter("@LinesProID", SqlDbType.NVarChar,50)};
			parameters[0].Value = LinesProID;

			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public Maticsoft.Model.TourismProH GetModel(string LinesProID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select LinesProID,LinesID,ReceiveCityID,LinesProName,LinesProType,LinesProGroup,TeamCode,DayAmount,OutTeamDate,OutTeamTime,ReBackTeamDate,ReBackTeamTime,OverDate,SendTeamPlan,ReturnRules,Insurance,AmountMan,LeastAmountMan,OutTraffic,ReBackTraffic,EmergancyPhone,SalesAuthority,RecUserID,RecDate,State,OutCityID,InCityID,Traffic,ShopManPrice,PeerManPrice,InterManPrice,ShopChildrenPrice,PeerChildrenPrice,InterChildrenPrice,SetAddres from TourismProH ");
			strSql.Append(" where LinesProID=@LinesProID ");
			SqlParameter[] parameters = {
					new SqlParameter("@LinesProID", SqlDbType.NVarChar,50)};
			parameters[0].Value = LinesProID;

			Maticsoft.Model.TourismProH model=new Maticsoft.Model.TourismProH();
			DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				model.LinesProID=ds.Tables[0].Rows[0]["LinesProID"].ToString();
				model.LinesID=ds.Tables[0].Rows[0]["LinesID"].ToString();
				model.ReceiveCityID=ds.Tables[0].Rows[0]["ReceiveCityID"].ToString();
				model.LinesProName=ds.Tables[0].Rows[0]["LinesProName"].ToString();
				model.LinesProType=ds.Tables[0].Rows[0]["LinesProType"].ToString();
				model.LinesProGroup=ds.Tables[0].Rows[0]["LinesProGroup"].ToString();
				model.TeamCode=ds.Tables[0].Rows[0]["TeamCode"].ToString();
				if(ds.Tables[0].Rows[0]["DayAmount"].ToString()!="")
				{
					model.DayAmount=int.Parse(ds.Tables[0].Rows[0]["DayAmount"].ToString());
				}
				model.OutTeamDate=ds.Tables[0].Rows[0]["OutTeamDate"].ToString();
				model.OutTeamTime=ds.Tables[0].Rows[0]["OutTeamTime"].ToString();
				model.ReBackTeamDate=ds.Tables[0].Rows[0]["ReBackTeamDate"].ToString();
				model.ReBackTeamTime=ds.Tables[0].Rows[0]["ReBackTeamTime"].ToString();
				model.OverDate=ds.Tables[0].Rows[0]["OverDate"].ToString();
				model.SendTeamPlan=ds.Tables[0].Rows[0]["SendTeamPlan"].ToString();
				model.ReturnRules=ds.Tables[0].Rows[0]["ReturnRules"].ToString();
				model.Insurance=ds.Tables[0].Rows[0]["Insurance"].ToString();
				if(ds.Tables[0].Rows[0]["AmountMan"].ToString()!="")
				{
					model.AmountMan=int.Parse(ds.Tables[0].Rows[0]["AmountMan"].ToString());
				}
				if(ds.Tables[0].Rows[0]["LeastAmountMan"].ToString()!="")
				{
					model.LeastAmountMan=int.Parse(ds.Tables[0].Rows[0]["LeastAmountMan"].ToString());
				}
				model.OutTraffic=ds.Tables[0].Rows[0]["OutTraffic"].ToString();
				model.ReBackTraffic=ds.Tables[0].Rows[0]["ReBackTraffic"].ToString();
				model.EmergancyPhone=ds.Tables[0].Rows[0]["EmergancyPhone"].ToString();
				model.SalesAuthority=ds.Tables[0].Rows[0]["SalesAuthority"].ToString();
				model.RecUserID=ds.Tables[0].Rows[0]["RecUserID"].ToString();
				if(ds.Tables[0].Rows[0]["RecDate"].ToString()!="")
				{
					model.RecDate=DateTime.Parse(ds.Tables[0].Rows[0]["RecDate"].ToString());
				}
				if(ds.Tables[0].Rows[0]["State"].ToString()!="")
				{
					model.State=int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
				}
				model.OutCityID=ds.Tables[0].Rows[0]["OutCityID"].ToString();
				model.InCityID=ds.Tables[0].Rows[0]["InCityID"].ToString();
				model.Traffic=ds.Tables[0].Rows[0]["Traffic"].ToString();
				if(ds.Tables[0].Rows[0]["ShopManPrice"].ToString()!="")
				{
					model.ShopManPrice=decimal.Parse(ds.Tables[0].Rows[0]["ShopManPrice"].ToString());
				}
				if(ds.Tables[0].Rows[0]["PeerManPrice"].ToString()!="")
				{
					model.PeerManPrice=decimal.Parse(ds.Tables[0].Rows[0]["PeerManPrice"].ToString());
				}
				if(ds.Tables[0].Rows[0]["InterManPrice"].ToString()!="")
				{
					model.InterManPrice=decimal.Parse(ds.Tables[0].Rows[0]["InterManPrice"].ToString());
				}
				if(ds.Tables[0].Rows[0]["ShopChildrenPrice"].ToString()!="")
				{
					model.ShopChildrenPrice=decimal.Parse(ds.Tables[0].Rows[0]["ShopChildrenPrice"].ToString());
				}
				if(ds.Tables[0].Rows[0]["PeerChildrenPrice"].ToString()!="")
				{
					model.PeerChildrenPrice=decimal.Parse(ds.Tables[0].Rows[0]["PeerChildrenPrice"].ToString());
				}
				if(ds.Tables[0].Rows[0]["InterChildrenPrice"].ToString()!="")
				{
					model.InterChildrenPrice=decimal.Parse(ds.Tables[0].Rows[0]["InterChildrenPrice"].ToString());
				}
				model.SetAddres=ds.Tables[0].Rows[0]["SetAddres"].ToString();
				return model;
			}
			else
			{
			return null;
			}
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select LinesProID,LinesID,ReceiveCityID,LinesProName,LinesProType,LinesProGroup,TeamCode,DayAmount,OutTeamDate,OutTeamTime,ReBackTeamDate,ReBackTeamTime,OverDate,SendTeamPlan,ReturnRules,Insurance,AmountMan,LeastAmountMan,OutTraffic,ReBackTraffic,EmergancyPhone,SalesAuthority,RecUserID,RecDate,State,OutCityID,InCityID,Traffic,ShopManPrice,PeerManPrice,InterManPrice,ShopChildrenPrice,PeerChildrenPrice,InterChildrenPrice,SetAddres ");
			strSql.Append(" FROM TourismProH ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			return DbHelperSQL.Query(strSql.ToString());
		}

		/*
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetList(int PageSize,int PageIndex,string strWhere)
		{
			SqlParameter[] parameters = {
					new SqlParameter("@tblName", SqlDbType.VarChar, 255),
					new SqlParameter("@fldName", SqlDbType.VarChar, 255),
					new SqlParameter("@PageSize", SqlDbType.Int),
					new SqlParameter("@PageIndex", SqlDbType.Int),
					new SqlParameter("@IsReCount", SqlDbType.Bit),
					new SqlParameter("@OrderType", SqlDbType.Bit),
					new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
					};
			parameters[0].Value = "TourismProH";
			parameters[1].Value = "ID";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/

		#endregion  成员方法
	}
}