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