public List <Entity.MessageEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " *,(select uname from [OA_User] where Uid=[OA_Message].ToUid) as ToUname,(select uname from [OA_User] where Uid=[OA_Message].FromUid) as FromUname ";
table = "[OA_Message] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Mid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras =
{
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List <Entity.MessageEntity> list = new List <Entity.MessageEntity>();
Entity.MessageEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.MessageEntity();
if (ds.Tables[0].Rows[i]["Mid"].ToString() != "")
{
model.Mid = int.Parse(ds.Tables[0].Rows[i]["Mid"].ToString());
}
model.Addtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Addtime"].ToString());
model.Mtitle = ds.Tables[0].Rows[i]["Mtitle"].ToString();
model.ToUid = Convert.ToInt32(ds.Tables[0].Rows[i]["ToUid"].ToString());
model.ToUname = ds.Tables[0].Rows[i]["ToUname"].ToString();
model.FromUid = Convert.ToInt32(ds.Tables[0].Rows[i]["FromUid"].ToString());
model.FromUname = ds.Tables[0].Rows[i]["FromUname"].ToString();
model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[i]["IsRead"].ToString());
model.Touser = ds.Tables[0].Rows[i]["touser"].ToString();
list.Add(model);
}
return(list);
}
void Bind_Work()
{
int id = Str2Int(q("id"), 0);
Entity.MessageEntity model = new Entity.MessageEntity();
model = new JumbotOA.BLL.MessageBLL().GetEntity(id);
this.lblTitle.Text = model.Mtitle;
text = model.Content;
if (UserId == model.ToUid)
new JumbotOA.BLL.MessageBLL().SetReadById(id);
}
void Bind_Work()
{
int id = Str2Int(q("id"), 0);
Entity.MessageEntity model = new Entity.MessageEntity();
model = new Daiv_OA.BLL.MessageBLL().GetEntity(id);
this.lblTitle.Text = model.Mtitle;
text = model.Content;
if (UserId == model.ToUid)
{
new Daiv_OA.BLL.MessageBLL().SetReadById(id);
}
}
public List<Entity.MessageEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " *,(select uname from [OA_User] where Uid=[OA_Message].ToUid) as ToUname,(select uname from [OA_User] where Uid=[OA_Message].FromUid) as FromUname ";
table = "[OA_Message] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Mid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras ={
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List<Entity.MessageEntity> list = new List<Entity.MessageEntity>();
Entity.MessageEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.MessageEntity();
if (ds.Tables[0].Rows[i]["Mid"].ToString() != "")
{
model.Mid = int.Parse(ds.Tables[0].Rows[i]["Mid"].ToString());
}
model.Addtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Addtime"].ToString());
model.Mtitle = ds.Tables[0].Rows[i]["Mtitle"].ToString();
model.ToUid = Convert.ToInt32(ds.Tables[0].Rows[i]["ToUid"].ToString());
model.ToUname = ds.Tables[0].Rows[i]["ToUname"].ToString();
model.FromUid = Convert.ToInt32(ds.Tables[0].Rows[i]["FromUid"].ToString());
model.FromUname = ds.Tables[0].Rows[i]["FromUname"].ToString();
model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[i]["IsRead"].ToString());
model.Touser = ds.Tables[0].Rows[i]["touser"].ToString();
list.Add(model);
}
return list;
}
