Esempio n. 1
0
        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)
            { }
        }
Esempio n. 2
0
 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)
     { }
 }