Ejemplo n.º 1
0
        private void AppendMemberKeyWord(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("KeyWord"))
            {
                whereScript.Append(" and (m.Name like ? or m.Email like ? or m.Phone like ? or m.Mobile like ? or m.Project like ? or m.Product like ? or m.PhoneSer like ? or m.PID like ? or m.OnlineWholesalers like ? or m.MobileWholesalers like ? ) ");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
            }
            else
            {
                if (conditions.IsContainsValue("Name"))
                {
                    whereScript.Append(" and m.Name = ? ");
                    param.Add(conditions["Name"]);
                }

                if (conditions.IsContainsValue("Email"))
                {
                    whereScript.Append(" and m.Email = ? ");
                    param.Add(conditions["Email"]);
                }
            }
        }
Ejemplo n.º 2
0
 private void AppendFileDate(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ShowDateStart"))
     {
         whereScript.Append(" and f.ShowDate >= ? ");
         param.Add(Convert.ToDateTime(conditions["ShowDateStart"]));
     }
     if (conditions.IsContainsValue("ShowDateEnd"))
     {
         whereScript.Append(" and f.ShowDate <= ? ");
         param.Add(Convert.ToDateTime(conditions["ShowDateEnd"]));
     }
 }
Ejemplo n.º 3
0
        private void AppendMemberBirthDay(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("BirthdayMonth"))
            {
                whereScript.Append(" and m.BirthdayMonth = ? ");
                param.Add(conditions["BirthdayMonth"]);
            }

            if (conditions.IsContainsValue("BirthdayDay"))
            {
                whereScript.Append(" and m.BirthdayDay = ? ");
                param.Add(conditions["BirthdayDay"]);
            }
        }
Ejemplo n.º 4
0
        private void AppendMemberCreateDate(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("CreateDateFrom"))
            {
                whereScript.Append(" and m.CreatedDate >= ? ");
                param.Add(DateTime.Parse(conditions["CreateDateFrom"]));
            }

            if (conditions.IsContainsValue("CreateDateTo"))
            {
                whereScript.Append(" and m.CreatedDate <= ? ");
                param.Add(DateTime.Parse(conditions["CreateDateTo"]));
            }
        }
Ejemplo n.º 5
0
 private void AppendPostWithOutMemberId(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("WithOutMemberId"))
     {
         whereScript.Append(" and (p.MemberId is null or  p.MemberId = '')");
     }
 }
Ejemplo n.º 6
0
 private void AppendPostNode(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ParentNodeId"))
     {
         whereScript.Append(" and p.Node.ParentNode.NodeId = ? ");
         param.Add(conditions["ParentNodeId"]);
     }
     else
     {
         if (conditions.IsContainsValue("NodeId"))
         {
             whereScript.Append(" and p.Node.NodeId = ? ");
             param.Add(conditions["NodeId"]);
         }
     }
 }
Ejemplo n.º 7
0
 private void AppendPostCustomField1(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("CustomField1"))
     {
         whereScript.Append(" and p.CustomField1 = ? ");
         param.Add(conditions["CustomField1"]);
     }
 }
Ejemplo n.º 8
0
 private void AppendPostProductSer(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ProductSer"))
     {
         whereScript.Append(" and p.ProductSer = ? ");
         param.Add(conditions["ProductSer"]);
     }
 }
Ejemplo n.º 9
0
 private void AppendPostWarrantySuppliers(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("WarrantySuppliers"))
     {
         whereScript.Append(" and p.WarrantySuppliers = ? ");
         param.Add(conditions["WarrantySuppliers"]);
     }
 }
Ejemplo n.º 10
0
 private void AppendMemberStatus(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Status"))
     {
         whereScript.Append(" and m.Status = ? ");
         param.Add(conditions["Status"]);
     }
 }
Ejemplo n.º 11
0
 /// <summary>
 /// 傳入條件,設定查詢取回的資料筆數
 /// </summary>
 /// <param name="query"></param>
 /// <param name="conditions"></param>
 /// <param name="key"></param>
 /// <returns></returns>
 public static IQuery SetMaxResults(this IQuery query, IDictionary<string, string> conditions, string key)
 {
     if (conditions.IsContainsValue(key))
     {
         query.SetMaxResults(Convert.ToInt32(conditions[key]));
     }
     return query;
 }
Ejemplo n.º 12
0
 private void AppendFileNeedUpdate(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("NeedUpdate"))
     {
         whereScript.Append(" and f.NeedUpdate = ? ");
         param.Add(bool.Parse(conditions["NeedUpdate"]));
     }
 }
Ejemplo n.º 13
0
 private void AppendFileFlag(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Flag"))
     {
         whereScript.Append(" and f.Flag = ? ");
         param.Add(conditions["Flag"]);
     }
 }
Ejemplo n.º 14
0
 private void AppendFileKeyWord(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("KeyWord"))
     {
         whereScript.Append(" and (f.FileNo like ? ) ");
         param.Add("%" + conditions["KeyWord"] + "%");
     }
 }
Ejemplo n.º 15
0
 private void AppendPostType(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Type"))
     {
         whereScript.Append(" and p.Type = ? ");
         param.Add(conditions["Type"]);
     }
 }
Ejemplo n.º 16
0
 private void AppendPostIsRecommend(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("IsRecommend"))
     {
         whereScript.Append(" and p.IsRecommend = ? ");
         param.Add(bool.Parse(conditions["IsRecommend"]));
     }
 }
Ejemplo n.º 17
0
 private void AppendMemberUserConfirm(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("UserConfirm"))
     {
         whereScript.Append(" and m.UserConfirm = ? ");
         param.Add(conditions["UserConfirm"]);
     }
 }
Ejemplo n.º 18
0
 private void AppendMemberGetCommission(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("GetCommission"))
     {
         whereScript.Append(" and m.GetCommission = ? ");
         param.Add(conditions["GetCommission"]);
     }
 }
Ejemplo n.º 19
0
 /// <summary>
 /// 傳入條件,設定資料從第n筆開始取回
 /// </summary>
 /// <param name="query"></param>
 /// <param name="conditions"></param>
 /// <param name="key"></param>
 /// <returns></returns>
 public static IQuery SetFirstResult(this IQuery query, IDictionary <string, string> conditions, string key)
 {
     if (conditions.IsContainsValue(key))
     {
         query.SetFirstResult(Convert.ToInt32(conditions[key]));
     }
     return(query);
 }
Ejemplo n.º 20
0
 private void AppendMemberLoginId(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("LoginId"))
     {
         whereScript.Append(" and m.LoginId = ? ");
         param.Add(conditions["LoginId"]);
     }
 }
Ejemplo n.º 21
0
        private void AppendPostKeyWord(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("KeyWord"))
            {
                whereScript.Append(" and (p.Title like ? or p.HtmlContent like ? or p.CustomField1 like ? or p.MemberName like ? or p.MemberPhone like ? or p.ProductSer like ? ) ");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
            }

            if (conditions.IsContainsValue("ProductKeyWord"))
            {
                whereScript.Append(" and (p.Title like ? or p.WarrantySuppliers like ? ) ");
                param.Add("%" + conditions["ProductKeyWord"] + "%");
                param.Add("%" + conditions["ProductKeyWord"] + "%");
            }
        }
Ejemplo n.º 22
0
        private string AppendFileOrder(IDictionary <string, string> conditions)
        {
            //// 排序條件
            string order = "order by f.ShowDate desc ";

            if (conditions.IsContainsValue("Order"))
            {
                order = conditions["Order"];
            }

            return(order);
        }
Ejemplo n.º 23
0
        public IList <T> Query <T>(string hql, ArrayList param, IDictionary <string, string> conditions)
        {
            ISession session = HibernateTemplate.SessionFactory.GetCurrentSession();

            log.Debug("hql:" + hql);
            IQuery query = session.CreateQuery(hql);

            for (int i = 0; i < param.Count; i++)
            {
                query.SetParameter(i, param[i]);
            }

            //// 處理paging
            if (conditions.IsContainsValue("PageSize") && conditions.IsContainsValue("PageIndex"))
            {
                int pageIndex  = Convert.ToInt32(conditions["PageIndex"]);
                int pageSize   = Convert.ToInt32(conditions["PageSize"]);
                int startIndex = ConvertUtil.GetStartIndex(pageIndex, pageSize);
                query.SetFirstResult(startIndex);
                query.SetMaxResults(pageSize);
            }

            return(query.List <T>());
        }
Ejemplo n.º 24
0
        private void AppendMemberDate(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            ILog m_Log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            if (conditions.IsContainsValue("ApplyDateStart"))
            {
                whereScript.Append(" and m.ApplyDate >= ? ");
                param.Add(Convert.ToDateTime(conditions["ApplyDateStart"]));
            }
            if (conditions.IsContainsValue("ApplyDateEnd"))
            {
                whereScript.Append(" and m.ApplyDate <= ? ");
                m_Log.Debug("m.ApplyDate <=" + (Convert.ToDateTime(conditions["ApplyDate"]).AddDays(1).AddMinutes(-1)).ToString());
                param.Add(Convert.ToDateTime(conditions["ApplyDateEnd"]).AddDays(1).AddMinutes(-1));
            }
            if (conditions.IsContainsValue("DueDateStart"))
            {
                whereScript.Append(" and m.DueDate >= ? ");
                param.Add(Convert.ToDateTime(conditions["DueDateStart"]));
            }
            if (conditions.IsContainsValue("DueDateEnd"))
            {
                whereScript.Append(" and m.DueDate <= ? ");
                m_Log.Debug("m.DueDateEnd <=" + (Convert.ToDateTime(conditions["DueDateEnd"]).AddDays(1).AddMinutes(-1)).ToString());
                param.Add(Convert.ToDateTime(conditions["DueDateEnd"]).AddDays(1).AddMinutes(-1));
            }
            if (conditions.IsContainsValue("ApplyDate2Start"))
            {
                whereScript.Append(" and m.ApplyDate2 >= ? ");
                param.Add(Convert.ToDateTime(conditions["ApplyDate2Start"]));
            }
            if (conditions.IsContainsValue("ApplyDate2End"))
            {
                whereScript.Append(" and m.ApplyDate2 <= ? ");
                m_Log.Debug("m.ApplyDate2End <=" + (Convert.ToDateTime(conditions["ApplyDate2End"]).AddDays(1).AddMinutes(-1)).ToString());
                param.Add(Convert.ToDateTime(conditions["ApplyDate2End"]).AddDays(1).AddMinutes(-1));
            }
            if (conditions.IsContainsValue("ApplyDate2"))
            {
                whereScript.Append(" and m.ApplyDate2 = ? ");
                param.Add(Convert.ToDateTime(conditions["ApplyDate2"]));
            }
        }
Ejemplo n.º 25
0
 private void AppendPostParentPost(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ParentPostId"))
     {
         whereScript.Append(" and p.ParentPost.PostId = ? ");
         param.Add(conditions["ParentPostId"]);
     }
 }
Ejemplo n.º 26
0
        private string AppendPostOrder(IDictionary<string, string> conditions)
        {
            //// 排序條件
            string order = "order by p.SortNo, p.ShowDate desc ";
            if (conditions.IsContainsValue("Order"))
            {
                order = conditions["Order"];
            }

            return order;
        }
Ejemplo n.º 27
0
        private void AppendMemberCreateDate(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("CreateDateFrom"))
            {
                whereScript.Append(" and m.CreatedDate >= ? ");
                param.Add(DateTime.Parse(conditions["CreateDateFrom"]));
            }

            if (conditions.IsContainsValue("CreateDateTo"))
            {
                whereScript.Append(" and m.CreatedDate <= ? ");
                param.Add(DateTime.Parse(conditions["CreateDateTo"]));
            }
        }
Ejemplo n.º 28
0
 private void AppendMemberGetCommission(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("GetCommission"))
     {
         whereScript.Append(" and m.GetCommission = ? ");
         param.Add(conditions["GetCommission"]);
     }
 }
Ejemplo n.º 29
0
 private void AppendMemberLoginId(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("LoginId"))
     {
         whereScript.Append(" and m.LoginId = ? ");
         param.Add(conditions["LoginId"]);
     }
 }
Ejemplo n.º 30
0
        ///// <summary>
        ///// 取得會員下載紀錄 By 識別碼
        ///// </summary>
        ///// <param name="downloadRecordId">識別碼</param>
        ///// <returns>會員下載紀錄</returns>
        //public DownloadRecord GetDownloadRecordByIdNoLazy(int downloadRecordId)
        //{
        //    DownloadRecord downloadRecord = FTISDao.GetDownloadRecordById(downloadRecordId);

        //    if (downloadRecord != null && downloadRecord.Member != null)
        //    {
        //        NHibernateUtil.Initialize(downloadRecord.Member);
        //    }

        //    return downloadRecord;
        //}

        /// <summary>
        /// 取得會員下載紀錄統計表清單
        /// </summary>
        /// <param name="conditions">搜尋條件</param>
        /// <returns>會員下載紀錄統計表清單</returns>
        public IList<DownloadRecord> GetDownloadRecordStatistics(IDictionary<string, string> conditions)
        {
            if (conditions.IsContainsValue("Order"))
            {
                conditions.Remove("Order");
            }
            conditions.Add("Order", "order by d.Name ");
            return FTISDao.GetDownloadRecordStatistics(conditions);
        }
Ejemplo n.º 31
0
 private void AppendPostWarrantySuppliers(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("WarrantySuppliers"))
     {
         whereScript.Append(" and p.WarrantySuppliers = ? ");
         param.Add(conditions["WarrantySuppliers"]);
     }
 }
Ejemplo n.º 32
0
 private void AppendMemberStore(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Store"))
     {
         whereScript.Append(" and m.Store = ? ");
         param.Add(conditions["Store"]);
     }
 }
Ejemplo n.º 33
0
 private void AppendMemberUserConfirm(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("UserConfirm"))
     {
         whereScript.Append(" and m.UserConfirm = ? ");
         param.Add(conditions["UserConfirm"]);
     }
 }
Ejemplo n.º 34
0
 private void AppendFileDate(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ShowDateStart"))
     {
         whereScript.Append(" and f.ShowDate >= ? ");
         param.Add(Convert.ToDateTime(conditions["ShowDateStart"]));
     }
     if (conditions.IsContainsValue("ShowDateEnd"))
     {
         whereScript.Append(" and f.ShowDate <= ? ");
         param.Add(Convert.ToDateTime(conditions["ShowDateEnd"]));
     }
 }
Ejemplo n.º 35
0
 private void AppendFileFlag(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Flag"))
     {
         whereScript.Append(" and f.Flag = ? ");
         param.Add(conditions["Flag"]);
     }
 }
Ejemplo n.º 36
0
 private void AppendFileKeyWord(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("KeyWord"))
     {
         whereScript.Append(" and (f.FileNo like ? ) ");
         param.Add("%" + conditions["KeyWord"] + "%");
     }
 }
Ejemplo n.º 37
0
 private void AppendPostProductSer(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("ProductSer"))
     {
         whereScript.Append(" and p.ProductSer = ? ");
         param.Add(conditions["ProductSer"]);
     }
 }
Ejemplo n.º 38
0
 private void AppendPostType(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("Type"))
     {
         whereScript.Append(" and p.Type = ? ");
         param.Add(conditions["Type"]);
     }
 }
Ejemplo n.º 39
0
 private void AppendPostCustomField2(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("CustomField2"))
     {
         whereScript.Append(" and p.CustomField2 = ? ");
         param.Add(conditions["CustomField2"]);
     }
 }
Ejemplo n.º 40
0
 private void AppendPostWithOutMemberId(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("WithOutMemberId"))
     {
         whereScript.Append(" and (p.MemberId is null or  p.MemberId = '')");
     }
 }
Ejemplo n.º 41
0
        private void AppendPostDate(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            ILog m_Log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            if (conditions.IsContainsValue("ShowDateStart"))
            {
                whereScript.Append(" and p.ShowDate >= ? ");
                param.Add(Convert.ToDateTime(conditions["ShowDateStart"]));
            }
            if (conditions.IsContainsValue("ShowDateEnd"))
            {
                whereScript.Append(" and p.ShowDate <= ? ");
                m_Log.Debug("p.ShowDate <=" + (Convert.ToDateTime(conditions["ShowDateEnd"]).AddDays(1).AddMinutes(-1)).ToString());
                param.Add(Convert.ToDateTime(conditions["ShowDateEnd"]).AddDays(1).AddMinutes(-1));
            }
            if (conditions.IsContainsValue("CloseDateStart"))
            {
                whereScript.Append(" and p.CloseDate >= ? ");
                param.Add(Convert.ToDateTime(conditions["CloseDateStart"]));
            }
            if (conditions.IsContainsValue("CloseDateEnd"))
            {
                whereScript.Append(" and p.CloseDate <= ? ");
                m_Log.Debug("p.CloseDateEnd <=" + (Convert.ToDateTime(conditions["CloseDateEnd"]).AddDays(1).AddMinutes(-1)).ToString());
                param.Add(Convert.ToDateTime(conditions["CloseDateEnd"]).AddDays(1).AddMinutes(-1));
            }

            if (conditions.IsContainsValue("CloseDate"))
            {
                whereScript.Append(" and p.CloseDate = ? ");
                param.Add(Convert.ToDateTime(conditions["CloseDate"]));
            }

            if (conditions.IsContainsValue("ShowDate"))
            {
                whereScript.Append(" and p.ShowDate = ? ");
                param.Add(Convert.ToDateTime(conditions["ShowDate"]));
            }
        }
Ejemplo n.º 42
0
        private string AppendMemberOrder(IDictionary<string, string> conditions)
        {
            //// 排序條件
            string order = "order by m.CreatedDate desc ";
            if (conditions.IsContainsValue("Order"))
            {
                order = conditions["Order"];
            }

            return order;
        }
Ejemplo n.º 43
0
 private void AppendPostIsRecommend(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("IsRecommend"))
     {
         whereScript.Append(" and p.IsRecommend = ? ");
         param.Add(bool.Parse(conditions["IsRecommend"]));
     }
 }
Ejemplo n.º 44
0
        private void AppendMemberKeyWord(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("KeyWord"))
            {
                whereScript.Append(" and (m.Name like ? or m.Email like ? or m.Phone like ? or m.Mobile like ? or m.Project like ? or m.Product like ? or m.PhoneSer like ? or m.PID like ? or m.OnlineWholesalers like ? or m.MobileWholesalers like ? ) ");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
            }
            else
            {
                if (conditions.IsContainsValue("Name"))
                {
                    whereScript.Append(" and m.Name = ? ");
                    param.Add(conditions["Name"]);
                }

                if (conditions.IsContainsValue("Email"))
                {
                    whereScript.Append(" and m.Email = ? ");
                    param.Add(conditions["Email"]);
                }
            }
        }
Ejemplo n.º 45
0
        private void AppendPostKeyWord(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("KeyWord"))
            {
                whereScript.Append(" and (p.Title like ? or p.HtmlContent like ? or p.CustomField1 like ? or p.MemberName like ? or p.MemberPhone like ? or p.ProductSer like ? ) ");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
                param.Add("%" + conditions["KeyWord"] + "%");
            }

            if (conditions.IsContainsValue("ProductKeyWord"))
            {
                whereScript.Append(" and (p.Title like ? or p.WarrantySuppliers like ? ) ");
                param.Add("%" + conditions["ProductKeyWord"] + "%");
                param.Add("%" + conditions["ProductKeyWord"] + "%");
            }
        }
Ejemplo n.º 46
0
        private void AppendMemberBirthDay(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
        {
            if (conditions.IsContainsValue("BirthdayMonth"))
            {
                whereScript.Append(" and m.BirthdayMonth = ? ");
                param.Add(conditions["BirthdayMonth"]);
            }

            if (conditions.IsContainsValue("BirthdayDay"))
            {
                whereScript.Append(" and m.BirthdayDay = ? ");
                param.Add(conditions["BirthdayDay"]);
            }
        }
Ejemplo n.º 47
0
 private void AppendPostNeedUpdate(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param)
 {
     if (conditions.IsContainsValue("NeedUpdate"))
     {
         whereScript.Append(" and p.NeedUpdate = ? ");
         param.Add(bool.Parse(conditions["NeedUpdate"]));
     }
 }