public static HQuery <int, VALUE>[] HToQuery <VALUE>(this IList <VALUE> list)
{
int count = list.Count;
HQuery <int, VALUE>[] query = new HQuery <int, VALUE> [count];
for (int i = 0; i < count; i++)
{
query[i] = new HQuery <int, VALUE>
{
key = i,
value = list[i],
}
}
;
return(query);
}
public void ChangeToRead(Guid infoID)
{
EWebSMSInfo info = GetInfo(infoID);
if (info == null)
return;
//using (IRepository repository = SessionManager.CreateRepository(typeof(EWebSMSAndUser)))
//{
// repository.Register(typeof(EWebSMSAndUser));
// HQuery query = new HQuery("Update EWebSMSAndUser Set IsRead = :IsRead , ReadTime = :ReadTime Where SMSInfoID = :SMSInfoID and IsRead=" + (int)EnumIsRead.UnRead);
// query.Parameters.Add("IsRead", Convert.ToBoolean(EnumIsRead.Readed));
// query.Parameters.Add("ReadTime", DateTime.Now);
// query.Parameters.Add("SMSInfoID", infoID);
// repository.Execute(query);
//}
string sql = string.Format("Update gps_websmsanduser Set IsRead = {0} , ReadTime = '{1}' Where SMSInfoID = '{2}' and IsRead={3}",
(int)EnumIsRead.Readed, DateTime.Now, infoID, (int)EnumIsRead.UnRead);
MySqlHelper.ExecuteNonQuery(DefaultConnectionString, sql,120);
if (info.VehicleCode.HasValue)
{
IVehicleRunningStateManager stateManger = new VehicleRunningStateManager();
stateManger.CheckAndDelete(info.VehicleCode.Value, info.Type);
}
using (IRepository repository = SessionManager.CreateRepository(typeof(EWebSMSAndUser_New)))
{
repository.Register(typeof(EWebSMSAndUser_New));
HQuery query = new HQuery("Delete From EWebSMSAndUser_New Where SMSInfoID = :SMSInfoID ");
query.Parameters.Add("SMSInfoID", infoID);
repository.Execute(query);
}
}
public void ChangeToAllRead(string userCode)
{
//using (IRepository repository = SessionManager.CreateRepository(typeof(EWebSMSAndUser)))
//{
// CheckAndDeleteRunningState(userCode);
// repository.Register(typeof(EWebSMSAndUser));
// HQuery query = new HQuery("Update EWebSMSAndUser Set IsRead = :IsRead , ReadTime = :ReadTime Where ReceiveUserCode = :UserCode and IsRead="+(int)EnumIsRead.UnRead);
// query.Parameters.Add("IsRead", Convert.ToBoolean(EnumIsRead.Readed));
// query.Parameters.Add("ReadTime", DateTime.Now);
// query.Parameters.Add("UserCode", userCode);
// repository.Execute(query);
//}
CheckAndDeleteRunningState(userCode);
string sql = string.Format("Update gps_websmsanduser Set IsRead = {0} , ReadTime = '{1}' Where ReceiveUserCode = '{2}' and IsRead={3}",
(int)EnumIsRead.Readed, DateTime.Now, userCode, (int)EnumIsRead.UnRead);
MySqlHelper.ExecuteNonQuery(DefaultConnectionString, sql,300);
using (IRepository repository = SessionManager.CreateRepository(typeof(EWebSMSAndUser_New)))
{
repository.Register(typeof(EWebSMSAndUser_New));
HQuery query = new HQuery("Delete From EWebSMSAndUser_New Where ReceiveUserCode = :UserCode ");
query.Parameters.Add("UserCode", userCode);
repository.Execute(query);
}
}
