/// <summary> /// /// </summary> /// <param name="count"></param> /// <param name="sTime"></param> /// <param name="eTime"></param> /// <returns></returns> public List<HairShopComment> GetHairShopCommentsByTimeZone(int count, string sTime, string eTime) { List<HairShopComment> list = new List<HairShopComment>(); string commText = string.Empty; switch (count) { case 0: commText = "select * from HairShopComment where HairShopCommentCreateTime<'"+eTime+"' and HairShopCommentCreateTime>'"+sTime+"' order by HairShopCommentID desc"; break; default: commText = "select top " + count.ToString() + " * from HairShopComment where HairShopCommentCreateTime<'" + eTime + "' and HairShopCommentCreateTime>'" + sTime + "' order by HairShopCommentID desc"; break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { { using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commText; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { while (sdr.Read()) { HairShopComment hairShopComment = new HairShopComment(); hairShopComment.CommentCreateTime = Convert.ToDateTime(sdr["HairShopCommentCreateTime"].ToString()); hairShopComment.CommentID = int.Parse(sdr["HairShopCommentID"].ToString()); hairShopComment.CommentText = sdr["HairShopCommentText"].ToString(); hairShopComment.HairShopID = int.Parse(sdr["HairShopID"].ToString()); hairShopComment.UserAddress = sdr["UserAddress"].ToString(); hairShopComment.UserID = int.Parse(sdr["UserID"].ToString()); hairShopComment.UserName = sdr["UserName"].ToString(); hairShopComment.IsGood = Convert.ToBoolean(sdr["IsGood"].ToString()); list.Add(hairShopComment); } } } } } return list; }
/// <summary> /// ͨ��USERID��ȡ�������������б� /// </summary> /// <param name="userID"></param> /// <param name="count"></param> /// <param name="orderKey">�û�����KEY ʱ����������������������</param> /// <returns></returns> public List<HairShopComment> GetHairShopCommentsByUserID(int userID, int count, OrderKey ok) { List<HairShopComment> list = new List<HairShopComment>(); string orderKey = " order by "; switch (ok) { case OrderKey.Good: orderKey += "IsGood desc"; break; case OrderKey.ID: orderKey += "HairShopID desc"; break; case OrderKey.Time: orderKey += "HairShopCommentCreateTime desc"; break; default: orderKey += "HairShopCommentID desc"; break; } string commText = string.Empty; switch (count) { case 0: commText = "select * from HairShopComment where UserID=" + userID.ToString() + orderKey; break; default: commText = "select top " + count.ToString() + " * from HairShopComment where UserID=" + userID.ToString() + orderKey; break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { { using (SqlCommand comm = new SqlCommand()) { comm.Connection = conn; comm.CommandText = commText; conn.Open(); using (SqlDataReader sdr = comm.ExecuteReader()) { while (sdr.Read()) { HairShopComment hairShopComment = new HairShopComment(); hairShopComment.CommentCreateTime = Convert.ToDateTime(sdr["HairShopCommentCreateTime"].ToString()); hairShopComment.CommentID = int.Parse(sdr["HairShopCommentID"].ToString()); hairShopComment.CommentText = sdr["HairShopCommentText"].ToString(); hairShopComment.HairShopID = int.Parse(sdr["HairShopID"].ToString()); hairShopComment.UserAddress = sdr["UserAddress"].ToString(); hairShopComment.UserID = int.Parse(sdr["UserID"].ToString()); hairShopComment.UserName = sdr["UserName"].ToString(); hairShopComment.IsGood = Convert.ToBoolean(sdr["IsGood"].ToString()); list.Add(hairShopComment); } } } } } return list; }
/// <summary> /// ���������� ��ӣ�ɾ������ /// </summary> /// <param name="hairShopComment"></param> /// <param name="ua"></param> /// <returns></returns> public bool HairShopCommentCreateDeleteUpdate(HairShopComment hairShopComment, UserAction ua) { bool result = false; string commandText = string.Empty; switch (ua) { case UserAction.Create: commandText = "insert into HairShopComment(HairShopCommentText,UserID,UserName,UserAddress,IsGood,HairShopCommentCreateTime,HairShopID) values('" + hairShopComment.CommentText + "'," + hairShopComment.UserID.ToString() + ",'" + hairShopComment.UserName + "','" + hairShopComment.UserAddress + "'," + hairShopComment.IsGood.CompareTo(false).ToString() + ",'" + hairShopComment.CommentCreateTime.ToString() + "'," + hairShopComment.HairShopID.ToString() + ")"; break; case UserAction.Delete: commandText = "delete from HairShopComment where HairShopCommentID = " + hairShopComment.CommentID.ToString(); break; case UserAction.Update: commandText = "update HairShopComment set HairShopCommentText ='" + hairShopComment.CommentText + "',UserID=" + hairShopComment.UserID.ToString() + ",UserName='******',UserAddress='" + hairShopComment.UserAddress + "',IsGood=" + hairShopComment.IsGood.CompareTo(false).ToString() + ",HairShopCommentCreateTime='" + hairShopComment.CommentCreateTime.ToString() + "',HairShopID=" + hairShopComment.HairShopID.ToString() + " where HairShopCommentID=" + hairShopComment.CommentID.ToString(); break; } using (SqlConnection conn = new SqlConnection(DataHelper2.SqlConnectionString)) { using (SqlCommand comm = new SqlCommand()) { comm.CommandText = commandText; comm.Connection = conn; conn.Open(); try { comm.ExecuteNonQuery(); result = true; } catch (Exception ex) { throw new Exception(ex.Message); } } } return result; }