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"]); } } }
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"])); } }
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"]); } }
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"])); } }
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 = '')"); } }
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"]); } } }
private void AppendPostCustomField1(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("CustomField1")) { whereScript.Append(" and p.CustomField1 = ? "); param.Add(conditions["CustomField1"]); } }
private void AppendPostProductSer(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("ProductSer")) { whereScript.Append(" and p.ProductSer = ? "); param.Add(conditions["ProductSer"]); } }
private void AppendPostWarrantySuppliers(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("WarrantySuppliers")) { whereScript.Append(" and p.WarrantySuppliers = ? "); param.Add(conditions["WarrantySuppliers"]); } }
private void AppendMemberStatus(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Status")) { whereScript.Append(" and m.Status = ? "); param.Add(conditions["Status"]); } }
/// <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; }
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"])); } }
private void AppendFileFlag(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Flag")) { whereScript.Append(" and f.Flag = ? "); param.Add(conditions["Flag"]); } }
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"] + "%"); } }
private void AppendPostType(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Type")) { whereScript.Append(" and p.Type = ? "); param.Add(conditions["Type"]); } }
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"])); } }
private void AppendMemberUserConfirm(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("UserConfirm")) { whereScript.Append(" and m.UserConfirm = ? "); param.Add(conditions["UserConfirm"]); } }
private void AppendMemberGetCommission(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("GetCommission")) { whereScript.Append(" and m.GetCommission = ? "); param.Add(conditions["GetCommission"]); } }
/// <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); }
private void AppendMemberLoginId(IDictionary <string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("LoginId")) { whereScript.Append(" and m.LoginId = ? "); param.Add(conditions["LoginId"]); } }
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"] + "%"); } }
private string AppendFileOrder(IDictionary <string, string> conditions) { //// 排序條件 string order = "order by f.ShowDate desc "; if (conditions.IsContainsValue("Order")) { order = conditions["Order"]; } return(order); }
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>()); }
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"])); } }
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"]); } }
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; }
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"])); } }
private void AppendMemberGetCommission(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("GetCommission")) { whereScript.Append(" and m.GetCommission = ? "); param.Add(conditions["GetCommission"]); } }
private void AppendMemberLoginId(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("LoginId")) { whereScript.Append(" and m.LoginId = ? "); param.Add(conditions["LoginId"]); } }
///// <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); }
private void AppendPostWarrantySuppliers(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("WarrantySuppliers")) { whereScript.Append(" and p.WarrantySuppliers = ? "); param.Add(conditions["WarrantySuppliers"]); } }
private void AppendMemberStore(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Store")) { whereScript.Append(" and m.Store = ? "); param.Add(conditions["Store"]); } }
private void AppendMemberUserConfirm(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("UserConfirm")) { whereScript.Append(" and m.UserConfirm = ? "); param.Add(conditions["UserConfirm"]); } }
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"])); } }
private void AppendFileFlag(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Flag")) { whereScript.Append(" and f.Flag = ? "); param.Add(conditions["Flag"]); } }
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"] + "%"); } }
private void AppendPostProductSer(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("ProductSer")) { whereScript.Append(" and p.ProductSer = ? "); param.Add(conditions["ProductSer"]); } }
private void AppendPostType(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("Type")) { whereScript.Append(" and p.Type = ? "); param.Add(conditions["Type"]); } }
private void AppendPostCustomField2(IDictionary<string, string> conditions, StringBuilder whereScript, ArrayList param) { if (conditions.IsContainsValue("CustomField2")) { whereScript.Append(" and p.CustomField2 = ? "); param.Add(conditions["CustomField2"]); } }
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 = '')"); } }
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"])); } }
private string AppendMemberOrder(IDictionary<string, string> conditions) { //// 排序條件 string order = "order by m.CreatedDate desc "; if (conditions.IsContainsValue("Order")) { order = conditions["Order"]; } return order; }
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"])); } }
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"]); } } }
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"] + "%"); } }
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"]); } }
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"])); } }