public bool Delete(object id)
{
sql = string.Format("Delete DownAttach where id='{0}'", id);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Add(DownAttach a)
{
sql = string.Format("insert into DownAttach (addDate,writer,title,filesavename,cid,count,type,fileid) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", a.AddDate, a.Writer, a.Title, a.FileSaveName, a.Cid, a.Count, a.Type, a.FileId);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Update(DownAttach a)
{
sql = string.Format("update DownAttach set addDate='{0}',filesavename='{1}',writer='{2}',title='{3}',cid='{4}' where id='{5}'", a.AddDate, a.FileSaveName, a.Writer, a.Title, a.Cid, a.Id);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Delete(object id)
{
sql = string.Format("Delete tb_User where UserID='{0}'", id);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Delete(object id)
{
sql = string.Format("Delete NoticeArticle where id='{0}'", id);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Update(Users a)
{
sql = string.Format("update tb_User set UserPwd='{0}',Role='{1}',UserSex='{2}',UserAddress='{3}',UserTel='{4}',UserEmail='{5}',UserName='******',UserMark='{7}',LoginTime='{8}' where userid='{9}'", a.Password, a.Role, a.UserSex, a.Address, a.Telephone, a.Email, a.UserName, a.UserMark, a.LoginTime, a.UserId);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Add(Users a)
{
sql = string.Format("insert into tb_User (UserName,UserPwd,Role,UserSex,UserAddress,UserTel,UserEmail,LoginTime,CreateTime,UserQuePwd,UserAnsPwd,UserMark) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", a.UserName, a.Password, a.Role, a.UserSex, a.Address, a.Telephone, a.Email, a.LoginTime, a.CreateTime, a.QuePwd, a.AnsPwd, a.UserMark);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Update(Remark a)
{
sql = string.Format("update Remarks set Cid='{0}',Tel='{1}',Email='{2}',Address='{3}',About='{4}',BBSHelp='{5}',ZiranHelp='{8}',ShekeHelp='{7}' where id={6}", a.Cid, a.Tel, a.Email, a.Address, a.About, a.BBShelp, a.Id, a.Shekehelp, a.Ziranhelp);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Add(Remark a)
{
sql = string.Format("insert into Remarks (Cid,Tel,Email,Address,About,BBSHelp) values ('{0}','{1}','{2}','{3}','{4}')", a.Cid, a.Tel, a.Email, a.Email, a.About, a.BBShelp);
return(DbHelperSQL.ExecSqlCommand(sql));
}
public bool Delete1(object id)
{
sql = string.Format("Delete RightImage where id='{0}'", id);
return(DbHelperSQL.ExecSqlCommand(sql));
}
