/// <summary> /// 获取提醒设置信息 /// </summary> /// <param name="entity"></param> /// <param name="remind_userid"></param> /// <param name="remind_type"></param> /// <returns></returns> public static remind_setting get_remind_setting_info(remind_setting entity, string remind_userid, string remind_type) { try { SqlParameter[] param = { new SqlParameter("@remind_userid", remind_userid), new SqlParameter("@remind_type", remind_type) }; SqlDataReader reader = SQLHelp.ExecuteReader("get_remind_setting_info", CommandType.StoredProcedure, param); if (reader.HasRows) { PropertyInfo[] pros = entity.GetType().GetProperties(); while (reader.Read()) { foreach (PropertyInfo item in pros) { item.SetValue(entity, reader.IsDBNull(reader.GetOrdinal(item.Name)) ? null : reader[item.Name]); } } } else { entity = null; } return(entity); } catch (Exception ex) { return(null); } }
/// <summary> /// 编辑签到 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonModel edit_remind_setting(remind_setting model) { JsonModel jsonModel = new JsonModel(); try { int result = DALBaseCommon.edit_remind_setting(model); jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = result }; return(jsonModel); } catch (Exception ex) { jsonModel = new JsonModel() { errNum = 400, errMsg = ex.Message, retData = "" }; return(jsonModel); } }
/// <summary> /// 新增遗忘提醒 /// </summary> /// <param name="context"></param> public void edit_remind_setting(HttpContext context) { HttpRequest request = context.Request; HttpResponse response = context.Response; string id = request["id"]; string guid = request["guid"]; try { remind_setting remind = new remind_setting(); remind.id = Convert.ToInt32(id); remind.remind_userid = request["remind_userid"]; remind.remind_type = request["remind_type"]; remind.remind_isdelete = "0"; remind.remind_remark = request["remind_remark"];//重要 if (dic_Self.ContainsKey(guid)) { List <remind_setting> dic2 = dic_Self[guid].Where(item => item.id == Convert.ToInt64(id)).ToList <remind_setting>(); if (dic2.Count > 0) { dic2[0] = remind; //成功提示 jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = dic2.Count }; //开启线程操作数据库 new Thread(() => { jsonModel = Constant.bbc.edit_remind_setting(remind); }) { }.Start(); } } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
public static int edit_remind_setting(remind_setting model) { int result = 0; SqlParameter[] param = { new SqlParameter("@id", model.id), new SqlParameter("@remind_userid", model.remind_userid == null?"": model.remind_userid), new SqlParameter("@remind_type", model.remind_type == null?"":model.remind_type), new SqlParameter("@remind_remark", model.remind_remark == null?"":model.remind_remark) }; param[0].Direction = ParameterDirection.Output; object obj = SQLHelp.ExecuteNonQuery("edit_remind_setting", CommandType.StoredProcedure, param); result = Convert.ToInt32(param[0].Value.ToString()); return(result); }
/// <summary> /// 获取提醒设置信息 /// </summary> /// <param name="entity"></param> /// <param name="remind_userid"></param> /// <param name="remind_type"></param> /// <returns></returns> public remind_setting get_remind_setting_info(remind_setting entity, string remind_userid, string remind_type) { return(DALBaseCommon.get_remind_setting_info(entity, remind_userid, remind_type)); }