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