public List <investModel> Getinvest()
{
string sql = "select * from invest where investstate=0 and Udelete=0";
List <investModel> invests = new List <investModel>();
SqlDataReader reader = SQLHelper.ExecuteReader(sql);
if (reader.HasRows)
{
while (reader.Read())
{
investModel model = new investModel();
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"]);
invests.Add(model);
}
reader.Close();
}
return(invests);
}
public List <investModel> QueryInvests(string investname, string investprice, string investcontent, string Investtime)
{
StringBuilder sql = new StringBuilder("select*from invest where investstate=1 and Udelete=0 ");
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <string> wherelist = new List <string>();
if (!string.IsNullOrWhiteSpace(investname))
{
wherelist.Add("investname=@investname");
sqlParameters.Add(new SqlParameter("@investname", investname));
}
if (!string.IsNullOrWhiteSpace(investprice))
{
wherelist.Add("investprice=@investprice");
sqlParameters.Add(new SqlParameter("@investprice", investprice));
}
if (!string.IsNullOrWhiteSpace(investcontent))
{
wherelist.Add("investcontent=@investcontent");
sqlParameters.Add(new SqlParameter("@investcontent", investcontent));
}
if (!string.IsNullOrWhiteSpace(Investtime) && DateTime.TryParse(Investtime, out DateTime investtime))
{
wherelist.Add("Investtime>@Investtime");
sqlParameters.Add(new SqlParameter("@investtime", investtime));
}
if (wherelist.Count > 0)
{
string pj = string.Join(" and ", wherelist.ToArray());
sql.Append($" and {pj}");
}
List <investModel> invests = new List <investModel>();
SqlDataReader reader = SQLHelper.ExecuteReader(sql.ToString(), sqlParameters.ToArray());
if (reader.HasRows)
{
while (reader.Read())
{
investModel invest = new investModel();
invest.investid = Convert.ToInt32(reader["investid"]);
invest.investname = reader["investname"].ToString();
invest.investprice = reader["investprice"].ToString();;
invest.investaddress = reader["investaddress"].ToString();;
invest.investtime = Convert.ToDateTime(reader["investtime"]);
invest.investProjectContent = reader["investProjectContent"].ToString();;
invest.investcontent = reader["investcontent"].ToString();
invests.Add(invest);
}
reader.Close();
}
return(invests);
}
public List <investModel> GetInvests()
{
string sql = "select*from invest where investstate=1 and Udelete=0";
SqlDataReader sdr = SQLHelper.ExecuteReader(sql);
List <investModel> investModels = new List <investModel>();
if (sdr.HasRows)
{
while (sdr.Read())
{
investModel invest = new investModel();
invest.investid = Convert.ToInt32(sdr["investid"]);
invest.investname = sdr["investname"].ToString();
invest.investprice = sdr["investprice"].ToString();;
invest.investaddress = sdr["investaddress"].ToString();;
invest.investtime = Convert.ToDateTime(sdr["investtime"]);
invest.investProjectContent = sdr["investProjectContent"].ToString();;
invest.investcontent = sdr["investcontent"].ToString();
investModels.Add(invest);
}
sdr.Close();
}
return(investModels);
}
