public IList <Model.TD_WeiXin_Member> GetListByMemberIDs(IList <string> list) { StringBuilder sql = new StringBuilder(); sql.AppendLine("CREATE TEMPORARY TABLE TEMP(id varchar(36));"); for (int i = 0; i < list.Count; i++) { sql.AppendFormat(" INSERT INTO TEMP(id) VALUES(@Parameter{0});", i); sql.AppendLine(); } sql.Append(" SELECT t1.MemberID,t1.NickName,t1.HeaderImage,t1.OpenID,t1.CreateTime,t1.IsFocused,t1.FocusTime,t1.UnFocusTime,t1.Sex,t1.Country,t1.Province,t1.City"); sql.Append(" from TD_WeiXin_Member t1 INNER JOIN TEMP t2 ON t1.MemberID=t2.id;"); sql.Append(" drop table TEMP;"); List <MySqlParameter> parameters = new List <MySqlParameter>(); for (int i = 0; i < list.Count; i++) { MySqlParameter parameter = new MySqlParameter("@Parameter" + i.ToString(), list[i]); parameters.Add(parameter); } IList <ShiMiao.Model.TD_WeiXin_Member> modelList = new List <ShiMiao.Model.TD_WeiXin_Member>(); using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(sql.ToString(), parameters.ToArray())) { while (dr.Read()) { ShiMiao.Model.TD_WeiXin_Member model = new ShiMiao.Model.TD_WeiXin_Member(); if (dr[0] != DBNull.Value) { model.MemberID = dr.GetString(0); } if (dr[1] != DBNull.Value) { model.NickName = dr.GetString(1); } if (dr[2] != DBNull.Value) { model.HeaderImage = dr.GetString(2); } if (dr[3] != DBNull.Value) { model.OpenID = dr.GetString(3); } if (dr[4] != DBNull.Value) { model.CreateTime = dr.GetDateTime(4); } if (dr[5] != DBNull.Value) { model.IsFocused = dr.GetString(5); } if (dr[6] != DBNull.Value) { model.FocusTime = dr.GetDateTime(6); } if (dr[7] != DBNull.Value) { model.UnFocusTime = dr.GetDateTime(7); } if (dr[8] != DBNull.Value) { model.Sex = dr.GetInt16(8); } if (dr[9] != DBNull.Value) { model.Country = dr.GetString(9); } if (dr[10] != DBNull.Value) { model.Province = dr.GetString(10); } if (dr[11] != DBNull.Value) { model.City = dr.GetString(11); } modelList.Add(model); } parameters.Clear(); return(modelList); } }
public Model.TD_WeiXin_Member GetModelByOpenID(string openID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MemberID,NickName,HeaderImage,OpenID,CreateTime,IsFocused,FocusTime,UnFocusTime,Sex,Country,Province,City"); strSql.Append(" from TD_WeiXin_Member "); strSql.Append(" where OpenID=@OpenID "); MySqlParameter[] parameters = { new MySqlParameter("@OpenID", openID) }; ShiMiao.Model.TD_WeiXin_Member model = null; using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { model = new ShiMiao.Model.TD_WeiXin_Member(); if (dr[0] != DBNull.Value) { model.MemberID = dr.GetString(0); } if (dr[1] != DBNull.Value) { model.NickName = dr.GetString(1); } if (dr[2] != DBNull.Value) { model.HeaderImage = dr.GetString(2); } if (dr[3] != DBNull.Value) { model.OpenID = dr.GetString(3); } if (dr[4] != DBNull.Value) { model.CreateTime = dr.GetDateTime(4); } if (dr[5] != DBNull.Value) { model.IsFocused = dr.GetString(5); } if (dr[6] != DBNull.Value) { model.FocusTime = dr.GetDateTime(6); } if (dr[7] != DBNull.Value) { model.UnFocusTime = dr.GetDateTime(7); } if (dr[8] != DBNull.Value) { model.Sex = dr.GetInt16(8); } if (dr[9] != DBNull.Value) { model.Country = dr.GetString(9); } if (dr[10] != DBNull.Value) { model.Province = dr.GetString(10); } if (dr[11] != DBNull.Value) { model.City = dr.GetString(11); } } return(model); } }