/// <summary> /// 更新一条数据 /// </summary> public int Update(ADT.XingZhi.Models.S.LoginTimes model) { try { SqlParameter[] param = { new SqlParameter("@userName", SqlDbType.VarChar, 20), new SqlParameter("@ip", SqlDbType.VarChar, 20), new SqlParameter("@isAdmin", SqlDbType.Bit) }; param[0].Value = model.UserName; param[1].Value = model.IP; param[2].Value = model.IsAdmin; return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "UPDATE [S_LOGINTIMES] SET LT_IP=@ip,LT_LOGINTIME=GETDATE(),LT_TIMES=LT_TIMES+1 WHERE U_NAME=@userName AND LT_ISADMIN=@isAdmin", param)); } catch (ArgumentNullException ex) { logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生Exception", ex); } return(-1); }
/// <summary> /// 新增一条数据 /// </summary> public int Add(ADT.XingZhi.Models.S.LoginTimes model) { try { SqlParameter[] param = { new SqlParameter("@userName", SqlDbType.VarChar, 20), new SqlParameter("@ip", SqlDbType.VarChar, 20), new SqlParameter("@isAdmin", SqlDbType.Bit) }; param[0].Value = model.UserName; param[1].Value = model.IP; param[2].Value = model.IsAdmin; return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "INSERT INTO [S_LOGINTIMES](U_NAME,LT_IP,LT_LOGINTIME,LT_ISADMIN,LT_TIMES) VALUES(@userName,@ip,GETDATE(),@isAdmin,1)", param)); return(Convert.ToInt32(param[6].Value)); } catch (ArgumentNullException ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生Exception", ex); } return(-1); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(ADT.XingZhi.Models.S.LoginTimes model) { return(dal.Update(model)); }
/// <summary> /// 新增一条数据 /// </summary> public int Add(ADT.XingZhi.Models.S.LoginTimes model) { return(dal.Add(model)); }