public List <UserpigflyModel> GetUser(string UserName, string dateTimeReg)
{
StringBuilder sql = new StringBuilder("select*from userpigfly where uisdelete=0");
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> whereList = new List <string>();
if (!string.IsNullOrWhiteSpace(UserName))
{
whereList.Add("UserName=@UserName");
parameters.Add(new SqlParameter("@UserName", UserName));
}
if (!string.IsNullOrWhiteSpace(dateTimeReg))
{
whereList.Add("udatetime<@dateTimeReg");
parameters.Add(new SqlParameter("@dateTimeReg", dateTimeReg));
}
if (whereList.Count > 0)
{
string pj = string.Join(" and ", whereList.ToArray());
sql.Append($" and {pj}");
}
SqlDataReader sdr = SQLHelper.ExecuteReader(sql.ToString(), parameters.ToArray());
List <UserpigflyModel> userpigflyModels = new List <UserpigflyModel>();
if (sdr.HasRows)
{
while (sdr.Read())
{
UserpigflyModel userpigfly = new UserpigflyModel();
userpigfly.username = sdr["username"].ToString();
userpigfly.upassword = sdr["upassword"].ToString();
userpigfly.usex = Convert.ToInt32(sdr["usex"]);
userpigfly.uphone = sdr["uphone"].ToString();
userpigfly.uaddress = sdr["uaddress"].ToString();
userpigfly.uimg = sdr["uimg"].ToString();
userpigfly.Uid = Convert.ToInt32(sdr["uid"]);
userpigfly.ustate = Convert.ToInt32(sdr["ustate"]);
userpigfly.uemail = sdr["uemail"].ToString();
userpigfly.udatetime = Convert.ToDateTime(sdr["udatetime"].ToString());
userpigflyModels.Add(userpigfly);
}
sdr.Close();
}
return(userpigflyModels);
}
public List <UserpigflyModel> Getdetails(int investid)
{
string sql = $"select*from invest i,userpigfly u where i.uid=u.uid and investid=@investid";
SqlParameter[] sqlParameters =
{
new SqlParameter("@investid", investid)
};
List <UserpigflyModel> listModel = new List <UserpigflyModel>();
SqlDataReader reader = SQLHelper.ExecuteReader(sql, sqlParameters);
if (reader.HasRows)
{
while (reader.Read())
{
UserpigflyModel model = new UserpigflyModel();
model.username = reader["username"].ToString();
model.usex = Convert.ToInt32(reader["usex"]);
model.uphone = reader["uphone"].ToString();
model.uaddress = reader["uaddress"].ToString();
model.uimg = reader["uimg"].ToString();
model.uemail = reader["uemail"].ToString();
model.investid = Convert.ToInt32(reader["investid"]);
model.investname = reader["investname"].ToString();
model.investprice = reader["investprice"].ToString();
model.investaddress = reader["investaddress"].ToString();
model.investtime = Convert.ToDateTime(reader["investtime"]);
model.investdelete = Convert.ToInt32(reader["investdelete"]);
model.investshow = Convert.ToInt32(reader["investshow"]);
model.investcontent = reader["investcontent"].ToString();
model.investProjectContent = reader["investProjectContent"].ToString();
model.investLogo = reader["investLogo"].ToString();
model.investweb = reader["investweb"].ToString();
model.uid = Convert.ToInt32(reader["uid"]);
model.investstate = Convert.ToInt32(reader["investstate"]);
model.Udelete = Convert.ToInt32(reader["Udelete"]);
listModel.Add(model);
}
}
return(listModel);
}
