public ActionResult DNameTrim()
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var dep = db.T_Department;
List<Department> list = (from d in dep select d).ToList();
foreach (Department item in list)
{
string sql = string.Format(@"update department d set `Name`='{0}' where d.Id='{1}'",item.Name.Trim(), item.Id);
MySqlParameter[] parm = new MySqlParameter[] { };
db.Database.ExecuteSqlCommand(sql, parm);
db.SaveChangesAsync();
}
List<Department> list2 = (from d in dep select d).ToList();
return Content("成功");
}
}
/// <summary>
/// 心跳检查一体机运行状况
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult App_MachineHeartbeat(MachineHeartbeat entity)
{
entity.AddTime = DateTime.Now;
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.AddAsync<MachineHeartbeat>(entity);
db.SaveChangesAsync();
retJson.Status = true;
return Json(retJson);
}
}
private bool LoginLog(LoginStatistics model)
{
model.AddTime = DateTime.Now;
using (LoveBankDBContext db = new LoveBankDBContext())
{
Machine mModel = db.T_Machine.Where(x=>x.MachineCode==model.MachineCode).FirstOrDefault();
if (mModel!=null)
{
model.Lon = mModel.Lon;
model.Lat = mModel.Lat;
model.Address = mModel.Address;
}
db.Add<LoginStatistics>(model);
db.SaveChangesAsync();
}
return true;
}
/// <summary>
/// 统计首页各个模块点击情况
/// ModuleCode：模块自定义编码
/// ModuleId：模块Id
/// MachineCode:机器唯一编码
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult App_MachineStatistics(MachineStatistics entity)
{
entity.AddTime = DateTime.Now;
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
var tm = db.T_Machine;
Machine mModel = tm.FirstOrDefault(x => x.MachineCode == entity.MachineCode);
if (mModel != null)
{
entity.DeptId = mModel.DeptId;
//entity.ModuleId = mModel.ID;
}
db.AddAsync<MachineStatistics>(entity);
db.SaveChangesAsync();
retJson.Status = true;
return Json(retJson);
}
}
public ActionResult UpdateDep(string pid = "8")
{
List<Department> list4 = new List<Department>();
using (LoveBankDBContext db = new LoveBankDBContext())
{
var dep = db.T_Department;
List<Department> list = (from d in dep select d).ToList();
List<Department> dpname2 = list.FindAll(x => x.PId == pid);//父节点
List<Department> list3 = UpdateDepartment(dpname2);
list4.AddRange(list3);
while (list3 != null)
{
list3 = UpdateDepartment(list3);
if (list3 == null || list3.Count < 1)
{
break;
}
list4.AddRange(list3);
}
foreach (Department item in list4)
{
string sql = string.Format(@"update department d set PIds='{0}', Ids='{1}',`Names`='{2}' where d.Id='{3}'",
item.PIds, item.Ids, item.Names, item.Id);
MySqlParameter[] parm = new MySqlParameter[] { };
db.Database.ExecuteSqlCommand(sql, parm);
db.SaveChangesAsync();
}
}
var s = list4;
return Content("操作成功");
}
