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); }