/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SysLogInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysLog(");
strSql.Append("Area,Type,Detail,IP,AdminID,AdminName,CreateTime)");
strSql.Append(" values (");
strSql.Append("@Area,@Type,@Detail,@IP,@AdminID,@AdminName,@CreateTime)");
SqlParameter[] parameters = {
new SqlParameter("@Area", SqlDbType.VarChar,50),
new SqlParameter("@Type", SqlDbType.VarChar,100),
new SqlParameter("@Detail", SqlDbType.VarChar,50),
new SqlParameter("@IP", SqlDbType.VarChar,50),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@AdminName", SqlDbType.VarChar,20),
new SqlParameter("@CreateTime", SqlDbType.DateTime)};
parameters[0].Value = model.Area;
parameters[1].Value = model.Type;
parameters[2].Value = model.Detail;
parameters[3].Value = model.IP;
parameters[4].Value = model.AdminID;
parameters[5].Value = model.AdminName;
parameters[6].Value = model.CreateTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(YK.Model.AdminGroupInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into AdminGroup(");
strSql.Append("GroupName,Describe,GroupAuth,CreateTime,AdminID)");
strSql.Append(" values (");
strSql.Append("@GroupName,@Describe,@GroupAuth,@CreateTime,@AdminID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GroupName", SqlDbType.VarChar,10),
new SqlParameter("@Describe", SqlDbType.VarChar,50),
new SqlParameter("@GroupAuth", SqlDbType.VarChar,500),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@AdminID", SqlDbType.Int,4)};
parameters[0].Value = model.GroupName;
parameters[1].Value = model.Describe;
parameters[2].Value = model.GroupAuth;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.AdminID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(YK.Model.AdminInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin(");
strSql.Append("GroupID,AdminAccount,AdminPwd,AdminName,State,AdminDesc,LastLoginIP,LastLoginTime,CreateTime,CreateAdminID)");
strSql.Append(" values (");
strSql.Append("@GroupID,@AdminAccount,@AdminPwd,@AdminName,@State,@AdminDesc,@LastLoginIP,@LastLoginTime,@CreateTime,@CreateAdminID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GroupID", SqlDbType.Int,4),
new SqlParameter("@AdminAccount", SqlDbType.VarChar,20),
new SqlParameter("@AdminPwd", SqlDbType.VarChar,20),
new SqlParameter("@AdminName", SqlDbType.VarChar,15),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@AdminDesc", SqlDbType.VarChar,100),
new SqlParameter("@LastLoginIP", SqlDbType.VarChar,20),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateAdminID", SqlDbType.Int,4)
};
parameters[0].Value = model.GroupID;
parameters[1].Value = model.AdminAccount;
parameters[2].Value = model.AdminPwd;
parameters[3].Value = model.AdminName;
parameters[4].Value = model.State;
parameters[5].Value = model.AdminDesc;
parameters[6].Value = model.LastLoginIP;
parameters[7].Value = model.LastLoginTime;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreateAdminID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SortAttributeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SortAttribute(");
strSql.Append("SortAttributeName,SortAttributeDesc,AdminID,AdminName,CreateTime)");
strSql.Append(" values (");
strSql.Append("@SortAttributeName,@SortAttributeDesc,@AdminID,@AdminName,@CreateTime)");
SqlParameter[] parameters = {
new SqlParameter("@SortAttributeName", SqlDbType.VarChar,20),
new SqlParameter("@SortAttributeDesc", SqlDbType.VarChar,100),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@AdminName", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime)};
parameters[0].Value = model.SortAttributeName;
parameters[1].Value = model.SortAttributeDesc;
parameters[2].Value = model.AdminID;
parameters[3].Value = model.AdminName;
parameters[4].Value = model.CreateTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SortInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sort(");
strSql.Append("ParentID,SortAttributeID,SortName,SortUrl,SortTemplateID,PageTitle,PageKeywords,PageDesc,BannerUrl,State,AdminID,AdminName,CreateTime)");
strSql.Append(" values (");
strSql.Append("@ParentID,@SortAttributeID,@SortName,@SortUrl,@SortTemplateID,@PageTitle,@PageKeywords,@PageDesc,@BannerUrl,@State,@AdminID,@AdminName,@CreateTime)");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@SortAttributeID", SqlDbType.Int,4),
new SqlParameter("@SortName", SqlDbType.VarChar,50),
new SqlParameter("@SortUrl", SqlDbType.VarChar,100),
new SqlParameter("@SortTemplateID", SqlDbType.Int,4),
new SqlParameter("@PageTitle", SqlDbType.VarChar,100),
new SqlParameter("@PageKeywords", SqlDbType.VarChar,100),
new SqlParameter("@PageDesc", SqlDbType.VarChar,200),
new SqlParameter("@BannerUrl", SqlDbType.VarChar,100),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@AdminName", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.SortAttributeID;
parameters[2].Value = model.SortName;
parameters[3].Value = model.SortUrl;
parameters[4].Value = model.SortTemplateID;
parameters[5].Value = model.PageTitle;
parameters[6].Value = model.PageKeywords;
parameters[7].Value = model.PageDesc;
parameters[8].Value = model.BannerUrl;
parameters[9].Value = model.State;
parameters[10].Value = model.AdminID;
parameters[11].Value = model.AdminName;
parameters[12].Value = model.CreateTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SysLogInfo model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.SysLogInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(YK.Model.AdminGroupInfo model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.AdminGroupInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.SortInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Sort set ");
strSql.Append("ParentID=@ParentID,");
strSql.Append("SortAttributeID=@SortAttributeID,");
strSql.Append("SortName=@SortName,");
strSql.Append("SortUrl=@SortUrl,");
strSql.Append("SortTemplateID=@SortTemplateID,");
strSql.Append("PageTitle=@PageTitle,");
strSql.Append("PageKeywords=@PageKeywords,");
strSql.Append("PageDesc=@PageDesc,");
strSql.Append("BannerUrl=@BannerUrl,");
strSql.Append("State=@State,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where SortID=@SortID");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@SortAttributeID", SqlDbType.Int,4),
new SqlParameter("@SortName", SqlDbType.VarChar,50),
new SqlParameter("@SortUrl", SqlDbType.VarChar,100),
new SqlParameter("@SortTemplateID", SqlDbType.Int,4),
new SqlParameter("@PageTitle", SqlDbType.VarChar,100),
new SqlParameter("@PageKeywords", SqlDbType.VarChar,100),
new SqlParameter("@PageDesc", SqlDbType.VarChar,200),
new SqlParameter("@BannerUrl", SqlDbType.VarChar,100),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@SortID", SqlDbType.Int,4)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.SortAttributeID;
parameters[2].Value = model.SortName;
parameters[3].Value = model.SortUrl;
parameters[4].Value = model.SortTemplateID;
parameters[6].Value = model.PageTitle;
parameters[7].Value = model.PageKeywords;
parameters[8].Value = model.PageDesc;
parameters[9].Value = model.BannerUrl;
parameters[10].Value = model.State;
parameters[11].Value = model.CreateTime;
parameters[12].Value = model.SortID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.AdminGroupInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update AdminGroup set ");
strSql.Append("GroupName=@GroupName,");
strSql.Append("Describe=@Describe,");
strSql.Append("GroupAuth=@GroupAuth,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("AdminID=@AdminID");
strSql.Append(" where GroupID=@GroupID");
SqlParameter[] parameters = {
new SqlParameter("@GroupName", SqlDbType.VarChar,10),
new SqlParameter("@Describe", SqlDbType.VarChar,50),
new SqlParameter("@GroupAuth", SqlDbType.VarChar,500),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@GroupID", SqlDbType.Int,4)};
parameters[0].Value = model.GroupName;
parameters[1].Value = model.Describe;
parameters[2].Value = model.GroupAuth;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.AdminID;
parameters[5].Value = model.GroupID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.SortAttributeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update SortAttribute set ");
strSql.Append("SortAttributeName=@SortAttributeName,");
strSql.Append("SortAttributeDesc=@SortAttributeDesc,");
strSql.Append("AdminID=@AdminID,");
strSql.Append("AdminName=@AdminName,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where SortAttributeID=@SortAttributeID");
SqlParameter[] parameters = {
new SqlParameter("@SortAttributeName", SqlDbType.VarChar,20),
new SqlParameter("@SortAttributeDesc", SqlDbType.VarChar,100),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@AdminName", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@SortAttributeID", SqlDbType.Int,4)};
parameters[0].Value = model.SortAttributeName;
parameters[1].Value = model.SortAttributeDesc;
parameters[2].Value = model.AdminID;
parameters[3].Value = model.AdminName;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.SortAttributeID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SortAttributeInfo model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.SortAttributeInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.SysLogInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update SysLog set ");
strSql.Append("Area=@Area,");
strSql.Append("Type=@Type,");
strSql.Append("Detail=@Detail,");
strSql.Append("IP=@IP,");
strSql.Append("AdminID=@AdminID,");
strSql.Append("AdminName=@AdminName,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where SysLogID=@SysLogID");
SqlParameter[] parameters = {
new SqlParameter("@Area", SqlDbType.VarChar,50),
new SqlParameter("@Type", SqlDbType.VarChar,100),
new SqlParameter("@Detail", SqlDbType.VarChar,50),
new SqlParameter("@IP", SqlDbType.VarChar,50),
new SqlParameter("@AdminID", SqlDbType.Int,4),
new SqlParameter("@AdminName", SqlDbType.VarChar,20),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@SysLogID", SqlDbType.Int,4)};
parameters[0].Value = model.Area;
parameters[1].Value = model.Type;
parameters[2].Value = model.Detail;
parameters[3].Value = model.IP;
parameters[4].Value = model.AdminID;
parameters[5].Value = model.AdminName;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.SysLogID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YK.Model.AdminInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin set ");
strSql.Append("GroupID=@GroupID,");
strSql.Append("AdminAccount=@AdminAccount,");
strSql.Append("AdminPwd=@AdminPwd,");
strSql.Append("AdminName=@AdminName,");
strSql.Append("State=@State,");
strSql.Append("AdminDesc=@AdminDesc,");
strSql.Append("LastLoginIP=@LastLoginIP,");
strSql.Append("LastLoginTime=@LastLoginTime,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreateAdminID=@CreateAdminID");
strSql.Append(" where AdminID=@AdminID");
SqlParameter[] parameters = {
new SqlParameter("@GroupID", SqlDbType.Int,4),
new SqlParameter("@AdminAccount", SqlDbType.VarChar,20),
new SqlParameter("@AdminPwd", SqlDbType.VarChar,20),
new SqlParameter("@AdminName", SqlDbType.VarChar,15),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@AdminDesc", SqlDbType.VarChar,100),
new SqlParameter("@LastLoginIP", SqlDbType.VarChar,20),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateAdminID", SqlDbType.Int,4),
new SqlParameter("@AdminID", SqlDbType.Int,4)};
parameters[0].Value = model.GroupID;
parameters[1].Value = model.AdminAccount;
parameters[2].Value = model.AdminPwd;
parameters[3].Value = model.AdminName;
parameters[4].Value = model.State;
parameters[5].Value = model.AdminDesc;
parameters[6].Value = model.LastLoginIP;
parameters[7].Value = model.LastLoginTime;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreateAdminID;
parameters[10].Value = model.AdminID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(YK.Model.SortInfo model)
{
dal.Add(model);
}
