public static WorkPlanFile Get(int id)
{
string sql = "select Id,WorkPlanId,FileName,FilePath from WorkPlanFiles where Id = @Id";
SqlParam p = new SqlParam();
p.AddParam("@Id", id, SqlDbType.Int, 0);
DataTable dt = ProjectDB.GetDt(sql, p);
WorkPlanFile o = new WorkPlanFile();
if (dt.Rows.Count > 0)
{
var row = dt.Rows[0];
o.Id = St.ToInt32(row["Id"], 0);
o.WorkPlanId = St.ToInt32(row["WorkPlanId"], 0);
o.FileName = row["FileName"].ToString();
o.FilePath = row["FilePath"].ToString();
}
return(o);
}
public static List <WorkPlanFile> GetList(int workplanid)
{
string sql = "select Id,WorkPlanId,FileName,FilePath from WorkPlanFiles where WorkPlanId = @workplanid order by Id desc";
SqlParam p = new SqlParam();
p.AddParam("@workplanid", workplanid, SqlDbType.Int, 0);
DataTable dt = ProjectDB.GetDt(sql, p);
List <WorkPlanFile> list = new List <WorkPlanFile>();
foreach (DataRow row in dt.Rows)
{
WorkPlanFile o = new WorkPlanFile();
o.Id = St.ToInt32(row["Id"], 0);
o.WorkPlanId = St.ToInt32(row["WorkPlanId"], 0);
o.FileName = row["FileName"].ToString();
o.FilePath = row["FilePath"].ToString();
list.Add(o);
}
return(list);
}
