public QPS.NEW.Model.Enterprise GetModel(int Id)
{
QPS.NEW.Model.Enterprise user = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Enterprise where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new SqlParameter("@id", Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
user = new Model.Enterprise();
user.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
user.Username = dt.Rows[0]["Username"].ToString();
user.Password = dt.Rows[0]["Password"].ToString();
user.Nickname = dt.Rows[0]["Nickname"].ToString();
user.Phone = dt.Rows[0]["Phone"].ToString();
user.Address = dt.Rows[0]["Address"].ToString();
user.Mail = dt.Rows[0]["Mail"].ToString();
user.IfChecked = Convert.ToInt32(dt.Rows[0]["IfChecked"]);
}
return(user);
}
public QPS.NEW.Model.Enterprise GetModel(int Id)
{
QPS.NEW.Model.Enterprise user = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Enterprise where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new SqlParameter("@id",Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
user = new Model.Enterprise();
user.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
user.Username = dt.Rows[0]["Username"].ToString();
user.Password = dt.Rows[0]["Password"].ToString();
user.Nickname = dt.Rows[0]["Nickname"].ToString();
user.Phone = dt.Rows[0]["Phone"].ToString();
user.Address = dt.Rows[0]["Address"].ToString();
user.Mail = dt.Rows[0]["Mail"].ToString();
user.IfChecked = Convert.ToInt32(dt.Rows[0]["IfChecked"]);
}
return user;
}
