public IList <T_ControlItemMode> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <Models.T_ControlItemMode> list = new List <Models.T_ControlItemMode>();
foreach (DataRow dr in dt.Rows)
{
T_ControlItemMode model = new T_ControlItemMode();
model.Code = dr["Code"].ToString();
model.Note2 = dr["Note2"].ToString();
model.Note3 = dr["Note3"].ToString();
model.Note4 = dr["Note4"].ToString();
model.Note5 = dr["Note5"].ToString();
model.CName = dr["CName"].ToString();
model.ControlCodeFirst = dr["ControlCodeFirst"].ToString();
model.ControlNameFirst = dr["ControlNameFirst"].ToString();
model.ControlCodeSecond = dr["ControlCodeSecond"].ToString();
model.ControlNameSecond = dr["ControlNameSecond"].ToString();
model.Months = dr["Months"].ToString();
model.Remark = dr["Remark"].ToString();
model.Note1 = dr["Note1"].ToString();
model.Status = dr["Status"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.T_ControlItemMode GetModel(string Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" where Code=@Code ");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Code;
T_ControlItemMode model = new T_ControlItemMode();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.Code = dr["Code"].ToString();
model.Note2 = dr["Note2"].ToString();
model.Note3 = dr["Note3"].ToString();
model.Note4 = dr["Note4"].ToString();
model.Note5 = dr["Note5"].ToString();
model.CName = dr["CName"].ToString();
model.ControlCodeFirst = dr["ControlCodeFirst"].ToString();
model.ControlNameFirst = dr["ControlNameFirst"].ToString();
model.ControlCodeSecond = dr["ControlCodeSecond"].ToString();
model.ControlNameSecond = dr["ControlNameSecond"].ToString();
model.Months = dr["Months"].ToString();
model.Remark = dr["Remark"].ToString();
model.Note1 = dr["Note1"].ToString();
model.Status = dr["Status"].ToString();
return(model);
}
else
{
return(null);
}
}
}
