/// <summary>
/// 增加一条数据
/// </summary>
public int Add(第三学期三层构架_新闻管理_.Model.T_User model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into T_User(");
strSql.Append("UserId,UserName,Password,RealName,Mobile,Department)");
strSql.Append(" values (");
strSql.Append("@UserId,@UserName,@Password,@RealName,@Mobile,@Department)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.VarChar,8),
new SqlParameter("@UserName", SqlDbType.VarChar,16),
new SqlParameter("@Password", SqlDbType.VarChar,16),
new SqlParameter("@RealName", SqlDbType.VarChar,16),
new SqlParameter("@Mobile", SqlDbType.VarChar,16),
new SqlParameter("@Department", SqlDbType.VarChar,32)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.RealName;
parameters[4].Value = model.Mobile;
parameters[5].Value = model.Department;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(第三学期三层构架_新闻管理_.Model.T_NewsClass model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into T_NewsClass(");
strSql.Append("ClassId,ClassName,ClassCreator,CreateTime)");
strSql.Append(" values (");
strSql.Append("@ClassId,@ClassName,@ClassCreator,@CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ClassId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@ClassName", SqlDbType.VarChar,32),
new SqlParameter("@ClassCreator", SqlDbType.VarChar,8),
new SqlParameter("@CreateTime", SqlDbType.DateTime)};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.ClassName;
parameters[2].Value = model.ClassCreator;
parameters[3].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(第三学期三层构架_新闻管理_.Model.T_News model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(第三学期三层构架_新闻管理_.Model.T_News model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(第三学期三层构架_新闻管理_.Model.T_User model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update T_User set ");
strSql.Append("UserId=@UserId,");
strSql.Append("UserName=@UserName,");
strSql.Append("Password=@Password,");
strSql.Append("RealName=@RealName,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("Department=@Department");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.VarChar,8),
new SqlParameter("@UserName", SqlDbType.VarChar,16),
new SqlParameter("@Password", SqlDbType.VarChar,16),
new SqlParameter("@RealName", SqlDbType.VarChar,16),
new SqlParameter("@Mobile", SqlDbType.VarChar,16),
new SqlParameter("@Department", SqlDbType.VarChar,32),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.RealName;
parameters[4].Value = model.Mobile;
parameters[5].Value = model.Department;
parameters[6].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(第三学期三层构架_新闻管理_.Model.T_NewsClass model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update T_NewsClass set ");
strSql.Append("ClassId=@ClassId,");
strSql.Append("ClassName=@ClassName,");
strSql.Append("ClassCreator=@ClassCreator,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@ClassId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@ClassName", SqlDbType.VarChar,32),
new SqlParameter("@ClassCreator", SqlDbType.VarChar,8),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.ClassId;
parameters[1].Value = model.ClassName;
parameters[2].Value = model.ClassCreator;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
