public List<Maticsoft.Model.Poll.Reply> GetModelList(string strWhere)
{
DataSet set = this.dal.GetList(strWhere);
List<Maticsoft.Model.Poll.Reply> list = new List<Maticsoft.Model.Poll.Reply>();
int count = set.Tables[0].Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.Poll.Reply item = new Maticsoft.Model.Poll.Reply();
if (set.Tables[0].Rows[i]["ID"].ToString() != "")
{
item.ID = int.Parse(set.Tables[0].Rows[i]["ID"].ToString());
}
if (set.Tables[0].Rows[i]["TopicID"].ToString() != "")
{
item.TopicID = new int?(int.Parse(set.Tables[0].Rows[i]["TopicID"].ToString()));
}
item.ReContent = set.Tables[0].Rows[i]["ReContent"].ToString();
if (set.Tables[0].Rows[i]["ReTime"].ToString() != "")
{
item.ReTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[i]["ReTime"].ToString()));
}
list.Add(item);
}
}
return list;
}
public Maticsoft.Model.Poll.Reply GetModel(int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ID,TopicID,ReContent,ReTime from Poll_Reply ");
builder.Append(" where ID=@ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4) };
cmdParms[0].Value = ID;
Maticsoft.Model.Poll.Reply reply = new Maticsoft.Model.Poll.Reply();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["ID"].ToString() != "")
{
reply.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString());
}
if (set.Tables[0].Rows[0]["TopicID"].ToString() != "")
{
reply.TopicID = new int?(int.Parse(set.Tables[0].Rows[0]["TopicID"].ToString()));
}
reply.ReContent = set.Tables[0].Rows[0]["ReContent"].ToString();
if (set.Tables[0].Rows[0]["ReTime"].ToString() != "")
{
reply.ReTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["ReTime"].ToString()));
}
return reply;
}