protected void btnPerbh_Click(object sender, EventArgs e) { if (Request.QueryString["PerID"] != null) { int PerID = Convert.ToInt32(Request.QueryString["PerID"]); ZhongLi.Model.Person person = bll.GetModel(PerID); person.Flag = 3; person.AuthTime = DateTime.Now; bll.Update(person); //添加消息表 ZhongLi.Model.Person_Message msg = new ZhongLi.Model.Person_Message(); msg.MesCon = "您的身份认证被驳回了,需要重新上传哦"; msg.SendTime = DateTime.Now; msg.PerID = PerID; msg.MesType = 0; new ZhongLi.BLL.Person_Message().Add(msg); //推送通知 PushClass push = new PushClass(); push.title = "优青通知:"; push.content = "您的身份认证被驳回了,需要重新上传哦"; push.type = "1"; push.platform = "0"; push.groupName = "person"; push.userIds = "p" + PerID; push.ts_01(); webHelper.addLog("通过了求职者“" + person.RealName + "”的身份认证"); Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('求职者认证','认证成功!','Auth.aspx?PerID='" + person.PerID + ",1)</script>"); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhongLi.Model.Person_Message model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@PerMesID", SqlDbType.Int, 4), new SqlParameter("@PerID", SqlDbType.Int, 4), new SqlParameter("@MesType", SqlDbType.Int, 4), new SqlParameter("@DataID", SqlDbType.Int, 4), new SqlParameter("@MesCon", SqlDbType.NVarChar, 200), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@IsRead", SqlDbType.Bit, 1), new SqlParameter("@ReadTime", SqlDbType.DateTime), new SqlParameter("@Colvalue", SqlDbType.NVarChar, 50), new SqlParameter("@TargetID", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.PerID; parameters[2].Value = model.MesType; parameters[3].Value = model.DataID; parameters[4].Value = model.MesCon; parameters[5].Value = model.SendTime; parameters[6].Value = model.IsRead; parameters[7].Value = model.ReadTime; parameters[8].Value = model.Colvalue; parameters[9].Value = model.TargetID; DbHelperSQL.RunProcedure("Person_Message_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.Person_Message DataRowToModel(DataRow row) { ZhongLi.Model.Person_Message model = new ZhongLi.Model.Person_Message(); if (row != null) { if (row["PerMesID"] != null && row["PerMesID"].ToString() != "") { model.PerMesID = int.Parse(row["PerMesID"].ToString()); } if (row["PerID"] != null && row["PerID"].ToString() != "") { model.PerID = int.Parse(row["PerID"].ToString()); } if (row["MesType"] != null && row["MesType"].ToString() != "") { model.MesType = int.Parse(row["MesType"].ToString()); } if (row["DataID"] != null && row["DataID"].ToString() != "") { model.DataID = int.Parse(row["DataID"].ToString()); } if (row["MesCon"] != null) { model.MesCon = row["MesCon"].ToString(); } if (row["SendTime"] != null && row["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(row["SendTime"].ToString()); } if (row["IsRead"] != null && row["IsRead"].ToString() != "") { if ((row["IsRead"].ToString() == "1") || (row["IsRead"].ToString().ToLower() == "true")) { model.IsRead = true; } else { model.IsRead = false; } } if (row["ReadTime"] != null && row["ReadTime"].ToString() != "") { model.ReadTime = DateTime.Parse(row["ReadTime"].ToString()); } if (row["Colvalue"] != null) { model.Colvalue = row["Colvalue"].ToString(); } if (row["TargetID"] != null && row["TargetID"].ToString() != "") { model.TargetID = int.Parse(row["TargetID"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.Person_Message GetModel(int PerMesID) { SqlParameter[] parameters = { new SqlParameter("@PerMesID", SqlDbType.Int, 4) }; parameters[0].Value = PerMesID; ZhongLi.Model.Person_Message model = new ZhongLi.Model.Person_Message(); DataSet ds = DbHelperSQL.RunProcedure("Person_Message_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhongLi.Model.Person_Message model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@PerMesID", SqlDbType.Int, 4), new SqlParameter("@PerID", SqlDbType.Int, 4), new SqlParameter("@MesType", SqlDbType.Int, 4), new SqlParameter("@DataID", SqlDbType.Int, 4), new SqlParameter("@MesCon", SqlDbType.NVarChar, 200), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@IsRead", SqlDbType.Bit, 1), new SqlParameter("@ReadTime", SqlDbType.DateTime), new SqlParameter("@Colvalue", SqlDbType.NVarChar, 50), new SqlParameter("@TargetID", SqlDbType.Int, 4) }; parameters[0].Value = model.PerMesID; parameters[1].Value = model.PerID; parameters[2].Value = model.MesType; parameters[3].Value = model.DataID; parameters[4].Value = model.MesCon; parameters[5].Value = model.SendTime; parameters[6].Value = model.IsRead; parameters[7].Value = model.ReadTime; parameters[8].Value = model.Colvalue; parameters[9].Value = model.TargetID; DbHelperSQL.RunProcedure("Person_Message_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }