📄 hotel.cs.svn-base
字号:
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace Maticsoft.DAL
{
/// <summary>
/// 数据访问类Hotel。
/// </summary>
public class Hotel
{
public Hotel()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string HotelID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from Hotel");
strSql.Append(" where HotelID=@HotelID ");
SqlParameter[] parameters = {
new SqlParameter("@HotelID", SqlDbType.NVarChar,50)};
parameters[0].Value = HotelID;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Maticsoft.Model.Hotel model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Hotel(");
strSql.Append("HotelID,HotelName,HotelEN,SpellCode,BusinessID,RegionID,HotelType,HotelStars,Rating,Introduction,Picture,UserRating,EMap,VenderID)");
strSql.Append(" values (");
strSql.Append("@HotelID,@HotelName,@HotelEN,@SpellCode,@BusinessID,@RegionID,@HotelType,@HotelStars,@Rating,@Introduction,@Picture,@UserRating,@EMap,@VenderID)");
SqlParameter[] parameters = {
new SqlParameter("@HotelID", SqlDbType.NVarChar,12),
new SqlParameter("@HotelName", SqlDbType.NVarChar,50),
new SqlParameter("@HotelEN", SqlDbType.NVarChar,30),
new SqlParameter("@SpellCode", SqlDbType.NVarChar,30),
new SqlParameter("@BusinessID", SqlDbType.NVarChar,12),
new SqlParameter("@RegionID", SqlDbType.NVarChar,12),
new SqlParameter("@HotelType", SqlDbType.NVarChar,10),
new SqlParameter("@HotelStars", SqlDbType.NVarChar,10),
new SqlParameter("@Rating", SqlDbType.NVarChar,10),
new SqlParameter("@Introduction", SqlDbType.NVarChar,100),
new SqlParameter("@Picture", SqlDbType.Image,16),
new SqlParameter("@UserRating", SqlDbType.NVarChar,10),
new SqlParameter("@EMap", SqlDbType.Image,16),
new SqlParameter("@VenderID", SqlDbType.NVarChar,12)};
parameters[0].Value = model.HotelID;
parameters[1].Value = model.HotelName;
parameters[2].Value = model.HotelEN;
parameters[3].Value = model.SpellCode;
parameters[4].Value = model.BusinessID;
parameters[5].Value = model.RegionID;
parameters[6].Value = model.HotelType;
parameters[7].Value = model.HotelStars;
parameters[8].Value = model.Rating;
parameters[9].Value = model.Introduction;
parameters[10].Value = model.Picture;
parameters[11].Value = model.UserRating;
parameters[12].Value = model.EMap;
parameters[13].Value = model.VenderID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.Hotel model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Hotel set ");
strSql.Append("HotelName=@HotelName,");
strSql.Append("HotelEN=@HotelEN,");
strSql.Append("SpellCode=@SpellCode,");
strSql.Append("BusinessID=@BusinessID,");
strSql.Append("RegionID=@RegionID,");
strSql.Append("HotelType=@HotelType,");
strSql.Append("HotelStars=@HotelStars,");
strSql.Append("Rating=@Rating,");
strSql.Append("Introduction=@Introduction,");
strSql.Append("Picture=@Picture,");
strSql.Append("UserRating=@UserRating,");
strSql.Append("EMap=@EMap,");
strSql.Append("VenderID=@VenderID");
strSql.Append(" where HotelID=@HotelID ");
SqlParameter[] parameters = {
new SqlParameter("@HotelID", SqlDbType.NVarChar,12),
new SqlParameter("@HotelName", SqlDbType.NVarChar,50),
new SqlParameter("@HotelEN", SqlDbType.NVarChar,30),
new SqlParameter("@SpellCode", SqlDbType.NVarChar,30),
new SqlParameter("@BusinessID", SqlDbType.NVarChar,12),
new SqlParameter("@RegionID", SqlDbType.NVarChar,12),
new SqlParameter("@HotelType", SqlDbType.NVarChar,10),
new SqlParameter("@HotelStars", SqlDbType.NVarChar,10),
new SqlParameter("@Rating", SqlDbType.NVarChar,10),
new SqlParameter("@Introduction", SqlDbType.NVarChar,100),
new SqlParameter("@Picture", SqlDbType.Image,16),
new SqlParameter("@UserRating", SqlDbType.NVarChar,10),
new SqlParameter("@EMap", SqlDbType.Image,16),
new SqlParameter("@VenderID", SqlDbType.NVarChar,12)};
parameters[0].Value = model.HotelID;
parameters[1].Value = model.HotelName;
parameters[2].Value = model.HotelEN;
parameters[3].Value = model.SpellCode;
parameters[4].Value = model.BusinessID;
parameters[5].Value = model.RegionID;
parameters[6].Value = model.HotelType;
parameters[7].Value = model.HotelStars;
parameters[8].Value = model.Rating;
parameters[9].Value = model.Introduction;
parameters[10].Value = model.Picture;
parameters[11].Value = model.UserRating;
parameters[12].Value = model.EMap;
parameters[13].Value = model.VenderID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string HotelID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete Hotel ");
strSql.Append(" where HotelID=@HotelID ");
SqlParameter[] parameters = {
new SqlParameter("@HotelID", SqlDbType.NVarChar,50)};
parameters[0].Value = HotelID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Hotel GetModel(string HotelID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select HotelID,HotelName,HotelEN,SpellCode,BusinessID,RegionID,HotelType,HotelStars,Rating,Introduction,Picture,UserRating,EMap,VenderID from Hotel ");
strSql.Append(" where HotelID=@HotelID ");
SqlParameter[] parameters = {
new SqlParameter("@HotelID", SqlDbType.NVarChar,50)};
parameters[0].Value = HotelID;
Maticsoft.Model.Hotel model=new Maticsoft.Model.Hotel();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
model.HotelID=ds.Tables[0].Rows[0]["HotelID"].ToString();
model.HotelName=ds.Tables[0].Rows[0]["HotelName"].ToString();
model.HotelEN=ds.Tables[0].Rows[0]["HotelEN"].ToString();
model.SpellCode=ds.Tables[0].Rows[0]["SpellCode"].ToString();
model.BusinessID=ds.Tables[0].Rows[0]["BusinessID"].ToString();
model.RegionID=ds.Tables[0].Rows[0]["RegionID"].ToString();
model.HotelType=ds.Tables[0].Rows[0]["HotelType"].ToString();
model.HotelStars=ds.Tables[0].Rows[0]["HotelStars"].ToString();
model.Rating=ds.Tables[0].Rows[0]["Rating"].ToString();
model.Introduction=ds.Tables[0].Rows[0]["Introduction"].ToString();
if(ds.Tables[0].Rows[0]["Picture"].ToString()!="")
{
model.Picture=(byte[])ds.Tables[0].Rows[0]["Picture"];
}
model.UserRating=ds.Tables[0].Rows[0]["UserRating"].ToString();
if(ds.Tables[0].Rows[0]["EMap"].ToString()!="")
{
model.EMap=(byte[])ds.Tables[0].Rows[0]["EMap"];
}
model.VenderID=ds.Tables[0].Rows[0]["VenderID"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select HotelID,HotelName,HotelEN,SpellCode,BusinessID,RegionID,HotelType,HotelStars,Rating,Introduction,Picture,UserRating,EMap,VenderID ");
strSql.Append(" FROM Hotel ");
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 = "Hotel";
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 成员方法
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -