public void AddDate(string content, int num)
{
string mess = string.Empty;
if (num == 1)
{
mess = "发布成功!";
}
else
{
mess = "标记成功!";
}
Tunnel.Model.Tunnel_viewTable model = new Tunnel.Model.Tunnel_viewTable();
model.TypeId = typeId + 2;
model.ObjId = Id;
model.UserId = ul.LoginID;
model.Content = content;
int relt = -1;
relt = tbll.Add(model);
if (relt > 0)
{
Tunnel.Common.Message.Show(mess, "ViewXJB.aspx?Id=" + Id + "&TypeId=" + typeId + "&bum_id=" + bum_id + "§ype=" + sectype);
}
}
public void AddDate(string content, int num)
{
string mess = string.Empty;
if (num == 1)
{
mess = "发布成功!";
}
else
{
mess = "标记成功!";
}
Tunnel.Model.Tunnel_viewTable model = new Tunnel.Model.Tunnel_viewTable();
model.TypeId = TypeId;
model.ObjId = Id;
model.UserId = ul.LoginID;
model.Content = content;
int relt = -1;
relt = tbll.Add(model);
if (relt > 0)
{
Tunnel.Common.Message.Show(mess, "ViewGongGao.aspx?Id=" + Id + "&TypeId=" + TypeId + "&lanmuId=" + Request["lanmuId"]);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_viewTable model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 8),
new SqlParameter("@objId", SqlDbType.Int, 8),
new SqlParameter("@typeId", SqlDbType.Int, 8),
new SqlParameter("@content", SqlDbType.VarChar, 800),
new SqlParameter("@userId", SqlDbType.Int, 8),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.ObjId;
parameters[2].Value = model.TypeId;
parameters[3].Value = model.Content;
parameters[4].Value = model.UserId;
DbHelperSQL.RunProcedure("UP_ViewTable_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="pb">分页基本信息</param>
/// <param name="count">返回总数</param>
/// <returns></returns>
public List <Tunnel.Model.Tunnel_viewTable> GetList2(PageBase pb, ref int count)
{
DataTable dt = dal.GetList2(pb, ref count).Tables[0];
List <Tunnel.Model.Tunnel_viewTable> modelList = new List <Tunnel.Model.Tunnel_viewTable>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0 && pb.DoCount == 0)
{
Tunnel.Model.Tunnel_viewTable model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_viewTable();
model.Id = Convert.ToInt32(dt.Rows[n]["id"].ToString());
model.ObjId = Convert.ToInt32(dt.Rows[n]["objId"].ToString());
model.TypeId = int.Parse(dt.Rows[n]["typeId"].ToString());
model.UserId = int.Parse(dt.Rows[n]["userId"].ToString());
model.SetDate = dt.Rows[n]["setDate"].ToString();
model.Content = dt.Rows[n]["content"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_viewTable model)
{
return(dal.Add(model));
}
