public string UpdateProgramGroup(ProgramGroup procGroup, int userid) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(7) { CommandText = StoreProcedure.Instance.GetScript("ProgramGroupUpdate") }; param.ParamStringFixedLength(0, "@PROG_TYPE_NAME", procGroup.PROG_TYPE_NAME); param.ParamInt32(1, "@ORDER_BY", procGroup.ORDER_BY); param.ParamStringFixedLength(2, "@ICON", procGroup.ICON); param.ParamStringFixedLength(3, "@DESCRIPTION", procGroup.DESCRIPTION); param.ParamStringFixedLength(4, "@PROG_TYPE_RESOURCE", procGroup.PROG_TYPE_RESOURCE); param.ParamStringFixedLength(5, "@IS_ACTIVE", (procGroup.IS_ACTIVE ? "Y" : "N")); param.ParamInt32(6, "@PROG_TYPE_ID", procGroup.PROG_TYPE_ID); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public bool Edit(ProgramGroup programGroup) { if (_programGroupService.UpdateEntity(programGroup)) { return(true); } return(false); }
static void Main(string[] args) { ProgramGroup group = new ProgramGroup(); Console.WriteLine("演员阵容"); group[0] = new Player(); group[0].Name = "甄子丹"; group[0].Role = "叶问"; group[1] = new Player(); group[1].Name = "熊黛林"; group[1].Role = "叶太太"; for (int i = 0; i < 2; i++) { Console.WriteLine(group[i].Name); } Console.ReadLine(); }
public List <ProgramGroup> GetProgramGroupList() { List <ProgramGroup> lstProcGroup = null; ProgramGroup procGroup; try { string sql = StoreProcedure.Instance.GetScript("GetProgramGroupList"); SQLiteReader.Instance.SLReader = GlobalSqliteDB.Instance.DataAc.ExecuteDataReader(sql); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (SQLiteReader.Instance.HasRows) { lstProcGroup = new List <ProgramGroup>(); while (SQLiteReader.Instance.SLReader.Read()) { procGroup = new ProgramGroup(); procGroup.PROG_TYPE_ID = SQLiteReader.Instance.GetInteger("PROG_TYPE_ID"); procGroup.PROG_TYPE_NAME = SQLiteReader.Instance.GetString("PROG_TYPE_NAME"); procGroup.ORDER_BY = SQLiteReader.Instance.GetInteger("ORDER_BY"); procGroup.ICON = SQLiteReader.Instance.GetString("ICON"); procGroup.DESCRIPTION = SQLiteReader.Instance.GetString("DESCRIPTION"); procGroup.PROG_TYPE_RESOURCE = SQLiteReader.Instance.GetString("PROG_TYPE_RESOURCE"); procGroup.IS_ACTIVE = (SQLiteReader.Instance.GetString("IS_ACTIVE").ToUpper() == "Y"); lstProcGroup.Add(procGroup); } } //Always call Close when done reading. SQLiteReader.Instance.Close(); } catch (Exception ex) { lstProcGroup = null; } return(lstProcGroup); }
//新增媒体群组 public IActionResult ToAddGroup(string id, string pId) { ProgramGroup obj = new ProgramGroup(); obj.pgroup_name = "new Group"; if (!Shared.IsNum(id)) { obj.parent_id = 0; obj.group_id = Shared.ExtractNum(id); } else { obj.parent_id = Shared.ExtractNum(id); if (!Shared.IsNum(pId)) { obj.group_id = Shared.ExtractNum(pId); } else { string url = string.Format("{0}?id={1}", group_url_get, Shared.ExtractNum(pId)); string jsonStr = HttpHelper.HttpGet(url); List <ProgramGroup> _programGroup = JsonConvert.DeserializeObject <List <ProgramGroup> >(jsonStr); if (_programGroup.Count > 0) { obj.group_id = _programGroup[0].group_id; } } } string postData = JsonConvert.SerializeObject(obj); int bigId = Convert.ToInt32(HttpHelper.HttpPost(group_url_add, postData)); if (bigId > 0) { obj.id = bigId; return(Json(obj)); } else { return(Json(false)); } }
/// <summary> /// 修改媒体群组信息 /// </summary> /// <param name="id">媒体群组的id</param> /// <param name="mgroup_name">媒体群组名称</param> /// <returns></returns> public IActionResult ToPutGroup(int id, string pgroup_name) { string url = string.Format("{0}?id={1}", group_url_get, id); string jsonStr = HttpHelper.HttpGet(url); List <ProgramGroup> _programGroup = JsonConvert.DeserializeObject <List <ProgramGroup> >(jsonStr); if (_programGroup.Count > 0) { ProgramGroup obj = _programGroup[0]; obj.pgroup_name = pgroup_name; obj.create_time = DateTime.Now; string postData = JsonConvert.SerializeObject(obj); bool result = Convert.ToBoolean(HttpHelper.HttpPut(group_url_edit, postData)); return(Json(result)); } else { return(Json(false)); } }
public ProgramGroup GetProgramGroupById(int progGroupId) { ProgramGroup procGroup = null; try { SQLiteParam param = new SQLiteParam(1) { CommandText = StoreProcedure.Instance.GetScript("GetProgramGroupById") }; param.ParamInt32(0, "@PROG_TYPE_ID", progGroupId); SQLiteReader.Instance.SLReader = GlobalSqliteDB.Instance.DataAc.ExecuteDataReader(param); if (SQLiteReader.Instance.HasRows) { while (SQLiteReader.Instance.SLReader.Read()) { procGroup = new ProgramGroup(); procGroup.PROG_TYPE_ID = SQLiteReader.Instance.GetInteger("PROG_TYPE_ID"); procGroup.PROG_TYPE_NAME = SQLiteReader.Instance.GetString("PROG_TYPE_NAME"); procGroup.ORDER_BY = SQLiteReader.Instance.GetInteger("ORDER_BY"); procGroup.ICON = SQLiteReader.Instance.GetString("ICON"); procGroup.DESCRIPTION = SQLiteReader.Instance.GetString("DESCRIPTION"); procGroup.PROG_TYPE_RESOURCE = SQLiteReader.Instance.GetString("PROG_TYPE_RESOURCE"); procGroup.IS_ACTIVE = (SQLiteReader.Instance.GetString("IS_ACTIVE").ToUpper() == "Y"); } } //Always call Close when done reading. SQLiteReader.Instance.Close(); } catch (Exception ex) { procGroup = null; } return(procGroup); }
// checks for the existence of a subprogram by the pattern and adds it if it matches up or if it is completely novel void addToProgramsByPatternIfNotExistOrPatternMatches(bool[] pattern, SubprogramWithMetaInfo subprogram) { if (programsWithIdByPattern.ContainsKey(pattern)) { var subprogramsByPattern = programsWithIdByPattern[pattern].Item1; ProgramGroup matchingProgramGroup = null; foreach (ProgramGroup iProgramGroup in subprogramsByPattern) { if (iProgramGroup.checkMatchesSubprogram(pattern, subprogram)) { matchingProgramGroup = iProgramGroup; break; } } bool existsSame = matchingProgramGroup != null; if (existsSame) { // add a count to the ProgramGroup matchingProgramGroup.incrementMatchCounter(); } else { // add it subprogramsByPattern.Add(new ProgramGroup(subprogram)); } } else { programsWithIdByPattern[pattern] = new Tuple <IList <ProgramGroup>, uint>( new List <ProgramGroup> { new ProgramGroup(subprogram) }, returnNewPatternId() ); } }
public string InsertProgramGroup(ref ProgramGroup procGroup) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(6) { CommandText = StoreProcedure.Instance.GetScript("ProgramGroupInsert") }; param.ParamStringFixedLength(0, "@PROG_TYPE_NAME", procGroup.PROG_TYPE_NAME); param.ParamInt32(1, "@ORDER_BY", procGroup.ORDER_BY); param.ParamStringFixedLength(2, "@ICON", procGroup.ICON); param.ParamStringFixedLength(3, "@DESCRIPTION", procGroup.DESCRIPTION); param.ParamStringFixedLength(4, "@PROG_TYPE_RESOURCE", procGroup.PROG_TYPE_RESOURCE); param.ParamStringFixedLength(5, "@IS_ACTIVE", (procGroup.IS_ACTIVE ? "Y" : "N")); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); object resultid = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT SEQ FROM sqlite_sequence WHERE NAME = 'M_PROGRAM_TYPE'"); if (resultid != null) { procGroup.PROG_TYPE_ID = Convert.ToInt32(resultid); } result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public int Add(ProgramGroup programGroup) { int bigId = (int)_programGroupService.InsertBigIdentity(programGroup); return(bigId); }
/// <summary> /// 返回Group群组 /// </summary> /// <returns></returns> public IActionResult ToSelectGroup() { List <ZTree> objList = new List <ZTree>(); //获取用户群组 Expression <Func <UserGroup, bool> > _expressionUserGroup = _expressionUserGroup = f => 0 == 0; List <UserGroup> objUserGroupList = _userGroupService.QueryableToList(_expressionUserGroup); if (objUserGroupList.Count > 0) { //读取媒体群组 string url = string.Format("{0}?id=-1", group_url_get); string jsonStr = HttpHelper.HttpGet(url); List <ProgramGroup> objProgramGroupList = JsonConvert.DeserializeObject <List <ProgramGroup> >(jsonStr); List <ProgramGroup> programGroupList = new List <ProgramGroup>(); foreach (var itme in objUserGroupList) { ZTree obj = new ZTree(); obj.id = GlobalParameter._PREFIX + itme.id; obj.name = itme.group_name; obj.pId = "0"; obj.open = true; objList.Add(obj); if (objProgramGroupList.Where(f => f.group_id == itme.id).ToList().Count <= 0)//判断媒体群组是否需要建立默认的 { ProgramGroup programGroup = new ProgramGroup(); programGroup.parent_id = 0; programGroup.pgroup_name = "new group"; programGroup.group_id = itme.id; programGroupList.Add(programGroup); } } //新增默认的媒体群组 if (programGroupList.Count > 0) { foreach (var items in programGroupList) { string data = JsonConvert.SerializeObject(items); HttpHelper.HttpPost(group_url_add, data); } } //重新获取媒体群组 if (objProgramGroupList.Count <= 0) { objProgramGroupList = JsonConvert.DeserializeObject <List <ProgramGroup> >(HttpHelper.HttpGet(url)); } foreach (var itme in objProgramGroupList) { ZTree obj = new ZTree(); obj.id = itme.id.ToString(); obj.name = itme.pgroup_name; if (itme.parent_id == 0) { obj.pId = GlobalParameter._PREFIX + itme.group_id; } else { obj.pId = itme.parent_id.ToString(); } objList.Add(obj); } } return(Json(objList)); }
public ProgramGroup Save(ProgramGroup programGroup) { context.ProgramGroups.Add(programGroup); context.SaveChanges(); return(programGroup); }
public ProgramGroup Save(ProgramGroup programGroup) { return(dao.Save(programGroup)); }
/// <summary> /// 查找程序组 /// </summary> /// <param name="program"></param> /// <returns></returns> public NCGroup FindProgram(string program) { return(ProgramGroup.Find(a => a.Name.Equals(program, StringComparison.CurrentCultureIgnoreCase))); }
public async Task <IActionResult> AddProgramGroup(Input_ProgramGroup model, [FromServices] ContextString dbContext) { QianMuResult _Result = new QianMuResult(); Stream stream = HttpContext.Request.Body; byte[] buffer = new byte[HttpContext.Request.ContentLength.Value]; stream.Read(buffer, 0, buffer.Length); string inputStr = Encoding.UTF8.GetString(buffer); model = (Input_ProgramGroup)Newtonsoft.Json.JsonConvert.DeserializeObject(inputStr, model.GetType()); if (string.IsNullOrEmpty(model.MallCode)) { //检测用户登录情况 var uol = Method.GetLoginUserName(dbContext, this.HttpContext); if (string.IsNullOrEmpty(uol.UserName)) { _Result.Code = "401"; _Result.Msg = "请登陆后再进行操作"; _Result.Data = ""; return(Json(_Result)); } else { model.MallCode = uol.MallCode; } } var mall = await dbContext.Mall.Where(i => i.Code == model.MallCode).FirstOrDefaultAsync(); if (mall == null) { _Result.Code = "510"; _Result.Msg = "无效的商场编码"; _Result.Data = ""; return(Json(_Result)); } if (string.IsNullOrEmpty(model.GroupName)) { _Result.Code = "510"; _Result.Msg = "名称不可为空"; _Result.Data = ""; return(Json(_Result)); } int sCount = dbContext.ScreenInfo.Where(i => i.Code == model.ScreenInfoCode).Count(); if (sCount <= 0) { _Result.Code = "510"; _Result.Msg = "未知的屏幕类型"; _Result.Data = ""; return(Json(_Result)); } //判断节目组是否已存在 int count = dbContext.ProgramGroup.Where(i => i.MallCode == model.MallCode && i.GroupName == model.GroupName).Count(); if (count > 0) { _Result.Code = "1"; _Result.Msg = "节目组已存在"; _Result.Data = ""; return(Json(_Result)); } //检查组中的节目 if (model.Programs.Count() > 0) { //判断ID是否都为有效节目 foreach (var item in model.Programs) { var q = await dbContext.Programs.Where(i => i.Code == item).CountAsync(); if (q <= 0) { _Result.Code = "3"; _Result.Msg = "Erro:没有编码为:" + item + "的节目"; _Result.Data = ""; return(Json(_Result)); } var pro = await dbContext.Programs.Where(i => i.Code == item).FirstOrDefaultAsync(); if (pro.ProgScreenInfo != model.ScreenInfoCode) { _Result.Code = "3"; _Result.Msg = "节目:" + pro.ProgramName + "的分辨率与节目组分辨率不一致"; _Result.Data = ""; return(Json(_Result)); } } } //添加节目组 ProgramGroup pg = new ProgramGroup(); pg.MallCode = model.MallCode; pg.AddTime = DateTime.Now; pg.GroupName = model.GroupName; pg.ScreenInfoCode = model.ScreenInfoCode; pg.Code = Guid.NewGuid().ToString(); pg.UpdateTime = DateTime.Now; dbContext.ProgramGroup.Add(pg); if (await dbContext.SaveChangesAsync() > 0) { //添加节目到节目组 var ts = 0; if (model.Programs.Count > 0) { int index = 1; foreach (var item in model.Programs) { var prog = await dbContext.Programs.Where(i => i.Code == item).FirstOrDefaultAsync(); if (prog.LaunchTime <= DateTime.Now && DateTime.Now <= prog.ExpiryDate) { ts += prog.SwitchTime; } dbContext.ProgramToGroup.Add(new ProgramToGroup { AddTime = DateTime.Now, ProgramCode = item, GroupCode = pg.Code, Order = index, Code = Guid.NewGuid().ToString(), UpdateTime = DateTime.Now }); index++; } if (await dbContext.SaveChangesAsync() > 0) { _Result.Code = "200"; _Result.Msg = "添加成功"; _Result.Data = ""; //var ip = Method.GetUserIp(this.HttpContext); //dbContext.SysLog.Add(new SysLog { AccountName = username, ModuleName = "节目组模块", LogMsg = username + "创建了节目组:" + model.GroupName, AddTime = DateTime.Now, Code = Guid.NewGuid().ToString(), Type = "创建", IP = ip }); //dbContext.SaveChanges(); } else { _Result.Code = "4"; _Result.Msg = "添加节目到节目组失败"; _Result.Data = ""; } } else { _Result.Code = "200"; _Result.Msg = "添加成功"; _Result.Data = ""; //var ip = Method.GetUserIp(this.HttpContext); //dbContext.SysLog.Add(new SysLog { AccountName = username, ModuleName = "节目组模块", LogMsg = username + "创建了节目组:" + model.GroupName, AddTime = DateTime.Now, Code = Guid.NewGuid().ToString(), Type = "创建", IP = ip }); //dbContext.SaveChanges(); } /* * //添加节目组同步策略 * dbContext.DevSyn.Add(new DevSyn * { * AddTime = DateTime.Now, * UpdateTime = DateTime.Now, * Code = Guid.NewGuid().ToString(), * EffectTime = DateTime.Now.Date, * LastAcceptTime = DateTime.Now.Date, * ProgramGroupCode = pg.Code, * TimeSpan = ts * }); */ } else { _Result.Code = "5"; _Result.Msg = "添加节目组失败"; _Result.Data = ""; } return(Json(_Result)); }