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); } }