/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicSendRecordMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TopicSendRecord("); strSql.Append("UserSysNo,TopicSysNo,IsReturn,TS)"); strSql.Append(" values ("); strSql.Append("@UserSysNo,@TopicSysNo,@IsReturn,@TS)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@UserSysNo", SqlDbType.Int, 4), new SqlParameter("@TopicSysNo", SqlDbType.Int, 4), new SqlParameter("@IsReturn", SqlDbType.Int, 4), new SqlParameter("@TS", SqlDbType.DateTime), }; if (model.UserSysNo != AppConst.IntNull) { parameters[0].Value = model.UserSysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.TopicSysNo != AppConst.IntNull) { parameters[1].Value = model.TopicSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.IsReturn != AppConst.IntNull) { parameters[2].Value = model.IsReturn; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.TS != AppConst.DateTimeNull) { parameters[3].Value = model.TS; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public TopicSendRecordMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, UserSysNo, TopicSysNo, IsReturn, TS from TopicSendRecord"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; TopicSendRecordMod model = new TopicSendRecordMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["UserSysNo"].ToString() != "") { model.UserSysNo = int.Parse(ds.Tables[0].Rows[0]["UserSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["TopicSysNo"].ToString() != "") { model.TopicSysNo = int.Parse(ds.Tables[0].Rows[0]["TopicSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["IsReturn"].ToString() != "") { model.IsReturn = int.Parse(ds.Tables[0].Rows[0]["IsReturn"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicSendRecordMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TopicSendRecord("); strSql.Append("UserSysNo,TopicSysNo,IsReturn,TS)"); strSql.Append(" values ("); strSql.Append("@UserSysNo,@TopicSysNo,@IsReturn,@TS)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@UserSysNo",SqlDbType.Int,4), new SqlParameter("@TopicSysNo",SqlDbType.Int,4), new SqlParameter("@IsReturn",SqlDbType.Int,4), new SqlParameter("@TS",SqlDbType.DateTime), }; if (model.UserSysNo != AppConst.IntNull) parameters[0].Value = model.UserSysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.TopicSysNo != AppConst.IntNull) parameters[1].Value = model.TopicSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.IsReturn != AppConst.IntNull) parameters[2].Value = model.IsReturn; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.TS != AppConst.DateTimeNull) parameters[3].Value = model.TS; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); return SqlHelper.ExecuteNonQuery(cmd,parameters); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(TopicSendRecordMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TopicSendRecord set "); strSql.Append("UserSysNo=@UserSysNo,"); strSql.Append("TopicSysNo=@TopicSysNo,"); strSql.Append("IsReturn=@IsReturn,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo",SqlDbType.Int,4), new SqlParameter("@UserSysNo",SqlDbType.Int,4), new SqlParameter("@TopicSysNo",SqlDbType.Int,4), new SqlParameter("@IsReturn",SqlDbType.Int,4), new SqlParameter("@TS",SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) parameters[0].Value = model.SysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.UserSysNo != AppConst.IntNull) parameters[1].Value = model.UserSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.TopicSysNo != AppConst.IntNull) parameters[2].Value = model.TopicSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.IsReturn != AppConst.IntNull) parameters[3].Value = model.IsReturn; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.TS != AppConst.DateTimeNull) parameters[4].Value = model.TS; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); return SqlHelper.ExecuteNonQuery(cmd,parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public TopicSendRecordMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, UserSysNo, TopicSysNo, IsReturn, TS from TopicSendRecord"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int,4 ) }; parameters[0].Value = SysNo; TopicSendRecordMod model = new TopicSendRecordMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["UserSysNo"].ToString() != "") { model.UserSysNo = int.Parse(ds.Tables[0].Rows[0]["UserSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["TopicSysNo"].ToString() != "") { model.TopicSysNo = int.Parse(ds.Tables[0].Rows[0]["TopicSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["IsReturn"].ToString() != "") { model.IsReturn = int.Parse(ds.Tables[0].Rows[0]["IsReturn"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return model; } else { return null; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicSendRecordMod model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TopicSendRecordMod model) { dal.Update(model); }
private string SearchTopic(string PhoneNum) { string ret = ""; AdvUserMod m_user = AdvUserBll.GetInstance().GetModel(PhoneNum); if (m_user.SysNo == AppConst.IntNull)//该手机号未发送过主题 { m_user.CellPhone = PhoneNum; m_user.DR = (int)AppEnum.State.normal; m_user.TS = DateTime.Now; m_user.SysNo = AdvUserBll.GetInstance().Add(m_user); DataTable m_dt = AdvTopicBll.GetInstance().GetTopicList(); int ran = CommonTools.ThrowRandom(0, m_dt.Rows.Count - 1); ret = m_dt.Rows[ran]["Title"].ToString(); TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_dt.Rows[ran]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } else//该手机号已发送过主题 { DataTable m_dt = TopicSendRecordBll.GetInstance().GetRecentRecordByUser(m_user.SysNo); DataTable m_total = AdvTopicBll.GetInstance().GetTopicList().Copy(); if (m_dt.Rows.Count < m_total.Rows.Count)//还有没有给该用户发送过的主题 { int choise = 0; string returned = "|"; DataTable m_return = TopicSendRecordBll.GetInstance().GetReturnRecordByUser(m_user.SysNo); for (int i = 0; i < m_return.Rows.Count; i++) { returned += m_return.Rows[i]["Group"].ToString() + "|"; } for (int i = 0; i < m_total.Rows.Count; i++) { bool exsit = false; for (int j = 0; j < m_dt.Rows.Count; j++) { if (m_dt.Rows[j]["TopicSysNo"].ToString() == m_total.Rows[i]["SysNo"].ToString()) { exsit = true; break; } } if (exsit) { continue; } else { choise = i; if (returned.Contains("|" + m_total.Rows[i]["Group"].ToString() + "|")) { break;//如果有之前该用户点击进入过的同类型内容直接选中推送 } } } ret = m_total.Rows[choise]["Title"].ToString(); TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_total.Rows[choise]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } else//所有主题都给该用户发送过了 { ret = m_dt.Rows[0]["Title"].ToString();//可优化 TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_dt.Rows[0]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } } return ret; }
/// <summary> /// 更新一条数据 /// </summary> public int Update(TopicSendRecordMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TopicSendRecord set "); strSql.Append("UserSysNo=@UserSysNo,"); strSql.Append("TopicSysNo=@TopicSysNo,"); strSql.Append("IsReturn=@IsReturn,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4), new SqlParameter("@UserSysNo", SqlDbType.Int, 4), new SqlParameter("@TopicSysNo", SqlDbType.Int, 4), new SqlParameter("@IsReturn", SqlDbType.Int, 4), new SqlParameter("@TS", SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) { parameters[0].Value = model.SysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.UserSysNo != AppConst.IntNull) { parameters[1].Value = model.UserSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.TopicSysNo != AppConst.IntNull) { parameters[2].Value = model.TopicSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.IsReturn != AppConst.IntNull) { parameters[3].Value = model.IsReturn; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.TS != AppConst.DateTimeNull) { parameters[4].Value = model.TS; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TopicSendRecordMod model) { return(dal.Add(model)); }
private string SearchTopic(string PhoneNum) { string ret = ""; AdvUserMod m_user = AdvUserBll.GetInstance().GetModel(PhoneNum); if (m_user.SysNo == AppConst.IntNull)//该手机号未发送过主题 { m_user.CellPhone = PhoneNum; m_user.DR = (int)AppEnum.State.normal; m_user.TS = DateTime.Now; m_user.SysNo = AdvUserBll.GetInstance().Add(m_user); DataTable m_dt = AdvTopicBll.GetInstance().GetTopicList(); int ran = CommonTools.ThrowRandom(0, m_dt.Rows.Count - 1); ret = m_dt.Rows[ran]["Title"].ToString(); TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_dt.Rows[ran]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } else//该手机号已发送过主题 { DataTable m_dt = TopicSendRecordBll.GetInstance().GetRecentRecordByUser(m_user.SysNo); DataTable m_total = AdvTopicBll.GetInstance().GetTopicList().Copy(); if (m_dt.Rows.Count < m_total.Rows.Count)//还有没有给该用户发送过的主题 { int choise = 0; string returned = "|"; DataTable m_return = TopicSendRecordBll.GetInstance().GetReturnRecordByUser(m_user.SysNo); for (int i = 0; i < m_return.Rows.Count; i++) { returned += m_return.Rows[i]["Group"].ToString() + "|"; } for (int i = 0; i < m_total.Rows.Count; i++) { bool exsit = false; for (int j = 0; j < m_dt.Rows.Count; j++) { if (m_dt.Rows[j]["TopicSysNo"].ToString() == m_total.Rows[i]["SysNo"].ToString()) { exsit = true; break; } } if (exsit) { continue; } else { choise = i; if (returned.Contains("|" + m_total.Rows[i]["Group"].ToString() + "|")) { break;//如果有之前该用户点击进入过的同类型内容直接选中推送 } } } ret = m_total.Rows[choise]["Title"].ToString(); TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_total.Rows[choise]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } else//所有主题都给该用户发送过了 { ret = m_dt.Rows[0]["Title"].ToString();//可优化 TopicSendRecordMod m_record = new TopicSendRecordMod(); m_record.IsReturn = (int)AppEnum.BOOL.False; m_record.TopicSysNo = int.Parse(m_dt.Rows[0]["SysNo"].ToString()); m_record.UserSysNo = m_user.SysNo; m_record.TS = DateTime.Now; TopicSendRecordBll.GetInstance().Add(m_record); } } return(ret); }