285 lines
9.7 KiB
C#
285 lines
9.7 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace Mtxfw.DAL
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:Guest
|
|
/// </summary>
|
|
public partial class Guest :Mtxfw.Utility.Myabstract
|
|
{
|
|
public Guest()
|
|
: base("Guest"){ }
|
|
|
|
#region Method
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public int Add(Mtxfw.Model.Guest model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into Guest(");
|
|
strSql.Append("GuestName,GuestContact,Message,CreateTime,BusinessID,userid,IsShow,starlevel,ttype)");
|
|
strSql.Append(" values (");
|
|
strSql.Append("@GuestName,@GuestContact,@Message,@CreateTime,@BusinessID,@userid,@IsShow,@starlevel,@ttype)");
|
|
strSql.Append(";select SCOPE_IDENTITY()");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@GuestName", SqlDbType.NVarChar,30),
|
|
new SqlParameter("@GuestContact", SqlDbType.NVarChar,30),
|
|
new SqlParameter("@Message", SqlDbType.NVarChar,300),
|
|
new SqlParameter("@CreateTime", SqlDbType.DateTime),
|
|
new SqlParameter("@BusinessID", SqlDbType.Int,4),
|
|
new SqlParameter("@userid", SqlDbType.Int,4),
|
|
new SqlParameter("@IsShow", SqlDbType.Int,4),
|
|
new SqlParameter("@starlevel", SqlDbType.Int,4),
|
|
new SqlParameter("@ttype", SqlDbType.Int,4)};
|
|
parameters[0].Value = model.GuestName;
|
|
parameters[1].Value = model.GuestContact;
|
|
parameters[2].Value = model.Message;
|
|
parameters[3].Value = model.CreateTime;
|
|
parameters[4].Value = model.BusinessID;
|
|
parameters[5].Value = model.userid;
|
|
parameters[6].Value = model.IsShow;
|
|
parameters[7].Value = model.starlevel;
|
|
parameters[8].Value = model.ttype;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public bool Update(Mtxfw.Model.Guest model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update Guest set ");
|
|
strSql.Append("Message2=@Message2,");
|
|
strSql.Append("userid2=@userid2");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Message2", SqlDbType.NVarChar,300),
|
|
new SqlParameter("@userid2", SqlDbType.Int,4),
|
|
new SqlParameter("@ID", SqlDbType.Int,4)};
|
|
parameters[0].Value = model.Message2;
|
|
parameters[1].Value = model.userid2;
|
|
parameters[2].Value = model.ID;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 审核评论
|
|
/// </summary>
|
|
public bool UpdataCheck(int ID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update Guest set IsShow=1");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 审核回答
|
|
/// </summary>
|
|
public bool UpdataCheck2(int ID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update Guest set IsShow2=1");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 点赞
|
|
/// </summary>
|
|
public bool Updatazannum(int ID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update Guest set zannum=zannum+1");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public bool Delete(int ID)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from Guest ");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public bool DeleteList(string IDlist)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from Guest ");
|
|
strSql.Append(" where ID in (" + IDlist + ") ");
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString());
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 得到一个对象实体
|
|
/// </summary>
|
|
public Mtxfw.Model.Guest GetModel(int ID)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 * from Guest ");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
Mtxfw.Model.Guest model = new Mtxfw.Model.Guest();
|
|
DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(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.GuestName = ds.Tables[0].Rows[0]["GuestName"].ToString();
|
|
model.Message = ds.Tables[0].Rows[0]["Message"].ToString();
|
|
model.Message2 = ds.Tables[0].Rows[0]["Message2"].ToString();
|
|
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
|
|
{
|
|
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["BusinessID"].ToString() != "")
|
|
{
|
|
model.BusinessID = int.Parse(ds.Tables[0].Rows[0]["BusinessID"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
|
|
{
|
|
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["userid2"].ToString() != "")
|
|
{
|
|
model.userid2 = int.Parse(ds.Tables[0].Rows[0]["userid2"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["IsShow"].ToString() != "")
|
|
{
|
|
model.IsShow = int.Parse(ds.Tables[0].Rows[0]["IsShow"].ToString());
|
|
}
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataSet GetList(string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select ID,GuestName,GuestContact,Message,CreateTime,BusinessID,userid,IsShow,starlevel,zannum ");
|
|
strSql.Append(" FROM Guest ");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获得前几行数据
|
|
/// </summary>
|
|
public DataSet GetList(int Top, string strWhere, string filedOrder)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select ");
|
|
if (Top > 0)
|
|
{
|
|
strSql.Append(" top " + Top.ToString());
|
|
}
|
|
strSql.Append(" ID,GuestName,GuestContact,Message,CreateTime,BusinessID,userid,IsShow,starlevel,zannum ");
|
|
strSql.Append(" FROM Guest ");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
strSql.Append(" order by " + filedOrder);
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
|
|
#endregion Method
|
|
}
|
|
}
|
|
|