149 lines
4.5 KiB
C#
149 lines
4.5 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace Mtxfw.DAL
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:Guide
|
|
/// </summary>
|
|
public partial class Guide:Mtxfw.Utility.Myabstract
|
|
{
|
|
public Guide()
|
|
: base("Guide")
|
|
{ }
|
|
#region Method
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public int Add(Mtxfw.Model.Guide model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into Guide(");
|
|
strSql.Append("Question,Answer)");
|
|
strSql.Append(" values (");
|
|
strSql.Append("@Question,@Answer)");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Question", SqlDbType.NVarChar,200),
|
|
new SqlParameter("@Answer", SqlDbType.Text)};
|
|
parameters[0].Value = model.Question;
|
|
parameters[1].Value = model.Answer;
|
|
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public bool Update(Mtxfw.Model.Guide model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update Guide set ");
|
|
strSql.Append("Question=@Question,");
|
|
strSql.Append("Answer=@Answer");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Question", SqlDbType.NVarChar,200),
|
|
new SqlParameter("@Answer", SqlDbType.Text),
|
|
new SqlParameter("@ID", SqlDbType.Int,4)};
|
|
parameters[0].Value = model.Question;
|
|
parameters[1].Value = model.Answer;
|
|
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 Delete(int ID)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from Guide ");
|
|
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 Guide ");
|
|
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.Guide GetModel(int ID)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 ID,Question,Answer,CreateTime from Guide ");
|
|
strSql.Append(" where ID=@ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ID", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = ID;
|
|
|
|
Mtxfw.Model.Guide model = new Mtxfw.Model.Guide();
|
|
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.Question = ds.Tables[0].Rows[0]["Question"].ToString();
|
|
model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
|
|
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
|
|
{
|
|
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
|
|
}
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
|
|
#endregion Method
|
|
}
|
|
}
|
|
|