public static string statisticsReplyLine(string articleID)
{
string sql = "select COUNT(*) as line from dbo.commentinfo where dbo.commentinfo.particleID='" + articleID + "'";
try
{
DbMybbsEntities entit = new DbMybbsEntities();
List <statisticsinfo> listLine = entit.ExecuteStoreQuery <statisticsinfo>(sql).ToList();
if (listLine.Count <= 0)
{
return("N");//没有回复
}
else
{
int coun = Convert.ToInt32(listLine[0].line);
string sql2 = "UPDATE dbo.articleinfo SET wcommentsnum = '" + coun + "' WHERE ID = '" + articleID + "' ";
int yud = entit.ExecuteStoreCommand(sql2);
if (yud <= 0)
{
return("F");//更新失败
}
else
{
return("Y");//更新成功
}
}
}
catch (Exception e)
{
return("E" + e.ToString());//未知错误
throw;
}
}
public static string UserRegister(string userName, string email, string phone, string password)
{
//INSERT INTO dbo.userinfo VALUES ('中火锅', '123', '*****@*****.**', '110011','','')
if (!isRegister(userName))
{
return("-1");//重复
}
else
{
publicFunction func = new publicFunction();
string passw = func.Md5encryption(password);
string sql = "INSERT INTO dbo.userinfo VALUES ('" + userName + "', '"
+ passw + "', '" + email + "', '" + phone + "','','')";
DbMybbsEntities entit = new DbMybbsEntities();
int cont = entit.ExecuteStoreCommand(sql);
if (cont >= 1)
{
return("1");// 成功
}
else
{
return("0");//失败
}
}
}
public static string setAriEditor(string clasID, string ID, string wTitle, string wContext)
{
string wtime = DateTime.Now.ToLocalTime().ToString();
string sql = "UPDATE articleinfo SET classID = '" + clasID
+ "' ,wtitle='" + wTitle + "',wpostedtime ='" + wtime + "' ,wcontent='"
+ wContext + "' WHERE ID='" + ID + "'";
DbMybbsEntities entit = new DbMybbsEntities();
try
{
int Cou = entit.ExecuteStoreCommand(sql);
if (Cou == 1)
{
return("1");//成功
}
else
{
return("-1");//失败
}
}
catch (Exception e)
{
return("-2");//服务器错误
throw;
}
}
public static string addComment(string particleID, string pcontent, string PIp)
{
//insert into dbo.commentinfo VALUES ('da火锅','111111','2','不错不错','2019-05-05 20:56:00','192.168.0.0')
string sql = "";
if (useVerifier() != "-1")
{
string pusername = useVerifier();
var puserID = (slectUserinfoByusername(pusername).Select(s => s.UID).ToList())[0].ToString();
string ptime = DateTime.Now.ToLocalTime().ToString();
sql = "insert into dbo.commentinfo VALUES ('" + pusername + "','"
+ puserID + "','" + particleID + "','" + pcontent + "','" + ptime + "','" + PIp + "')";
}
else
{
return("0");//没有登录
}
try
{
DbMybbsEntities entit = new DbMybbsEntities();
int s = entit.ExecuteStoreCommand(sql);
if (s == 1)
{
return("1");//成功
}
else
{
return("-1");//失败
}
}
catch (Exception e)
{
return("Err" + e.ToString());
throw;
}
}
public static string upReading(string articleID)
{
//查询阅量
string sql = "select dbo.articleinfo.wpviews as line from dbo.articleinfo where ID='" + articleID + "' ";
try
{
DbMybbsEntities entit = new DbMybbsEntities();
List <statisticsinfo> listSt = entit.ExecuteStoreQuery <statisticsinfo>(sql).ToList();
if (listSt.Count <= 0)
{
return("N");//不存在
}
else
{
int numb = listSt[0].line;//阅读量
int newNub = numb + 1;
string sql1 = "UPDATE dbo.articleinfo SET wpviews = '"
+ newNub.ToString() + "' WHERE ID = '" + articleID + "' "; //更新访问量
int yxH = entit.ExecuteStoreCommand(sql1); //受影响行数
if (yxH <= 0)
{
return("F");//失败
}
else
{
return("Y");//成功
}
}
}
catch (Exception e)
{
throw;
}
}
public static string deleteAriByID(string ID)
{
string sqlisSeleingFil = "select * from dbo.fileinfo where articleID in ("
+ ID + ") and fType = 'img'";//查询文章是否有图片附件
string sqlisSeleothFil = "select * from dbo.fileinfo where articleID in ("
+ ID + ") and fType = 'other'";//查询文章是否有其他附件
string sqlSeleFill = "select * from dbo.fileinfo where articleID in ("
+ ID + ")";//查询是否有附件
string sqldelFile = "DELETE FROM dbo.fileinfo WHERE articleID in ("
+ ID + ")";//删除附件表数据
string sqlArit = "DELETE FROM dbo.articleinfo WHERE ID in ("
+ ID + ")";//删除文章表数据
try
{
int Cou = 0;
DbMybbsEntities entit = new DbMybbsEntities();
List <fileinfo> allFileList = entit.ExecuteStoreQuery <fileinfo>(sqlSeleFill).ToList();
if (allFileList.Count > 0)
{
List <fileinfo> imgfileList = entit.ExecuteStoreQuery <fileinfo>(sqlisSeleingFil).ToList();
List <fileinfo> othfileList = entit.ExecuteStoreQuery <fileinfo>(sqlisSeleothFil).ToList();
if (imgfileList.Count > 0)
{
//删除图片数据及其文件
for (int i = 0; i < imgfileList.Count; i++)
{
string imgurlTemp = imgfileList[i].url;
string imgurl = imgurlTemp.Replace(@"\", @"/");
var path = HttpContext.Current.Server.MapPath("~" + imgurl);
File.Delete(path);
}
}
if (othfileList.Count > 0)
{
//删除其他文件数据及其文件
for (int i = 0; i < othfileList.Count; i++)
{
string othurl = othfileList[i].url;
var path = HttpContext.Current.Server.MapPath("~" + othurl);
File.Delete(path);
}
}
int FilCou = entit.ExecuteStoreCommand(sqldelFile);
}
int ArCou = entit.ExecuteStoreCommand(sqlArit);
Cou = ArCou;
if (ArCou <= 0)
{
return("0");//操作数据库失败
}
return(Cou.ToString());
}
catch (Exception e)
{
return("-2");
throw;
}
}
