public static bool Update(int generalId, string userNameArr)
{
List <string> list = ConvertToList(userNameArr);
List <string> list2 = ConvertToList(GetSignInUsers(generalId));
foreach (string str in list)
{
if (!list2.Contains(str))
{
SignInLogInfo signInLogInfo = new SignInLogInfo();
signInLogInfo.GeneralId = generalId;
signInLogInfo.UserName = str;
signInLogInfo.IsSignIn = false;
signInLogInfo.IP = "";
signInLogInfo.SignInTime = DateTime.Now;
dal.Add(signInLogInfo);
}
}
foreach (string str2 in list2)
{
if (!list.Contains(str2))
{
Delete(generalId, str2);
}
}
return(true);
}
public bool Add(SignInLogInfo signInLogInfo)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@GeneralId", DbType.Int32, signInLogInfo.GeneralId);
cmdParams.AddInParameter("@IP", DbType.String, signInLogInfo.IP);
cmdParams.AddInParameter("@IsSignin", DbType.Boolean, signInLogInfo.IsSignIn);
cmdParams.AddInParameter("@SigninTime", DbType.DateTime, signInLogInfo.SignInTime);
cmdParams.AddInParameter("@UserName", DbType.String, signInLogInfo.UserName);
return(DBHelper.ExecuteSql("INSERT INTO PE_SigninLog (GeneralId, UserName, IsSignin, SigninTime, IP) VALUES (@GeneralId, @UserName, @IsSignin, @SigninTime, @IP)", cmdParams));
}
private static SignInLogInfo SigninLogInfoFromDataReader(NullableDataReader dr)
{
SignInLogInfo info = new SignInLogInfo();
info.GeneralId = dr.GetInt32("GeneralId");
info.IP = dr.GetString("IP");
info.IsSignIn = dr.GetBoolean("IsSignin");
info.SignInTime = dr.GetDateTime("SigninTime");
info.UserName = dr.GetString("UserName");
return(info);
}
public static bool Add(int generalId, string userNameArr)
{
foreach (string str in userNameArr.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
SignInLogInfo signInLogInfo = new SignInLogInfo();
signInLogInfo.GeneralId = generalId;
signInLogInfo.UserName = str;
signInLogInfo.IsSignIn = false;
signInLogInfo.IP = "";
signInLogInfo.SignInTime = DateTime.Now;
dal.Add(signInLogInfo);
}
return(true);
}
public SignInLogInfo GetSignInLog(int generalId, string userName)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@GeneralID", DbType.Int32, generalId);
cmdParams.AddInParameter("@UserName", DbType.String, userName);
SignInLogInfo info = new SignInLogInfo(true);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_SigninLog WHERE GeneralID = @GeneralID AND UserName = @UserName", cmdParams))
{
if (reader.Read())
{
info = SigninLogInfoFromDataReader(reader);
}
}
return(info);
}
private string GetSigninStatus(int generalId)
{
if (!PEContext.Current.User.Identity.IsAuthenticated)
{
return("NoLogin");
}
SignInLogInfo signInLog = SignInLog.GetSignInLog(generalId, PEContext.Current.User.UserName);
if (signInLog.IsNull)
{
return("NoSignin");
}
if (signInLog.IsSignIn)
{
return("Signined");
}
return("NotSignin");
}
public static bool Add(SignInLogInfo signInLogInfo)
{
return(dal.Add(signInLogInfo));
}
