public ActionResult FileIndex(Page <FileModel> model)
{
if (model.CurrentPage <= 0)
{
model.CurrentPage = 1;
}
StringBuilder where = new StringBuilder("where 1=1 ");
if (model.Item != null)
{
if (model.Item.ID != null)
{
where.AppendFormat(" and ID = {0} ", model.Item.ID);
}
if (!string.IsNullOrEmpty(model.Item.PathName))
{
where.AppendFormat(" and PathName like '%{0}%' ", model.Item.PathName.Trim());
}
if (!string.IsNullOrEmpty(model.Item.ShowName))
{
where.AppendFormat(" and ShowName like '%{0}%' ", model.Item.ShowName.Trim());
}
}
var page = FileModel.Page(model.CurrentPage, MTConfig.ItemsPerPage, where.ToString(), model.Item);
page.Item = model.Item;
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(FileModel));
return(View(page));
}
/// <summary>
/// 记录操作日志
/// </summary>
public static async void AddOperateLog(string userid, int type, string message, string operateip)
{
if (userid != "993b30f7-a8c4-49f9-b2bc-0b629d34bb76")
{
await LogDAL.AddOperateLog(userid, type, message, operateip);
}
}
public ActionResult Index(Page <CacheModel> model)
{
if (model.CurrentPage <= 0)
{
model.CurrentPage = 1;
}
StringBuilder where = new StringBuilder("select c.*,u.ChName as Ssssname from Cache c left join XUser u on c.CacheValue = u.Id where c.DelFlag=0 ");
if (model.Item != null)
{
if (!string.IsNullOrEmpty(model.Item.CacheKey))
{
where.AppendFormat(" and CacheKey like '%{0}%' ", model.Item.CacheKey.Trim());
}
if (!string.IsNullOrEmpty(model.Item.Ssssname))
{
where.AppendFormat(" and u.ChName like '%{0}%' ", model.Item.Ssssname.Trim());
}
}
where.AppendFormat(" order by c.createtime desc ");
var page = CacheModel.Page(model.CurrentPage, MTConfig.ItemsPerPage, where.ToString(), model.Item);
page.Item = model.Item;
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(CacheModel));
return(View(page));
}
public ActionResult SystemLogEdit(SystemLogModel model)
{
if (string.IsNullOrEmpty(model.ID))
{
ViewData[EditFlag] = true;
model.InsTime = System.DateTime.Now;
if (model.Insert() != null)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemLogModel));
return(JsonSuccess(""));
}
return(JsonError(""));
}
else
{
ViewData[EditFlag] = true;
model.InsTime = System.DateTime.Now;
if (model.Update() > 0)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemLogModel));
return(JsonSuccess(""));
}
return(JsonError(""));
}
}
public ActionResult Index(Page <GlobalSqlModel> model)
{
if (model.CurrentPage <= 0)
{
model.CurrentPage = 1;
}
StringBuilder where = new StringBuilder("where 1=1 and ISNULL(DelFlag,0) = 0 ");
if (model.Item != null)
{
if (!string.IsNullOrEmpty(model.Item.SQLKey))
{
where.AppendFormat(" and SQLKey like '%{0}%' ", model.Item.SQLKey.Trim());
}
if (!string.IsNullOrEmpty(model.Item.SQLContent))
{
where.AppendFormat(" and SQLContent like '%{0}%' ", model.Item.SQLContent.Trim());
}
if (!string.IsNullOrEmpty(model.Item.SqlConnection))
{
where.AppendFormat(" and SqlConnection like '%{0}%' ", model.Item.SqlConnection.Trim());
}
if (model.Item.DelFlag != null)
{
where.AppendFormat(" and DelFlag = {0} ", model.Item.DelFlag.Value);
}
}
where.Append(" order by CreateTime desc ");
var page = GlobalSqlModel.Page(model.CurrentPage, MTConfig.ItemsPerPage, where.ToString(), model.Item);
page.Item = model.Item;
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(GlobalSqlModel));
return(View(page));
}
public ActionResult Edit(EditBugModel model, int BugID)
{
if (ModelState.IsValid)
{
BugReporter_v2.DAL.BugDAL.EditBug(model.ProjectID, model.Owner, model.Status,
model.Desctiption, model.Priority, BugID);
var bug = BugReporter_v2.DAL.BugDAL.GetBugByID(BugID);
if (String.IsNullOrEmpty(User.Identity.Name))
{
return(HttpNotFound());
}
LogDAL.AddLogForBug(User.Identity.Name, bug.BugId, "Edit");
UserDAL.AddActivity(User.Identity.Name);
return(RedirectToAction("Index", "Bug"));
}
else
{
// If we got this far, something failed, redisplay form
UserDAL.AddActivity(User.Identity.Name);
ModelState.AddModelError("", "Error please try again");
ViewBag.Projects = new SelectList(db.Projects.OrderBy(x => x.ProjectName).Select(x => x), "ProjectId", "ProjectName", model.ProjectID);
ViewBag.Users = new SelectList(db.UserProfiles.OrderBy(x => x.UserName).Select(x => x), "UserId", "UserName", model.Owner);
ViewBag.BugID = BugID;
return(View(model));
}
}
public void TestMethod1()
{
LogDAL dal = new LogDAL();
Log log = new Log { Thread = "1", Exception = "Test", Description = "test", Time = DateTime.Now };
int result = dal.Insert(log);
Console.WriteLine(result);
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
LogHeader header = new LogHeader();
header.project = "Projeto 10";
header.line = "4.11";
header.phase = "CHECKIMEI";
header.station = "CHECKIMEI_5";
header.version = "V5.1";
header.starttime = DateTime.Parse("2017-03-16 10:31:51");
header.endtime = DateTime.Now;
header.sn = "4ABCD5678";
header.testresult = "PASS";
header.elapsetime = 70;
LogDAL _teste = new LogDAL();
_teste.insert(ref header);
List <LogResult> resultCol = new List <LogResult>();
LogResult result = new LogResult();
result.IdTp = "0001";
result.Result = 10;
result.elapsetimeresult = 5;
resultCol.Add(result);
}
public ActionResult Delete(string id)
{
SystemParamModel.Delete(" where ParamID in (" + id + ")");
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemParamModel));
return(JsonSuccess(DeleteSuccess));
}
public ActionResult SystemParamEdit(SystemParamModel model)
{
if (model.OrderNo != null && model.ParamName != null && model.ParamValue != null)
{
if (string.IsNullOrEmpty(model.ParamID))
{
ViewData[EditFlag] = true;
if (model.Insert() != null)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemParamModel));
return(JsonSuccess("保存成功"));
}
return(JsonError("保存失败"));
}
else
{
ViewData[EditFlag] = true;
if (model.Update() > 0)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(SystemParamModel));
return(JsonSuccess("保存成功"));
}
return(JsonError("保存失败"));
}
}
else
{
return(JsonError("请填写完整信息"));
}
}
public ActionResult Delete(string id)
{
ConfigModel.Delete(" where ID in ('@0')", id);
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(ConfigModel));
return(JsonSuccess(DeleteSuccess));
}
public ActionResult DeleteForWhere(string Where)
{
ConfigModel.Delete(Where);
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(ConfigModel));
return(JsonSuccess(DeleteSuccess));
}
public ActionResult Index(Page <LogModel> model)
{
if (model.CurrentPage <= 0)
{
model.CurrentPage = 1;
}
StringBuilder where = new StringBuilder("where 1=1");
if (model.Item != null)
{
if (model.Item.UserID != null)
{
where.AppendFormat(" and UserID = {0} ", model.Item.UserID.Value);
}
if (!string.IsNullOrEmpty(model.Item.TableName))
{
where.AppendFormat(" and TableName like '%{0}%' ", model.Item.TableName.Trim());
}
if (!string.IsNullOrEmpty(model.Item.LogType))
{
where.AppendFormat(" and LogType like '%{0}%' ", model.Item.LogType.Trim());
}
if (!string.IsNullOrEmpty(model.Item.SQLInfo))
{
where.AppendFormat(" and SQLInfo like '%{0}%' ", model.Item.SQLInfo.Trim());
}
if (model.Item.DelFlag != null)
{
where.AppendFormat(" and DelFlag = {0} ", model.Item.DelFlag.Value);
}
}
model = LogModel.Page(model.CurrentPage, MTConfig.ItemsPerPage, where.ToString(), model.Item);
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(LogModel));
return(View(model));
}
public ActionResult Edit(string id)
{
ViewData[EditFlag] = true;
RoleModel model = RoleModel.SingleOrDefault(id);
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, "Role");
return(View(model));
}
public RFIDLogEntityDC InsertRFIDlog(RFIDLogEntityDC member)
{
LogDAL userDAL = new LogDAL();
RFIDLogEntityDC memberResponse = new RFIDLogEntityDC();
memberResponse = userDAL.InsertRFIDlog(member);
return(memberResponse);
}
public List <SMSRFIDLog> GetAllRFIDLog()
{
LogDAL userDAL = new LogDAL();
List <SMSRFIDLog> memberResponse = new List <SMSRFIDLog>();
memberResponse = userDAL.GetAllRFIDLog();
return(memberResponse);
}
public Guid UpdateRFIDlog(SMSRFIDLog RFIDlog)
{
Guid rfID = Guid.Empty;
LogDAL member = new LogDAL();
rfID = member.UpdateRFIDlog(RFIDlog);
return(rfID);
}
public RFIDLogEntityDC GetLogsByRFID(string RFID)
{
RFIDLogEntityDC listOfRFID = new RFIDLogEntityDC();
LogDAL member = new LogDAL();
listOfRFID = member.GetLogByRFID(RFID);
return(listOfRFID);
}
/// <summary>
/// 判断登陆用户信息（如无则添加）
/// </summary>
/// <param name="md"></param>
/// <returns></returns>
public mjuserinfo AddUser(mjuserinfo md, GameSession session)
{
mjuserinfoDAL dal = new mjuserinfoDAL();
mjuserinfo model = dal.GetModel(md.openid);
LogDAL Ldal = new LogDAL();
login_log Lmodel = new login_log();
if (model == null)
{
try
{
md.addtime = DateTime.Now;
// string fileName =Guid.NewGuid() + ".jpg"; ;
// string imgurl = PictureUtility.SavePicture(md.headimg, out fileName);//将图片保存至本地返回详细路径和文件名
// if (!string.IsNullOrEmpty(imgurl))//验证是否保存成功
// md.headimg = PutObjectSample.PutObjectFromFile(md.headimg, fileName, -1);//服务器没有图片，因此不能存储至图片服务器
dal.Add(md);
Lmodel.ID = Guid.NewGuid().ToString();
Lmodel.login_state = 1;
Lmodel.login_time = DateTime.Now;
Lmodel.openid = md.openid;
Lmodel.City = md.city;
Ldal.Add(Lmodel);
}
catch (Exception ex)
{
session.Logger.Error(ex);
}
return(dal.GetModel(md.openid));;
}
else
{
try
{
md.id = model.id;
//if (!md.Oldheadimg.Equals(model.Oldheadimg))
//{
// string fileName = Guid.NewGuid() + ".jpg"; ;
// //服务器没有图片，因此不能存储至图片服务器 md.headimg = PutObjectSample.PutObjectFromFile(md.headimg, fileName, -1);
//}
dal.Update(md);
Lmodel.ID = Guid.NewGuid().ToString();
Lmodel.login_state = 1;
Lmodel.login_time = DateTime.Now;
Lmodel.openid = md.openid;
Lmodel.City = md.city;
Ldal.Add(Lmodel);
}
catch (Exception ex)
{
session.Logger.Error(ex);
}
return(md);
}
}
/// <summary>
/// 删除一个月前的log
/// </summary>
public void ClearOverdueLog()
{
DateTime dt = DateTime.Now.AddDays(-30);
string datetime = dt.ToString("yyyy-MM-dd") + " 00:00:00.000";
LogDAL ld = new LogDAL();
ld.ClearOverdueLog(datetime);
}
public ActionResult Delete(NodeModel model)
{
if (NodeDAL.DeleteSubNodes(model))
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, "Node");
return(JsonSuccess(DeleteSuccess, "/Admin/Node/Index"));
}
return(Error(DeleteError));
}
public ActionResult Add(ProductModel model)
{
ViewData[EditFlag] = true;
if (model.Insert() != null)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(ProductModel));
return(JsonSuccess(""));
}
return(Error());
}
public ActionResult DemoAdd(DemoModel model)
{
ViewData[EditFlag] = true;
if (model.Insert() != null)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(DemoModel));
return(JsonSuccessJump());
}
return(JsonErrorJump());
}
public static List <Log> Listar(Log log)
{
try
{
return(LogDAL.Listar(log));
}catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit(GlobalSqlModel model)
{
ViewData[EditFlag] = true;
if (model.Update() > 0)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(GlobalSqlModel));
return(JsonSuccess(""));
}
return(JsonError(""));
}
public void TestMethod1()
{
LogDAL dal = new LogDAL();
Log log = new Log {
Thread = "1", Exception = "Test", Description = "test", Time = DateTime.Now
};
int result = dal.Insert(log);
Console.WriteLine(result);
}
public ActionResult Add(GroupModel model)
{
ViewData[EditFlag] = true;
if (model.Insert() != null)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(GroupModel));
return(JsonSuccess(SaveSuccess, "/Admin/Group/Index?Item.ProductId=" + model.ProductId));
}
return(Error());
}
public List <StudentLogEntityDC> GetAllStudentLogs(string Search, string AccountID, string StartDate, string EndDate, int PageIndex, int PageSize, out int Count)
{
List <StudentLogEntityDC> productResponse = new List <StudentLogEntityDC>();
StudentLogEntityDC member = new StudentLogEntityDC();
LogDAL LogsDAL = new LogDAL();
productResponse = LogsDAL.GetAllStudentLogs(Search, AccountID, StartDate, EndDate, PageIndex, PageSize, out Count);
return(productResponse);
}
public ActionResult Edit(LogModel model)
{
ViewData[EditFlag] = true;
if (model.Update() > 0)
{
LogDAL.AppendSQLLog(MTConfig.CurrentUserID, typeof(LogModel));
return(Success());
}
return(Error());
}
public static List <log_documentoEntity> getListLog(string fecha)
{
try
{
return(LogDAL.getListLog(fecha));
}
catch (BusinessException bx)
{
throw bx;
}
}
public CreateProjectResponse CreateProject(CreateProjectRequest request)
{
CreateProjectResponse response = new CreateProjectResponse();
LogDAL logDAL = new LogDAL();
string projectPath = ProjectBasePath + request.project.ProjectName;
string result = null;
logDAL.InsertLog(request.project.ToString());
logDAL.InsertLog(projectPath);
try
{
if (!Directory.Exists(projectPath))
{
result = Repository.Init(projectPath);
if (!string.IsNullOrWhiteSpace(result))
{
Repository repo = new Repository(projectPath);
//Create README.md file
File.WriteAllText(projectPath + "\\README.md", request.project.ProjectName);
//Create _Db.config file
File.WriteAllText(projectPath + "\\_Db.config", ProjectDomainHelper.ToFileContent(request.project));
//Git add
Commands.Stage(repo, "*");
// Create the committer's signature and commit
Signature author = new Signature(Properties.AuthorName, Properties.AuthorEmail, DateTime.Now);
Signature committer = new Signature(Properties.CommitterName, Properties.CommitterEmail, DateTime.Now);
repo.Commit("Project Initialization", author, committer);
}
else
{
response.StatusCode = StatusCodes.Status_Error;
response.StatusMessage = "Unable to create project";
}
}
else
{
logDAL.InsertLog("Project already exists");
response.StatusCode = StatusCodes.Status_Error;
response.StatusMessage = "Project already exists";
}
}
catch (Exception e)
{
logDAL.InsertLog(e.ToString());
}
response.Result = result;
return(response);
}
public static void WriteToLog(string msg, int userId)
{
LogDAL logDAL = new LogDAL();
logDAL.WriteToLog(msg, userId);
}