/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Tunnel.Model.Tunnel_Performance model)
{
string strSQL = string.Format("INSERT INTO Tunnel_Performance ([Type],Title,[file],[Name],CreateDate,CreateUser) "
+ "VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')", model.Type, model.Title, model.File, model.Name, model.CreateDate, model.CreateUser);
object obj = DbHelperSQL.ExecuteSql(strSQL);
if (null != obj)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Tunnel.Model.Tunnel_Performance GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Type,Title,file,Name,CreateDate,CreateUser from Tunnel_Performance ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Tunnel.Model.Tunnel_Performance model = new Tunnel.Model.Tunnel_Performance();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Type"].ToString() != "")
{
model.Type = int.Parse(ds.Tables[0].Rows[0]["Type"].ToString());
}
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
model.File = ds.Tables[0].Rows[0]["file"].ToString();
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateUser"].ToString() != "")
{
model.CreateUser = int.Parse(ds.Tables[0].Rows[0]["CreateUser"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="pb">分页基本信息</param>
/// <param name="count">返回总数</param>
/// <returns></returns>
public List <Tunnel.Model.Tunnel_Performance> GetList(PageBase pb, ref int count)
{
DataTable dt = dal.GetList(pb, ref count).Tables[0];
List <Tunnel.Model.Tunnel_Performance> modelList = new List <Tunnel.Model.Tunnel_Performance>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0 && pb.DoCount == 0)
{
Tunnel.Model.Tunnel_Performance model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_Performance();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["Type"].ToString() != "")
{
model.Type = int.Parse(dt.Rows[n]["Type"].ToString());
}
model.Title = dt.Rows[n]["Title"].ToString();
model.File = dt.Rows[n]["file"].ToString();
model.Name = dt.Rows[n]["Name"].ToString();
if (dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
if (dt.Rows[n]["CreateUser"].ToString() != "")
{
model.CreateUser = int.Parse(dt.Rows[n]["CreateUser"].ToString());
}
//model.CreateUser=dt.Rows[n]["CreateUser"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Tunnel.Model.Tunnel_Performance> DataTableToList(DataTable dt)
{
List <Tunnel.Model.Tunnel_Performance> modelList = new List <Tunnel.Model.Tunnel_Performance>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Tunnel.Model.Tunnel_Performance model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_Performance();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["Type"].ToString() != "")
{
model.Type = int.Parse(dt.Rows[n]["Type"].ToString());
}
model.Title = dt.Rows[n]["Title"].ToString();
model.File = dt.Rows[n]["file"].ToString();
model.Name = dt.Rows[n]["Name"].ToString();
if (dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
if (dt.Rows[n]["CreateUser"].ToString() != "")
{
model.CreateUser = int.Parse(dt.Rows[n]["CreateUser"].ToString());
}
//model.CreateUser=dt.Rows[n]["CreateUser"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Tunnel.Model.Tunnel_Performance model)
{
return(Tunnel.DAL.Tunnel_Performance.Add(model));
}