public void WriteLogout(string loginCode) { try { using (IDbConnection conn = new SqlConnection(PubConstant.hmWyglConnectionString)) { var userCode = conn.Query <string>("SELECT UserCode FROM Tb_Sys_User WHERE LoginCode=@LoginCode AND isnull(IsDelete,0)=0", new { LoginCode = loginCode }).FirstOrDefault(); if (!string.IsNullOrEmpty(userCode)) { int iCorpID = AppGlobal.StrToInt(Global_Var.LoginCorpID); int iBranchID = AppGlobal.StrToInt(Global_Var.LoginBranchID); int iCommID = AppGlobal.StrToInt(Global_Var.LoginCommID); MobileSoft.Model.Sys.Tb_Sys_Log Item = new MobileSoft.Model.Sys.Tb_Sys_Log(); Item.CorpID = iCorpID; Item.BranchID = iBranchID; Item.CommID = iCommID; Item.LocationIP = ""; Item.ManagerCode = userCode; Item.LogTime = DateTime.Now; Item.OperateName = "登出系统"; Item.Memo = "物管App登出"; Item.OperateURL = ""; conn.Insert <MobileSoft.Model.Sys.Tb_Sys_Log>(Item); } } } catch (Exception ex) { } }
public void WriteLog(DataRow Rows, string OperateName) { try { IDbConnection con = new System.Data.SqlClient.SqlConnection(PubConstant.hmWyglConnectionString); int iCorpID = AppGlobal.StrToInt(Global_Var.LoginCorpID); int iBranchID = AppGlobal.StrToInt(Global_Var.LoginBranchID); int iCommID = AppGlobal.StrToInt(Global_Var.LoginCommID); MobileSoft.Model.Sys.Tb_Sys_Log Item = new MobileSoft.Model.Sys.Tb_Sys_Log(); Item.CorpID = iCorpID; Item.BranchID = iBranchID; Item.CommID = iCommID; Item.LocationIP = ""; Item.ManagerCode = Rows["UserCode"].ToString(); Item.LogTime = DateTime.Now; Item.OperateName = OperateName; Item.Memo = "物管App登录"; Item.OperateURL = ""; con.Insert <MobileSoft.Model.Sys.Tb_Sys_Log>(Item); //(new BusinessRule.TWBusinRule(LoginSQLConnStr)).Sys_Log_Base_Insert(ref Item); } catch (Exception ex) { } }