public void TableUsingReduce(int?Table_Id) { try { //获取表的引用,减少引用次数 Eva_Table table = Constant.Eva_Table_List.FirstOrDefault(t => Table_Id == t.Id); if (table != null) { //克隆该表格 Eva_Table table_clone = Constant.Clone <Eva_Table>(table); if (table_clone.UseTimes > 0) { table_clone.UseTimes -= 1; JsonModel m3 = Constant.Eva_TableService.Update(table_clone); if (m3.errNum == 0) { table.UseTimes -= 1; } } } } catch (Exception ex) { LogHelper.Error(ex); } }
public static void Eva_Table_Add(Eva_Table Eva_Table) { try { if (!Eva_Table_List.Contains(Eva_Table)) { Eva_Table_List.Add(Eva_Table); } } catch (Exception ex) { LogHelper.Error(ex); } }
private static void Reg_Table_Add_Helper(string CreateUID, string EditUID, Eva_Regular Eva_Regular, int[] tables, int[] eva_roles, string[] course_types) { try { //匹配并进行关联 for (int i = 0; i < tables.Count(); i++) { //定期评价添加 Eva_Distribution distribution = new Eva_Distribution() { CousrseType_Id = course_types[i], Evaluate_Id = Eva_Regular.Id, Eva_Role = eva_roles[i], CreateTime = DateTime.Now, CreateUID = CreateUID, EditTime = DateTime.Now, EditUID = EditUID, IsDelete = (int)IsDelete.No_Delete, IsEnable = (int)IsEnable.Enable, Table_Id = tables[i] }; JsonModel model = Constant.Eva_DistributionService.Add(distribution); if (model.errNum == (int)errNum.Success) { if (!Constant.Eva_Distribution_List.Contains(distribution)) { Constant.Eva_Distribution_List.Add(distribution); distribution.Id = RequestHelper.int_transfer(Convert.ToString(model.retData)); //表格的计数 Eva_Table table = Constant.Eva_Table_List.FirstOrDefault(t => t.Id == tables[i]); //直接进行更改 if (table != null) { table.UseTimes += 1; JsonModel m = Constant.Eva_TableService.Update(table); } } } } } catch (Exception ex) { LogHelper.Error(ex); } }
public static void Eva_Table_Update(Eva_Table Eva_Table) { try { if (Eva_Table != null) { if (Eva_Table_List.Contains(Eva_Table)) { Eva_Table_List.Remove(Eva_Table); } } } catch (Exception ex) { LogHelper.Error(ex); } }
/// <summary> /// 编辑表格 /// </summary> public void Enable_Eva_Table(HttpContext context) { lock (obj_Enable_Eva_Table) { int intSuccess = (int)errNum.Success; HttpRequest Request = context.Request; //表格Id int table_Id = RequestHelper.int_transfer(Request, "table_Id"); int IsEnable = RequestHelper.int_transfer(Request, "IsEnable"); try { //获取指定要删除的表格 Eva_Table Eva_Table_edit = Constant.Eva_Table_List.FirstOrDefault(i => i.Id == table_Id); if (Eva_Table_edit != null) { //克隆该表格 Eva_Table Eva_Table_clone = Constant.Clone <Eva_Table>(Eva_Table_edit); Eva_Table_clone.IsEnable = (byte)IsEnable; //数据库操作成功再改缓存 jsonModel = Constant.Eva_TableService.Update(Eva_Table_clone); if (jsonModel.errNum == intSuccess) { Eva_Table_edit.IsEnable = (byte)IsEnable; } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "编辑失败"); } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "该表格不存在"); } } catch (Exception ex) { LogHelper.Error(ex); } finally { //无论后端出现什么问题,都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】 context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } } }
public static void Eva_Table_Remove(int Id) { try { Eva_Table Eva_Table = Eva_Table_List.FirstOrDefault(t => t.Id == Id); if (Eva_Table != null) { if (Eva_Table_List.Contains(Eva_Table)) { Eva_Table_List.Remove(Eva_Table); } } } catch (Exception ex) { LogHelper.Error(ex); } }
/// <summary> /// 表格详情表创建添加 /// </summary> /// <param name="CreateUID"></param> /// <param name="EditUID"></param> /// <param name="Eva_Table_Add"></param> /// <param name="Table_A_List"></param> private static void Eva_TableAdd_Helper(string CreateUID, string EditUID, Eva_Table Eva_Table_Add, List <Table_A> Table_A_List) { var Table_Id = Eva_Table_Add.Id; //开启线程操作数据库 new Thread(() => { try { foreach (Table_A table_A in Table_A_List) { //表明细列表保证不为null513 if (table_A.indicator_list == null) { continue; } foreach (indicator_list item in table_A.indicator_list) { Eva_TableDetail Eva_TableDetail = new Eva_TableDetail() { CreateTime = DateTime.Now, EditTime = DateTime.Now, CreateUID = CreateUID, EditUID = EditUID, Indicator_Id = (int)item.Id, IndicatorType_Id = (int)item.IndicatorType_Id, IndicatorType_Name = item.IndicatorType_Name, OptionA = item.OptionA, OptionB = item.OptionB, OptionC = item.OptionC, OptionD = item.OptionD, OptionE = item.OptionE, OptionF = item.OptionF, OptionA_S = RequestHelper.decimal_transfer(item.OptionA_S), OptionB_S = RequestHelper.decimal_transfer(item.OptionB_S), OptionC_S = RequestHelper.decimal_transfer(item.OptionC_S), OptionD_S = RequestHelper.decimal_transfer(item.OptionD_S), OptionE_S = RequestHelper.decimal_transfer(item.OptionE_S), OptionF_S = RequestHelper.decimal_transfer(item.OptionF_S), //Indicator_Name = item.Name, IsDelete = (int)IsDelete.No_Delete, IsEnable = (int)IsEnable.Enable, Name = item.Name, QuesType_Id = (int)item.QuesType_Id, Remarks = item.Remarks, Sort = RequestHelper.int_transfer(item.Sort), Root = item.Root, RootID = item.RootID, Eva_table_Id = Table_Id, //评价任务 1,表格设计 0 Type = Convert.ToString((int)TableDetail_Type.Table), OptionF_S_Max = item.OptionF_S_Max, }; //入库 JsonModel model2 = Constant.Eva_TableDetailService.Add(Eva_TableDetail); if (model2.errNum == 0) { //添加到缓存 Constant.Eva_TableDetail_List.Add(Eva_TableDetail); Eva_TableDetail.Id = RequestHelper.int_transfer(Convert.ToString(model2.retData)); Indicate_Using_Add((int)item.Id); } } } } catch (Exception ex) { LogHelper.Error(ex); } }) { IsBackground = true }.Start(); }
/// <summary> /// 删除表格 /// </summary> public void Delete_Eva_Table(HttpContext context) { int intSuccess = (int)errNum.Success; HttpRequest Request = context.Request; //指标的ID int Id = RequestHelper.int_transfer(Request, "Id"); try { //获取指定要删除的表格 Eva_Table Eva_Table_delete = Constant.Eva_Table_List.FirstOrDefault(i => i.Id == Id); if (Eva_Table_delete != null) { //克隆该表格 Eva_Table indic = Constant.Clone <Eva_Table>(Eva_Table_delete); indic.IsDelete = (int)IsDelete.Delete; //数据库操作成功再改缓存 jsonModel = Constant.Eva_TableService.Update(indic); if (jsonModel.errNum == intSuccess) { Eva_Table_delete.IsDelete = (int)IsDelete.Delete; Constant.Eva_Table_List.Remove(Eva_Table_delete); List <Eva_Table_Header> Eva_Table_Header_List = Constant.Eva_Table_Header_List.Where(t => t.Table_Id == Id).ToList(); foreach (Eva_Table_Header item in Eva_Table_Header_List) { item.IsDelete = (int)IsDelete.Delete; var jm = Constant.Eva_Table_HeaderService.Update(item); if (jm.errNum == 0) { Constant.Eva_Table_Header_List.Remove(item); } } List <Eva_TableDetail> Eva_TableDetail_List = Constant.Eva_TableDetail_List.Where(t => t.Eva_table_Id == Id).ToList(); foreach (Eva_TableDetail item in Eva_TableDetail_List) { item.IsDelete = (int)IsDelete.Delete; var jsonmodel = Constant.Eva_TableDetailService.Update(item); if (jsonmodel.errNum == 0) { Constant.Eva_TableDetail_List.Remove(item); Indicate_Using_Reduce((int)item.Indicator_Id); } } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "删除失败"); } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "该表格不存在"); } } catch (Exception ex) { LogHelper.Error(ex); } finally { //无论后端出现什么问题,都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】 context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 编辑表格 /// </summary> public void Edit_Eva_Table(HttpContext context) { lock (obj_Edit_Eva_Table) { int intSuccess = (int)errNum.Success; HttpRequest Request = context.Request; //表格Id int table_Id = RequestHelper.int_transfer(Request, "table_Id"); try { //获取指定要删除的表格 Eva_Table Eva_Table_edit = Constant.Eva_Table_List.FirstOrDefault(i => i.Id == table_Id); if (Eva_Table_edit != null) { string Name = RequestHelper.string_transfer(Request, "Name"); int IsScore = RequestHelper.int_transfer(Request, "IsScore"); string Remarks = RequestHelper.string_transfer(Request, "Remarks"); string EditUID = RequestHelper.string_transfer(Request, "EditUID"); string CourseType_Id = RequestHelper.string_transfer(Request, "CourseType_Id"); int IsEnable = RequestHelper.int_transfer(Request, "IsEnable"); //克隆该表格 Eva_Table Eva_Table_clone = Constant.Clone <Eva_Table>(Eva_Table_edit); Eva_Table_clone.Name = Name; Eva_Table_clone.IsScore = (byte)IsScore; Eva_Table_clone.Remarks = Remarks; Eva_Table_clone.EditTime = DateTime.Now; Eva_Table_clone.EditUID = EditUID; Eva_Table_clone.IsEnable = (byte)IsEnable; //数据库操作成功再改缓存 jsonModel = Constant.Eva_TableService.Update(Eva_Table_clone); if (jsonModel.errNum == intSuccess) { Eva_Table_edit.Name = Name; Eva_Table_edit.IsScore = (byte)IsScore; Eva_Table_edit.Remarks = Remarks; Eva_Table_edit.EditTime = DateTime.Now; Eva_Table_edit.EditUID = EditUID; Eva_Table_edit.IsEnable = (byte)IsEnable; //表单明细 string List = RequestHelper.string_transfer(Request, "List"); //序列化表单详情列表 List <Table_A> Table_A_List = JsonConvert.DeserializeObject <List <Table_A> >(List); //先进行删除,然后进行添加 List <Eva_TableDetail> table_list = (from t in Constant.Eva_TableDetail_List where t.Eva_table_Id == Eva_Table_edit.Id select t).ToList(); //删除详情表 foreach (Eva_TableDetail item in table_list) { JsonModel m = Constant.Eva_TableDetailService.Delete((int)item.Id); if (m.errNum == intSuccess) { Constant.Eva_TableDetail_List.Remove(item); Indicate_Using_Reduce((int)item.Indicator_Id); } } Remove_Header((int)Eva_Table_edit.Id); //解析正常才可进行操作 if (Table_A_List != null) { //表格详情表创建添加 Eva_TableAdd_Helper(Eva_Table_edit.EditUID, EditUID, Eva_Table_edit, Table_A_List); string head_value = RequestHelper.string_transfer(Request, "head_value"); //string lisss = RequestHelper.string_transfer(Request, "lisss"); //表头信息添加 Table_Header((int)Eva_Table_edit.Id, head_value);//lisss } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "编辑失败"); } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "该表格不存在"); } } catch (Exception ex) { LogHelper.Error(ex); } finally { //无论后端出现什么问题,都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】 context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } } }
/// <summary> /// 复制表格 /// </summary> /// <param name="context">当前上下文</param> public void Copy_Eva_Table(HttpContext context) { lock (obj_Copy_Eva_Table) { HttpRequest Request = context.Request; int table_Id = RequestHelper.int_transfer(Request, "table_Id"); string CreateUID = RequestHelper.string_transfer(Request, "CreateUID"); try { Eva_Table Eva_Table_Need_Copy = Constant.Eva_Table_List.FirstOrDefault(t => t.Id == table_Id); if (Eva_Table_Need_Copy != null) { Eva_Table Eva_Table_Copy_Clone = Constant.Clone <Eva_Table>(Eva_Table_Need_Copy); Eva_Table_Copy_Clone.Id = null; Eva_Table_Copy_Clone.UseTimes = 0; Eva_Table_Copy_Clone.CreateUID = CreateUID; Eva_Table_Copy_Clone.EditUID = CreateUID; Eva_Table_Copy_Clone.CreateTime = DateTime.Now; Eva_Table_Copy_Clone.EditTime = DateTime.Now; jsonModel = Constant.Eva_TableService.Add(Eva_Table_Copy_Clone); if (jsonModel.errNum == 0) { Eva_Table_Copy_Clone.Id = Convert.ToInt32(jsonModel.retData); //添加克隆出来的表 Constant.Eva_Table_List.Add(Eva_Table_Copy_Clone); //表头复制 var table_headers = (from t_h in Constant.Eva_Table_Header_List where t_h.Table_Id == table_Id select t_h).ToList(); foreach (var header in table_headers) { Eva_Table_Header h_Clone = Constant.Clone <Eva_Table_Header>(header); h_Clone.Table_Id = Eva_Table_Copy_Clone.Id; h_Clone.Id = null; var jsonmodel = Constant.Eva_Table_HeaderService.Add(h_Clone); if (jsonmodel.errNum == 0) { h_Clone.Id = Convert.ToInt32(jsonmodel.retData); Constant.Eva_Table_Header_List.Add(h_Clone); } } //详情题干添加 var table_details = (from detail in Constant.Eva_TableDetail_List where detail.Eva_table_Id == table_Id select detail).OrderBy(t => t.Id).ToList(); foreach (var detail in table_details) { Eva_TableDetail detail_clone = Constant.Clone <Eva_TableDetail>(detail); detail_clone.Eva_table_Id = Eva_Table_Copy_Clone.Id; detail_clone.Id = null; var jsonmodel = Constant.Eva_TableDetailService.Add(detail_clone); if (jsonmodel.errNum == 0) { detail_clone.Id = Convert.ToInt32(jsonmodel.retData); Constant.Eva_TableDetail_List.Add(detail_clone); Indicate_Using_Add((int)detail_clone.Indicator_Id); } } } } } catch (Exception ex) { LogHelper.Error(ex); } finally { //无论后端出现什么问题,都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】 context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } } }
/// <summary> /// 新增表格 /// </summary> /// <param name="context">当前上下文</param> public void Add_Eva_Table(HttpContext context) { lock (obj_Add_Eva_Table) { int intSuccess = (int)errNum.Success; HttpRequest Request = context.Request; string Name = RequestHelper.string_transfer(Request, "Name"); int IsScore = RequestHelper.int_transfer(Request, "IsScore"); int IsEnable = RequestHelper.int_transfer(Request, "IsEnable"); string Remarks = RequestHelper.string_transfer(Request, "Remarks"); string CreateUID = RequestHelper.string_transfer(Request, "CreateUID"); string EditUID = RequestHelper.string_transfer(Request, "EditUID"); string CourseType_Id = RequestHelper.string_transfer(Request, "CourseType_Id"); int Type = RequestHelper.int_transfer(Request, "Type"); try { Eva_Table Eva_Table_Add = new Eva_Table() { Name = Name, IsScore = (byte)IsScore, CousrseType_Id = CourseType_Id, Type = Type, //Type = 2,//新加的 主要区别于即时(1)和扫码(0) Remarks = Remarks, UseTimes = 0, CreateTime = DateTime.Now, CreateUID = CreateUID, EditTime = DateTime.Now, EditUID = EditUID, IsEnable = (byte)IsEnable, IsDelete = (int)IsDelete.No_Delete }; //表单明细 string List = RequestHelper.string_transfer(Request, "List"); //序列化表单详情列表 List <Table_A> Table_A_List = JsonConvert.DeserializeObject <List <Table_A> >(List); //数据库添加 jsonModel = Constant.Eva_TableService.Add(Eva_Table_Add); if (jsonModel.errNum == 0) { //从数据库返回的ID绑定 Eva_Table_Add.Id = RequestHelper.int_transfer(Convert.ToString(jsonModel.retData)); string head_value = RequestHelper.string_transfer(Request, "head_value"); //string lisss = RequestHelper.string_transfer(Request, "lisss"); //添加头部内容 Table_Header((int)Eva_Table_Add.Id, head_value); //lisss if (jsonModel.errNum == intSuccess) { //缓存添加 Constant.Eva_Table_List.Add(Eva_Table_Add); //解析正常才可进行操作 if (Table_A_List != null) { //表格详情表创建添加 Eva_TableAdd_Helper(CreateUID, EditUID, Eva_Table_Add, Table_A_List); } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "添加失败"); } } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "添加失败"); } } catch (Exception ex) { LogHelper.Error(ex); } finally { //无论后端出现什么问题,都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】 context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } } }