/// <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 void Update(TopicSendRecordMod model)
{
dal.Update(model);
}
/// <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);
}
