// public int AddUser_DrinkCostSerialList(string SerialNumber, string IcCardNo, string CostTime, string DeviceCode, string CostFee, string RunningWaterLitre, string CurrentUserBalance) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var DrinkCostSeria_tmp = new jjj_user_DrinkCostSerialList { SerialNumber = SerialNumber, IcCardNo = IcCardNo, CostTime = Convert.ToDateTime(CostTime), DeviceCode = DeviceCode, CostFee = Convert.ToDecimal(CostFee), RunningWaterLitre = Convert.ToDecimal(RunningWaterLitre), CurrentUserBalance = Convert.ToDecimal(CurrentUserBalance) }; ctx.jjj_user_DrinkCostSerialList.Add(DrinkCostSeria_tmp); count = ctx.SaveChanges(); } return count; }
// /// <summary> /// 添加一条用户基础信息 /// </summary> /// <param name="usernameTmp"></param> /// <param name="passwordTmp"></param> /// <param name="phoneTmp"></param> /// <param name="isEnableTmp"></param> public int AddUserInfo1(string usernameTmp, string passwordTmp, string phoneTmp, int isEnableTmp) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var userinfo_tmp = new jjj_users { username = usernameTmp, password = passwordTmp, phone = phoneTmp, isEnable = isEnableTmp }; ctx.jjj_users.Add(userinfo_tmp); count = ctx.SaveChanges(); } return count; }
public int DeleteUserInfo1(int uidTmp) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_users where a.uid == uidTmp select a; foreach (var item in query) { ctx.jjj_users.Remove(item); } count = ctx.SaveChanges(); } return count; }
public int UpdateUserPassword1(int uidTmp, string passwordTmp) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_users where a.uid == uidTmp select a; foreach (var item in query) { item.password = passwordTmp; } count = ctx.SaveChanges(); } return count; }
public int UpdateTerminalEquipmentSerialCommand2(int TerSerialCommandID, int SendStatus) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_TerminalEquipmentSerialCommand where a.TerSerialCommandID == TerSerialCommandID select a; foreach (var item in query) { item.SendStatus = SendStatus; } count = ctx.SaveChanges(); } return count; }
public int UpdateTerminalEquipmentInfo3(int TerminalEquipmentIDTmp, int IsSendTmp) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_TerminalEquipmentList where a.TerminalEquipmentID == TerminalEquipmentIDTmp select a; foreach (var item in query) { item.IsSend = IsSendTmp; } count = ctx.SaveChanges(); } return count; }
public int UpdateTerminalEquipmentInfo2(string sessionIDTmp) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_TerminalEquipmentList where a.SessionId == sessionIDTmp select a; foreach (var item in query) { item.TerminalStatus = 0; } count = ctx.SaveChanges(); } return count; }
// public int Updatejjj_TerminalSwitchScreenTime1(int TerminalEquipmentID, int IsSend) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_TerminalSwitchScreenTime where a.TerminalEquipmentID == TerminalEquipmentID select a; foreach (var item in query) { item.UpdateTime = DateTime.Now; item.IsSend = IsSend; } count = ctx.SaveChanges(); } return count; }
public int Updatejjj_ProgramSendSerialList3(int ProgramSendSerialID, int SendStatus, Nullable<DateTime> DownloadOverTime) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_ProgramSendSerialList where a.ProgramSendSerialID == ProgramSendSerialID select a; foreach (var item in query) { item.SendStatus = SendStatus; item.DownloadOverTime = DownloadOverTime; } count = ctx.SaveChanges(); } return count; }
public int Updatejjj_ProgramSendSerialList1(int ProgramSendSerialID, int SendStatus) { int count = 0; using (var ctx = new MultimediaSYSEntities()) { var query = from a in ctx.jjj_ProgramSendSerialList where a.ProgramSendSerialID == ProgramSendSerialID select a; foreach (var item in query) { item.SendStatus = SendStatus; } count = ctx.SaveChanges(); } return count; }