/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.SysUser model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysUser(");
strSql.Append("UserId,UserRole,UserName,UserPassWord,CreateTime,UserAccount)");
strSql.Append(" values (");
strSql.Append("@UserId,@UserRole,@UserName,@UserPassWord,@CreateTime,@UserAccount)");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@UserRole", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.NVarChar,50),
new SqlParameter("@UserPassWord", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@UserAccount", SqlDbType.VarChar,50)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.UserRole;
parameters[2].Value = model.UserName;
parameters[3].Value = model.UserPassWord;
parameters[4].Value = System.DateTime.Now;
parameters[5].Value = model.UserAccount;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.SysParameters model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysParameters(");
strSql.Append("ID,Parameter,Ptype,StartTime,EndTime,Pstatus,CreateTime,CreateId,CreateName,LastModifyTime,LastModifyId,LastModifyName)");
strSql.Append(" values (");
strSql.Append("@ID,@Parameter,@Ptype,@StartTime,@EndTime,@Pstatus,@CreateTime,@CreateId,@CreateName,@LastModifyTime,@LastModifyId,@LastModifyName)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@Parameter", SqlDbType.NVarChar,50),
new SqlParameter("@Ptype", SqlDbType.Int,4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Pstatus", SqlDbType.Int,4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CreateName", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@LastModifyName", SqlDbType.NVarChar,50)};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Parameter;
parameters[2].Value = model.Ptype;
parameters[3].Value = model.StartTime;
parameters[4].Value = model.EndTime;
parameters[5].Value = model.Pstatus;
parameters[6].Value = model.CreateTime;
parameters[7].Value = Guid.NewGuid();
parameters[8].Value = model.CreateName;
parameters[9].Value = model.LastModifyTime;
parameters[10].Value = Guid.NewGuid();
parameters[11].Value = model.LastModifyName;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.Roles model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Roles(");
strSql.Append("ID,Name,Rstatus,Description,CreateTime,CreateId,CreateName,LastModifyTime,LastModifyId,LastModifyName)");
strSql.Append(" values (");
strSql.Append("@ID,@Name,@Rstatus,@Description,@CreateTime,@CreateId,@CreateName,@LastModifyTime,@LastModifyId,@LastModifyName)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Rstatus", SqlDbType.Int,4),
new SqlParameter("@Description", SqlDbType.Text),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CreateName", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@LastModifyName", SqlDbType.BigInt,8)};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Name;
parameters[2].Value = model.Rstatus;
parameters[3].Value = model.Description;
parameters[4].Value = model.CreateTime;
parameters[5].Value = Guid.NewGuid();
parameters[6].Value = model.CreateName;
parameters[7].Value = model.LastModifyTime;
parameters[8].Value = Guid.NewGuid();
parameters[9].Value = model.LastModifyName;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.SysUser model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.SysUser model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.SysParameters model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update SysParameters set ");
strSql.Append("Parameter=@Parameter,");
strSql.Append("Ptype=@Ptype,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("Pstatus=@Pstatus,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreateId=@CreateId,");
strSql.Append("CreateName=@CreateName,");
strSql.Append("LastModifyTime=@LastModifyTime,");
strSql.Append("LastModifyId=@LastModifyId,");
strSql.Append("LastModifyName=@LastModifyName");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@Parameter", SqlDbType.NVarChar,50),
new SqlParameter("@Ptype", SqlDbType.Int,4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Pstatus", SqlDbType.Int,4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CreateName", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@LastModifyName", SqlDbType.NVarChar,50),
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = model.Parameter;
parameters[1].Value = model.Ptype;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.Pstatus;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateId;
parameters[7].Value = model.CreateName;
parameters[8].Value = model.LastModifyTime;
parameters[9].Value = model.LastModifyId;
parameters[10].Value = model.LastModifyName;
parameters[11].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.Roles model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Roles set ");
strSql.Append("Name=@Name,");
strSql.Append("Rstatus=@Rstatus,");
strSql.Append("Description=@Description,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreateId=@CreateId,");
strSql.Append("CreateName=@CreateName,");
strSql.Append("LastModifyTime=@LastModifyTime,");
strSql.Append("LastModifyId=@LastModifyId,");
strSql.Append("LastModifyName=@LastModifyName");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Rstatus", SqlDbType.Int,4),
new SqlParameter("@Description", SqlDbType.Text),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CreateName", SqlDbType.NVarChar,50),
new SqlParameter("@LastModifyTime", SqlDbType.DateTime),
new SqlParameter("@LastModifyId", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@LastModifyName", SqlDbType.BigInt,8),
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Rstatus;
parameters[2].Value = model.Description;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateId;
parameters[5].Value = model.CreateName;
parameters[6].Value = model.LastModifyTime;
parameters[7].Value = model.LastModifyId;
parameters[8].Value = model.LastModifyName;
parameters[9].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.SysParameters model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.SysParameters model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.SysUser model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update SysUser set ");
strSql.Append("UserRole=@UserRole,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPassWord=@UserPassWord,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("UserAccount=@UserAccount");
strSql.Append(" where UserId=@UserId ");
SqlParameter[] parameters = {
new SqlParameter("@UserRole", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.NVarChar,50),
new SqlParameter("@UserPassWord", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@UserAccount", SqlDbType.VarChar,50),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = model.UserRole;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserPassWord;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.UserAccount;
parameters[5].Value = model.UserId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.Roles model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.Roles model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TrainerEvaluate.Models.Dictionaries model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TrainerEvaluate.Models.Dictionaries model)
{
return dal.Update(model);
}
