public ActionResult Index()
{
loginUser u = Session["user"] as loginUser;
ViewBag.Name = u.UserName;
return(View());
}
async public void setUser(string Gtoken, string Gworker)
{
try {
if (!Directory.Exists(Program.minerstatDir))
{
Directory.CreateDirectory(Program.minerstatDir);
}
if (File.Exists(Program.minerstatDir + "/user.json"))
{
File.Delete((Program.minerstatDir + "/user.json"));
}
loginUser loginUser = new loginUser
{
token = Gtoken,
worker = Gworker
};
File.WriteAllText(@Program.minerstatDir + "/user.json", JsonConvert.SerializeObject(loginUser));
await System.Threading.Tasks.Task.Delay(2500);
if (!File.Exists(Program.minerstatDir + "/user.json"))
{
File.WriteAllText(@Program.minerstatDir + "/user.json", JsonConvert.SerializeObject(loginUser));
}
} catch (Exception) {
}
}
public loginUser login(int userID, string userPW)
{
loginUser user = new loginUser();
if (this.OpenConnection() == true)
{
using (MySqlCommand dbCMD = new MySqlCommand())
{
dbCMD.Connection = this.sqlConn;
dbCMD.CommandText = $"SELECT COUNT(*) FROM `userInfo` WHERE `userID`={userID} AND `password`=\"{userPW}\"";
if (Convert.ToInt32(dbCMD.ExecuteScalar()) == 1)
{
dbCMD.CommandText = $"SELECT `workerTitle`, `permissionLvL` FROM `userInfo` WHERE `userID`={userID} AND `password`=\"{userPW}\"";
using (MySqlDataReader rdr = dbCMD.ExecuteReader())
{
while (rdr.Read())
{
user.userID = userID;
user.userTitle = rdr[0].ToString();
user.premissionLvL = Convert.ToInt32(rdr[1]);
user.isLogin = true;
}
}
this.CloseConnect();
return(user);
}
}
}
user.isLogin = false;
this.CloseConnect();
return(user);
}
public ActionResult DeleteConfirmed(int id)
{
loginUser loginUser = db.loginUsers.Find(id);
db.loginUsers.Remove(loginUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult <User> Get([FromBody] loginUser loginUser)
{
var user = _userService.Get(loginUser.Username, loginUser.Password);
if (user == null)
{
return(BadRequest("user does not exist make sure your username and password is correct"));
}
return(user);
}
/// <summary>
/// 通过登录用户信息获取树目录
/// </summary>
public void getTree()
{
loginUser lu = Session["user"] as loginUser;
string sql = string.Format("exec getDirByUserID @id={0}", lu.ID);
System.Data.DataTable dt = DAL.Commons.Instance.chooseFactory("sql").Fill(sql);
string msg = DAL.Commons.Instance.ToJson(dt, true);
Response.Write(msg);
}
public ActionResult Edit([Bind(Include = "userID,Username,Password")] loginUser loginUser)
{
if (ModelState.IsValid)
{
db.Entry(loginUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loginUser));
}
public void setLoginUser(string userAccount, long userId, string userSchool)
{
loginUser loginUser = new loginUser
{
userId = userId,
userAccount = userAccount,
userSchool = userSchool
};
HttpContext.Current.Session["loginUser"] = loginUser;
}
public ActionResult Create([Bind(Include = "userID,Username,Password")] loginUser loginUser)
{
if (ModelState.IsValid)
{
db.loginUsers.Add(loginUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loginUser));
}
// GET: loginUsers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
loginUser loginUser = db.loginUsers.Find(id);
if (loginUser == null)
{
return(HttpNotFound());
}
return(View(loginUser));
}
/// <summary>
/// 密码修改
/// </summary>
public void ModifyPwd()
{
loginUser lu = Session["user"] as loginUser;
string pwd = Request.Form["pwd"].ToString();
string npwd = Request.Form["npwd"].ToString();
string nrpwd = Request.Form["nrpwd"].ToString();
bool result = true;
if (lu.Pwd != pwd)
{
result = false;
}
string sql = string.Format("update userinfo set password='******' where keyid='{1}'", npwd, lu.ID);
DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
var par = new { sucess = result };
Response.Write(DAL.Commons.Instance.ToJson(par));
}
public IActionResult processlogin(loginUser newloginUser)
{
if (ModelState.IsValid)
{
string userexistsq = $"SELECT * FROM user where EmailAddress='{newloginUser.EmailAddress}'";
System.Console.WriteLine(userexistsq);
Dictionary <string, object> userexists = DbConnector.Query(userexistsq).SingleOrDefault();
if (userexists == null)
{
ViewBag.status = "loginfailspecific";
ViewBag.loginerror = "Please register!";
return(View("Register"));
}
else
{
System.Console.WriteLine("started");
System.Console.WriteLine(userexists["Password"]);
System.Console.WriteLine(newloginUser.Password);
if ((string)userexists["Password"] == newloginUser.Password)
{
HttpContext.Session.SetInt32("uid", (int)userexists["idUser"]);
System.Console.WriteLine("test");
System.Console.WriteLine(HttpContext.Session.GetInt32("uid"));
HttpContext.Session.SetString("username", (string)userexists["FirstName"]);
return(RedirectToAction("wall", "Postmsg"));
}
else
{
ViewBag.status = "loginfailspecific";
ViewBag.loginerror = "Invalid Credentials!";
return(View("Register"));
}
}
}
else
{
ViewBag.errors = ModelState.Values;
ViewBag.status = "loginfail";
return(View("Register"));
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
public void login(string name, string pwd)
{
string sql = string.Format("select keyid,deptid,username from userinfo u where u.loginname='{0}' and password='******'", name, pwd);
// DAL.Mylog.Instance.WriteLog("login", "this is sql:" + sql);
System.Data.DataTable dt = DAL.Commons.Instance.chooseFactory("sql").Fill(sql);
if (dt.Rows.Count > 0)
{
loginUser u = new loginUser()
{
ID = dt.Rows[0]["keyid"].ToString(), DeptID = dt.Rows[0]["DeptID"].ToString(), UserName = dt.Rows[0]["UserName"].ToString(), LoginName = name, Pwd = pwd
};
Session["user"] = u;
sql = string.Format("update userinfo set logintime='{0}' where keyid='{1}'", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), u.ID);
DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
}
var par = new { sucess = dt.Rows.Count > 0 ? true : false };
Response.Write(DAL.Commons.Instance.ToJson(par));
}
public void setUser(string Gtoken, string Gworker)
{
if (!Directory.Exists(Program.minerstatDir))
{
Directory.CreateDirectory(Program.minerstatDir);
}
if (File.Exists(Program.minerstatDir + "/user.json"))
{
File.Delete((Program.minerstatDir + "/user.json"));
}
loginUser loginUser = new loginUser
{
token = Gtoken,
worker = Gworker
};
File.WriteAllText(@Program.minerstatDir + "/user.json", JsonConvert.SerializeObject(loginUser));
}
/// <summary>
/// 根据文件ID下载
/// </summary>
/// <param name="fileid">文件ID</param>
/// <returns></returns>
public FileStreamResult DownFile(string fileid)
{
List <string> fs = new List <string>();
string sql = string.Format("select localdir from fileinfo where keyid in ({0})", fileid);
DataTable dt = DAL.Commons.Instance.chooseFactory("sql").Fill(sql);
foreach (DataRow item in dt.Rows)
{
fs.Add(AppDomain.CurrentDomain.BaseDirectory + item["localdir"].ToString());
}
//string filePath = AppDomain.CurrentDomain.BaseDirectory + path;//路径
loginUser lu = Session["user"] as loginUser;
string fileName = lu.LoginName + ".zip";
string filePath = AppDomain.CurrentDomain.BaseDirectory + "//downLoad//" + fileName;
DAL.Commons.Zip(fs.ToArray(), filePath);
FileStreamResult fr = File(new FileStream(filePath, FileMode.Open), "text/plain", fileName);
return(fr);
}
/// <summary>
///pdf文件在线预览
/// </summary>
/// <param name="fileid"></param>
/// <returns></returns>
public ActionResult pdfobject(string fileid)
{
string sql = string.Format("select viewdir,viewmode from fileinfo where keyid='{0}'", fileid);
DataTable dt = DAL.Commons.Instance.chooseFactory("sql").Fill(sql);
if (dt.Rows.Count > 0)
{
ViewBag.fileid = "/" + dt.Rows[0][0].ToString();
ViewBag.mode = dt.Rows[0][1].ToString();
}
loginUser lu = Session["user"] as loginUser;
sql = string.Format("exec UpdateView @uid={0},@fid={1}", lu.ID, fileid);
DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
//if (dt.Rows[0][1].ToString()=="2")
//{
// //Response.ContentEncoding = Encoding.GetEncoding("gb2312");
// // Response.Redirect()
//}
return(View());
}
/// <summary>
/// 树控件操作
/// </summary>
public void TreeOP()
{
string filename = Request.Form["filename"].ToString();
string sql = "";
loginUser lu = Session["user"] as loginUser;
if (Request.Form["option"].ToString() == "add")
{
string pid = Request.Form["pid"].ToString();
sql = string.Format("insert into directoryinfo(dirname,parentid,userid) values ('{0}','{1}','{2}')", filename, pid, lu.ID);
}
else
{
string id = Request.Form["pid"].ToString();
sql = string.Format("update directoryinfo set dirname='{0}' where keyid='{1}'", filename, id);
}
int i = DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
var par = new { sucess = i > 0 };
string msg = DAL.Commons.Instance.ToJson(par);
Response.Write(msg);
}
public LastChatService(ILastChatRepository lastChatRepository)
{
this._lastChatRepository = lastChatRepository;
loginUser = Models.Help.loginUser.getLoginUser();
}
public ContactService(IContactRepository contactRepository)
{
this._contactRepository = contactRepository;
loginUser = Models.Help.loginUser.getLoginUser();
}
/// <summary>
/// 文件上传
/// </summary>
public void UploadFiles()
{
bool result = false;
if (Request.Form["option"].ToString() == "update")
{
string fn = Request.Form["filename"].ToString();
string keyword = Request.Form["keyword"].ToString();
string status = Request.Form["ispublic"].ToString() == "checked" ? "1" : "0";
string id = Request.Form["id"].ToString();
string sql = string.Format("update fileinfo set filename='{0}',keyword='{1}',status='{2}' where keyid={3}", fn, keyword, status, id);
int i = DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
result = i > 0 ? true : false;
}
else
{
if (Request.Files.Count > 0)
{
loginUser lu = Session["user"] as loginUser;
string dir = string.Format("{0}//{1}//{2}", "upload", DateTime.Now.ToString("yyyy-MM-dd"), lu.LoginName);
string extName = Path.GetExtension(Request.Files[0].FileName);//.Split('.')[1].ToLower();
extName = extName.Substring(1);
string filename = DAL.Commons.Instance.GetUploadFileName(dir, extName);
Request.Files[0].SaveAs(AppDomain.CurrentDomain.BaseDirectory + filename);
string fn = Request.Form["filename"].ToString();
string keyword = Request.Form["keyword"].ToString();
string dirid = Request.Form["dirid"].ToString();
string userid = lu.ID;
string status = Request.Form["ispublic"].ToString() == "checked" ? "1" : "0";
string f1 = "doc,docx";
string f2 = "xls,xlsx";
string f3 = "txt,jpeg,png";
string f4 = "pdf";
int viewmode = 3;
string viewdir = "";
if (f1.IndexOf(extName) >= 0)
{
viewmode = 1;
Spire.Doc.Document doc = new Spire.Doc.Document();
doc.LoadFromFile(AppDomain.CurrentDomain.BaseDirectory + filename);
string newname = DAL.Commons.Instance.GetUploadFileName(dir, "pdf");
doc.SaveToFile(AppDomain.CurrentDomain.BaseDirectory + newname, Spire.Doc.FileFormat.PDF);
viewdir = newname;
doc.Close();
}
else if (f2.IndexOf(extName) >= 0)
{
viewmode = 1;
Spire.Xls.Workbook book = new Spire.Xls.Workbook();
book.LoadFromFile(AppDomain.CurrentDomain.BaseDirectory + filename);
string newname = DAL.Commons.Instance.GetUploadFileName(dir, "pdf");
book.ConverterSetting.SheetFitToPage = true;
book.SaveToFile(AppDomain.CurrentDomain.BaseDirectory + newname, Spire.Xls.FileFormat.PDF);
viewdir = newname;
}
else if (f3.IndexOf(extName) >= 0)
{
viewmode = 2;
viewdir = filename;
}
else if (f4.IndexOf(extName) >= 0)
{
viewmode = 1;
viewdir = filename;
}
Spire.Pdf.PdfDocument pdf = new Spire.Pdf.PdfDocument();
string sql = string.Format("insert into fileinfo (filename,keyword,dirid,userid,status,localdir,viewdir,viewmode,extname) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", fn, keyword, dirid, userid, status, filename, viewdir, viewmode, extName);
int i = DAL.Commons.Instance.chooseFactory("sql").ExecuteNonQuery(sql);
result = i > 0 ? true : false;
}
}
var par = new { sucess = result };
Response.Write(DAL.Commons.Instance.ToJson(par));
}
