void AdInfoSearchForm_DoubleClick(object sender, EventArgs e) { Xceed.Grid.DataCell cell = sender as Xceed.Grid.DataCell; var row = cell.ParentRow; var dmc = ServiceProvider.GetService <IApplication>().ExecuteAction(row.Cells["Table"].Value.ToString()) as IDisplayManagerContainer; dmc.DisplayManager.SearchManager.LoadData(SearchExpression.Eq(row.Cells["Column"].Value.ToString(), row.Cells["Value"].Value.ToString()), null); }
/// <summary> /// /// </summary> /// <returns></returns> public ISearchExpression GetSearchExpression() { if (this.Value != null && this.Value != this.NullValue && this.Value.ToString() != this.NullText) { GridColumnInfo info = this.ParentColumn.Tag as GridColumnInfo; if (info != null) { string searchPropertyName = GetSearchPropertyName(info); ISearchExpression ret = SearchExpression.Like(searchPropertyName, this.Value); object searchValue = this.Value; if (searchValue != null && info.CellViewerManager == "Combo") { string nvName = Feng.Windows.Utils.GridColumnInfoHelper.GetNameValueMappingName(info, true); searchValue = Feng.Utils.NameValueControlHelper.GetMultiValue(nvName, searchValue.ToString()); ret = SearchExpression.Or(ret, SearchExpression.Eq(searchPropertyName, searchValue)); } return(ret); } } return(null); //object value; //if (this.IsBeingEdited) //{ // value = ((FilterEditor)this.CellEditorManager).TemplateControl.SelectedValue; //} //else //{ // value = this.Value; //} //if (m_filterItems.ContainsKey(value.ToString())) //{ // return m_filterItems[value.ToString()]; //} //else //{ // // 因为Filter有保存,但是里面的内容有变化,所以可能产生无内容的情况 // // this.Value = s_anyText; // 但是还是保存Value // return m_filterItems[s_anyText]; //} }
private void SetTopGrid() { if (用途分类.SelectedDataValue == null) { return; } 凭证用途分类 ytfl = (凭证用途分类)用途分类.SelectedDataValue; if (ytfl == 凭证用途分类.业务应付) { if (付款对象.SelectedDataValue == null) { return; } ArchiveFormFactory.SetupDataUnboundGrid(grdTop, ADInfoBll.Instance.GetWindowTabInfo("资金票据_应收应付当前")); grdTop.DisplayManager.SearchManager.LoadData(SearchExpression.And(SearchExpression.Eq("相关人", 付款对象.SelectedDataValue), SearchExpression.Eq("收付标志", Hd.Model.收付标志.付)), null); } }
void DisplayManager_PositionChanged(object sender, EventArgs e) { Clear(false); 转关箱排车暂存组 entity = m_暂存计划区Grid.DisplayManager.CurrentItem as 转关箱排车暂存组; if (entity == null) { btn计算机辅助优化.Enabled = false; btn全自动化.Enabled = false; btn确认.Enabled = false; btn暂存.Enabled = false; btn重排.Enabled = false; btn打印.Enabled = false; return; } if (entity.IsActive) { btn计算机辅助优化.Enabled = false; btn全自动化.Enabled = false; btn确认.Enabled = false; btn暂存.Enabled = false; btn重排.Enabled = false; } else { btn计算机辅助优化.Enabled = true; btn全自动化.Enabled = true; btn确认.Enabled = true; btn暂存.Enabled = true; btn重排.Enabled = true; } m_待排转关箱任务区Grid.DisplayManager.SearchManager.LoadData(SearchExpression.Eq("暂存组", entity.ID), null); m_待排转关箱任务区Grid.DisplayManager.SearchManager.WaitLoadData(); Load排车任务(entity); }
//private 任务Dao m_rwDao = new 任务Dao(); private void 进口箱批量任务录入_Load(object sender, EventArgs e) { m_暂存区Grid = base.AssociateArchiveGrid(pnl暂存区, "任务备案_进口箱批量任务确认_暂存区") as ArchiveUnboundGrid; m_cm = m_暂存区Grid.ControlManager as IWindowControlManager <进口票>; m_显示区Grid = MyTemplateForm.AssociateArchiveDetailGrid(pnl显示区, "任务备案_进口箱批量任务确认_显示区", m_cm, m_cm.Dao as IRelationalDao) as ArchiveUnboundGrid; m_cm2 = m_显示区Grid.ControlManager as IWindowControlManager <任务>; base.AssociateDataControls(new Control[] { pnl任务性质, pnl转关箱标志, pnl委托人, pnl委托时间, pnl委托联系人, pnl提单号, pnl船名, pnl航次, pnl提箱时间要求, pnl还箱进港时间要求, pnl备注, pnl总箱量, pnl提单号, pnl箱属船公司 }, m_cm.DisplayManager, m_gridName); m_cm.StateControls.Add(new StateControl(btn修改, StateType.View)); m_cm.StateControls.Add(new StateControl(btn拒绝, StateType.View)); m_cm.StateControls.Add(new StateControl(btn放弃, false)); m_cm.StateControls.Add(new StateControl(btn备案确认, StateType.View | StateType.Add | StateType.Edit)); m_cm.DisplayManager.DataControls["委托人编号"].SelectedDataValueChanged += new EventHandler(任务预备案_委托人编号_SelectedDataValueChanged); m_cm.DisplayManager.PositionChanging += new Feng.CancelEventHandler(DisplayManager_PositionChanging); m_cm.DisplayManager.PositionChanged += new EventHandler(DisplayManager_PositionChanged); Helper.SetGridDefault(this, m_暂存区Grid); if (m_提单号 == null) { m_cm.DisplayManager.SearchManager.LoadData(); } else { btn修改.Enabled = false; m_cm.DisplayManager.SearchManager.AdditionalSearchExpression = null; m_cm.DisplayManager.SearchManager.LoadData(SearchExpression.Eq("提单号", m_提单号), null); } }
private void 单车后续作业计划_Load(object sender, EventArgs e) { if (m_cl != null) { using (IRepository rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <车辆作业>()) { var cl = rep.Get <车辆>(m_cl.ID); txt车型.Text = cl.车型; txt车主.Text = cl.车主.简称; txt承运车辆.Text = cl.车牌号; txt核定载重.Text = cl.核定载重; txt监管车.Text = cl.监管车 ? "是" : "否"; txt联系电话.Text = cl.主驾驶员.联系方式; } var rightGrid = base.AssociateBoundGrid(pnl车辆作业集合, "车队级调度_静态任务下达_单车后续作业计划"); rightGrid.DisplayManager.SearchManager.LoadData(SearchExpression.And( SearchExpression.Eq("车辆作业:车辆", m_cl), SearchExpression.IsNull("车辆作业:结束时间")), new List <ISearchOrder> { SearchOrder.Asc("车辆作业:Created") }); } }
/// <summary> /// /// </summary> /// <param name="searchExpression"></param> /// <param name="searchOrders"></param> /// <param name="parentItem"></param> /// <returns></returns> public override System.Collections.IEnumerable GetData(ISearchExpression searchExpression, IList <ISearchOrder> searchOrders, object parentItem) { if (parentItem == null) { return(null); } SearchHistoryInfo his = this.ParentDisplayManager.SearchManager.GetHistory(0); if (!string.IsNullOrEmpty(his.Expression)) { ISearchExpression exp = SearchExpression.Parse(his.Expression); exp = RemoveParentSelectAsExpression(exp); searchExpression = SearchExpression.And(searchExpression, exp); } foreach (string s in m_groupByColumns) { object r = EntityScript.GetPropertyValue(parentItem, s); ISearchExpression se2; if (r != null && r != System.DBNull.Value) { se2 = SearchExpression.Eq(s, EntityScript.GetPropertyValue(parentItem, s)); } else { se2 = SearchExpression.IsNull(s); } searchExpression = SearchExpression.And(searchExpression, se2); } this.SetHistory(searchExpression, searchOrders); return(m_innerSearchManager.GetData(searchExpression, searchOrders)); }
protected void Button1_Click(object sender, EventArgs e) { string zid = id.Text.Trim().ToString(); //string weiTuoRen = weiTuoRen.SelectedValue.ToString(); string tiDanHao1 = tiDanHao.Text.Trim().ToString(); string xiangLiang1 = xiangLiang.Text.Trim().ToString(); string zongZhongLiang1 = zongZhongLiang.Text.Trim().ToString(); string daiBiaoXing1 = daiBiaoXing.Text.Trim().ToString(); string pinMing1 = pinMing.Text.Trim().ToString(); string state1 = state.SelectedValue.ToString(); string url = "Search.aspx?window=网页查询_客户委托情况_进口&se="; Session.RemoveAll(); ISearchExpression se = null; if (!string.IsNullOrEmpty(zid)) { se = AndIfNecessary(se, SearchExpression.Like("货代自编号", "%" + zid + "%")); Session["id"] = zid; } if (!string.IsNullOrEmpty(tiDanHao1)) { se = AndIfNecessary(se, SearchExpression.Like("提单号", "%" + tiDanHao1 + "%")); Session["tiDanHao"] = tiDanHao1; } if (!string.IsNullOrEmpty(xiangLiang1)) { se = AndIfNecessary(se, SearchExpression.Eq("箱量", xiangLiang1)); Session["xiangLiang"] = xiangLiang1; } if (!string.IsNullOrEmpty(zongZhongLiang1)) { se = AndIfNecessary(se, SearchExpression.Eq("总重量", zongZhongLiang1)); Session["zongZhongLiang"] = zongZhongLiang1; } if (!string.IsNullOrEmpty(daiBiaoXing1)) { se = AndIfNecessary(se, SearchExpression.Like("代表性箱号", "%" + daiBiaoXing1 + "%")); Session["daiBiaoXing"] = daiBiaoXing1; } if (!string.IsNullOrEmpty(pinMing1)) { se = AndIfNecessary(se, SearchExpression.Like("品名", "%" + pinMing1 + "%")); Session["pinMing"] = pinMing1; } if (!string.IsNullOrEmpty(state1)) { se = AndIfNecessary(se, SearchExpression.Eq("当前状态", state1)); //Session["state"] = state1; } if (!weiTuoTime1.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Ge("委托时间", weiTuoTime1.Value.Trim().ToString())); } if (!weiTuoTime2.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Le("委托时间", weiTuoTime2.Value.Trim().ToString())); } if (!daoGangTime1.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Ge("到港时间", daoGangTime1.Value.Trim().ToString())); } if (!daoGangTime2.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Le("到港时间", daoGangTime2.Value.Trim().ToString())); } if (!danZhengTime1.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Ge("单证齐全时间", danZhengTime1.Value.Trim().ToString())); } if (!danZhengTime2.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Le("单证齐全时间", danZhengTime2.Value.Trim().ToString())); } if (!jieGuanTime1.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Ge("结关时间", jieGuanTime1.Value.Trim().ToString())); } if (!jieGuanTime2.Value.Trim().ToString().Equals("")) { se = AndIfNecessary(se, SearchExpression.Le("结关时间", jieGuanTime2.Value.Trim().ToString())); } if (se != null) { //exp = HttpUtility.UrlEncode(exp); string exp = se.ToString(); //exp = HttpUtility.UrlEncode(exp, System.Text.Encoding.GetEncoding("gb2312")); exp = Server.UrlEncode(exp); url += exp; } Response.Redirect(url); }
public static void FyDoubleClick(object sender1, EventArgs e1) { Xceed.Grid.DataCell cell = sender1 as Xceed.Grid.DataCell; Xceed.Grid.DataRow row = cell.ParentRow as Xceed.Grid.DataRow; //if (row.ParentGrid.ReadOnly) // return; //IBoundGrid grid = (m_masterForm.ArchiveDetailForm as IArchiveDetailFormWithDetailGrids).DetailGrids[0]; ArchiveSeeForm masterForm = cell.GridControl.FindForm() as ArchiveSeeForm; if (masterForm == null) { // 通过DetailForm来的 masterForm = (cell.GridControl.FindForm() as ArchiveDetailForm).ParentForm as ArchiveSeeForm; } ArchiveOperationForm fydjForm = masterForm.Tag as ArchiveOperationForm; //if (cell.FieldName == "拟付金额" || cell.FieldName == "拟收金额" || cell.FieldName == "费用项") { if (fydjForm == null) { if (masterForm.Name == "内贸出港_票费用") { fydjForm = ServiceProvider.GetService <IWindowFactory>().CreateWindow(ADInfoBll.Instance.GetWindowInfo("内贸出港_票费用项费用登记")) as ArchiveOperationForm; } else { fydjForm = ServiceProvider.GetService <IWindowFactory>().CreateWindow(ADInfoBll.Instance.GetWindowInfo("业务财务_票费用项费用登记")) as ArchiveOperationForm; } masterForm.Tag = fydjForm; Dictionary <string, object> setDatanew = new Dictionary <string, object>(); fydjForm.Tag = setDatanew; (fydjForm.ControlManager.Dao as 业务费用Dao).TransactionBeginning += new EventHandler <OperateArgs <业务费用> >(delegate(object sender, OperateArgs <业务费用> e) { if (e.Entity.费用实体 == null) { 业务费用 fy = e.Entity as 业务费用; fy.费用实体 = e.Repository.Get <费用实体>(setDatanew["费用实体"]); fy.票 = fy.费用实体 as 普通票; fy.费用项编号 = (string)setDatanew["费用项"]; } }); fydjForm.DisplayManager.SearchManager.EnablePage = false; fydjForm.DisplayManager.SearchManager.DataLoaded += new EventHandler <DataLoadedEventArgs>(delegate(object sender, DataLoadedEventArgs e) { fydjForm.TopMost = true; fydjForm.Show(); }); fydjForm.FormClosing += new FormClosingEventHandler(delegate(object sender, FormClosingEventArgs e) { if (e.CloseReason == CloseReason.UserClosing) { if (!masterForm.IsDisposed) { if (masterForm is ArchiveOperationForm) { //(masterForm as ArchiveOperationForm).ControlManager.DisplayManager.Items[(masterForm as ArchiveOperationForm).ControlManager.DisplayManager.Position] = (fydjForm.DisplayManager.CurrentItem as 费用).费用实体; (masterForm as ArchiveOperationForm).ControlManager.DisplayManager.SearchManager.ReloadItem((masterForm as ArchiveOperationForm).ControlManager.DisplayManager.Position); (masterForm as ArchiveOperationForm).ControlManager.OnCurrentItemChanged(); } //IBoundGrid grid = (masterForm.ArchiveDetailForm as IArchiveDetailFormWithDetailGrids).DetailGrids[0]; //ISearchManager sm = grid.DisplayManager.SearchManager; //System.Data.DataTable dt = (System.Data.DataTable)sm.FindData(new List<ISearchExpression> { }, null); //foreach (System.Data.DataRow i in dt.Rows) //{ // if (i["费用项"].ToString() == setDatanew["费用项"].ToString()) // { // object save = row.Cells["Submitted"].Value; // grid.SetDataRowsIListData(i, row); // row.Cells["Submitted"].Value = save; // break; // } //} e.Cancel = true; fydjForm.Hide(); } } }); } Dictionary <string, object> setData = fydjForm.Tag as Dictionary <string, object>; setData.Clear(); //进口_额外费用_委托人 费用项双击事件 if (masterForm.Text.Equals("进口_额外费用_委托人")) { //明细窗体 if (cell.ParentColumn.Title.Equals("费用项")) { setData["费用实体"] = (Guid)row.Cells["费用实体"].Value; setData["费用项"] = (string)row.Cells["费用项"].Value; } //主窗体 else { using (var rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <费用项>()) { IList <费用项> list = (rep as Feng.NH.INHibernateRepository).List <费用项>(NHibernate.Criterion.DetachedCriteria.For <费用项>() .Add(NHibernate.Criterion.Expression.Eq("名称", cell.ParentColumn.Title))); if (list != null && list.Count > 0) { setData["费用实体"] = (row.Tag as 进口票).ID; setData["费用项"] = list[0].编号; } } } } // 票费用登记窗体 else if (row.Cells["费用实体"] != null) { setData["费用实体"] = (Guid)row.Cells["费用实体"].Value; setData["费用项"] = (string)row.Cells["费用项"].Value; if (/*cell.FieldName == "已收金额" || cell.FieldName == "应收金额" || */ cell.FieldName == "拟收金额") { setData["收付标志"] = 收付标志.收; } else if (/*cell.FieldName == "已付金额" || cell.FieldName == "应付金额" || */ cell.FieldName == "拟付金额") { setData["收付标志"] = 收付标志.付; } } // 滞箱费 else { setData["费用实体"] = (row.Tag as 费用信息).票Id; setData["费用项"] = "167"; } NameValueMappingCollection.Instance["信息_箱号_动态"].Params["@票"] = (Guid)setData["费用实体"]; NameValueMappingCollection.Instance.Reload(fydjForm.DisplayManager.Name, "信息_箱号_动态"); ISearchExpression se = SearchExpression.And(SearchExpression.Eq("费用实体.ID", (Guid)setData["费用实体"]), SearchExpression.Eq("费用项编号", (string)setData["费用项"])); if (setData.ContainsKey("收付标志")) { se = SearchExpression.And(se, SearchExpression.Eq("收付标志", setData["收付标志"])); } fydjForm.ControlManager.DisplayManager.SearchManager.LoadData(se, null); } //Dictionary<string, bool?> submitted = new Dictionary<string, bool?>(); //foreach (Xceed.Grid.DataRow i in grid.DataRows) //{ // submitted[i.Cells["费用项"].Value.ToString()] = (bool?)i.Cells["Submitted"].Value; //} //(row.GridControl as IBoundGrid).ReloadData(); //foreach (Xceed.Grid.DataRow i in grid.DataRows) //{ // i.Cells["Submitted"].Value = submitted[i.Cells["费用项"].Value.ToString()]; //} }
private void tsbAttachment_Click(object sender, EventArgs e) { if (this.AttachmentForm == null) { return; } object entity = this.DisplayManager.CurrentItem; if (entity == null) { MessageForm.ShowWarning("请选择当前行!"); return; } Type entityType = entity.GetType(); var sm = ServiceProvider.GetService <Feng.NH.ISessionFactoryManager>(); if (sm == null) { return; } NHibernate.ISessionFactory sessionFactory = sm.GetSessionFactory(Feng.Utils.RepositoryHelper.GetConfigNameFromType(entityType)); if (sessionFactory == null) { return; } bool hasCollection; int idx = m_attachmentEntityIdExp.LastIndexOf('.'); if (idx != -1) { string navi = m_attachmentEntityIdExp.Substring(0, idx); entityType = Feng.NH.NHibernateHelper.GetPropertyType(sessionFactory, entityType, navi, out hasCollection); } NHibernate.Metadata.IClassMetadata metaData = sessionFactory.GetClassMetadata(entityType); string entityName = metaData.EntityName; object id = EntityScript.GetPropertyValue(entity, m_attachmentEntityIdExp); string entityId; //object id = EntityHelper.GetPropertyValue(entity, metaData.IdentifierPropertyName); if (id != null) { entityId = id.ToString(); } else { MessageForm.ShowWarning("当前行无Id!"); return; } string formText = entityName + ":" + entityId; IArhiveOperationMasterForm form = this.AttachmentForm; var form2 = form as ArchiveSeeForm; form2.tsbSearch.Visible = false; form.Text = formText + " 的附件"; form.Show(); form.DoView(); form.DisplayManager.SearchManager.LoadData(SearchExpression.And( SearchExpression.Eq("EntityName", entityName), SearchExpression.Eq("EntityId", entityId)), null); m_attachmentEntityName = entityName; m_attachmentEntityId = entityId; //(form.ControlManager.Dao as BaseDao<AttachmentInfo>).EntityOperating += new EventHandler<OperateArgs<AttachmentInfo>>(delegate(object sender1, OperateArgs<AttachmentInfo> e1) //{ // e1.Entity.EntityName = entityName; // e1.Entity.EntityId = entityId; //}); (form.ControlManager.Dao as BaseDao <AttachmentInfo>).EntityOperating -= new EventHandler <OperateArgs <AttachmentInfo> >(AttachmentForm_EntityOperating); (form.ControlManager.Dao as BaseDao <AttachmentInfo>).EntityOperating += new EventHandler <OperateArgs <AttachmentInfo> >(AttachmentForm_EntityOperating); }
/// <summary> /// 根据人员类型(委托人,承运人,收货人)和业务类型(进口,出口。。)生成查询条件 /// 在"参数备案_人员单位"中有一列是Role,为此客户对应的数据库角色名。 /// 例如,用户admin属于角色(货代角色1,收货人角色2),则990001(货代1)Role=货代角色1。当用admin登录后,可按照货代1查询 /// </summary> /// <param name="人员类型"></param> /// <param name="业务类型"></param> /// <returns></returns> public static ISearchExpression GetConstraitByRole(人员类型 人员类型, 业务类型 业务类型) { if (System.Web.HttpContext.Current.User.Identity == null) { return(null); } string name = System.Web.HttpContext.Current.User.Identity.Name; //name = "100000"; string[] roles; using (var pm = new Feng.UserManager.ProviderManager()) { roles = pm.DefaultProvider.CreateUserManager().GetRoles(System.Web.Security.Membership.ApplicationName, name); } System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM 参数备案_人员单位 WHERE Role IN ("); if (roles.Length == 0) { return(null); } for (int i = 0; i < roles.Length; ++i) { string paraNameI = "@Role" + i.ToString(); cmd.CommandText += paraNameI; if (i != roles.Length - 1) { cmd.CommandText += ","; } cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter(paraNameI, roles[i])); } cmd.CommandText += ')'; System.Data.DataTable dt = Feng.Data.DbHelper.Instance.ExecuteDataTable(cmd); //for (int i = 0; i < roles.Length; ++i) //{ // string paraNameI = "'" + roles[i].ToString() + "'"; // cmd.CommandText += paraNameI; // if (i != roles.Length - 1) // { // cmd.CommandText += ","; // } //} //cmd.CommandText += ')'; //System.Data.DataTable dt = DBManager.GetDateTable(cmd); Dictionary <人员类型, string> dict = new Dictionary <人员类型, string> { { 人员类型.委托人, "委托人" }, { 人员类型.承运人, "承运人" }, { 人员类型.收货人, "收货人" } }; ISearchExpression se = null; foreach (System.Data.DataRow row in dt.Rows) { if (!row["业务类型"].ToString().Contains(((int)业务类型).ToString("00") + ",")) { continue; } if (!row["角色用途"].ToString().Contains(((int)人员类型).ToString("00") + ",")) { continue; } ISearchExpression sse = null;// SearchExpression.Eq("ClientId", row["ClientId"].ToString()); if (人员类型 != 人员类型.货代) { sse = SearchExpression.Eq(dict[人员类型], row["编号"]); // SearchExpression.And(sse, SearchExpression.Eq(dict[人员类型], row["编号"])); } if (se == null) { se = sse; } else { if (sse != null) { se = SearchExpression.Or(se, sse); } } } return(se); }
/// <summary> /// /// </summary> /// <param name="searchConditions"></param> /// <param name="searchOrders"></param> public virtual void FillSearchConditions(IList <ISearchExpression> searchConditions, IList <ISearchOrder> searchOrders) { if (Order.HasValue) { if (Order.Value) { searchOrders.Add(SearchOrder.Asc(PropertyNameToSearch)); } else { searchOrders.Add(SearchOrder.Desc(PropertyNameToSearch)); } } if (IsNull) { if (!IsNot) { //// 对帐单.对账单号 为空,其实意义就是对帐单为空 //if (string.IsNullOrEmpty(this.Navigator)) //{ // searchConditions.Add(SearchExpression.IsNull(PropertyNameToSearch)); //} //else //{ // // 为空的话,只去最前面一个 // string[] ss = this.Navigator.Split(new char[] { '.', ':' }, StringSplitOptions.RemoveEmptyEntries); // searchConditions.Add(SearchExpression.IsNull(ss[0])); //} if (SearchNullUseFull || string.IsNullOrEmpty(this.Navigator)) { searchConditions.Add(SearchExpression.IsNull(PropertyNameToSearch)); } else { if (string.IsNullOrEmpty(this.Navigator)) { throw new ArgumentException("When SearchNullUseFull is false, it will use Navigator's first part, so navigator must not null!"); } string[] ss = this.Navigator.Split(new char[] { '.', ':' }, StringSplitOptions.RemoveEmptyEntries); searchConditions.Add(SearchExpression.IsNull(ss[0])); } } else { searchConditions.Add(SearchExpression.IsNotNull(PropertyNameToSearch)); } } else { IMultiDataValueControl mdc = this.Control as IMultiDataValueControl; if (mdc != null) { if (this.SelectedDataValues.Count == 0) { return; } if (!this.UseFuzzySearch.HasValue) { if (this.CanSelectFuzzySearch && mdc.SelectedDataValues.Count == 1) { if (!IsNot) { searchConditions.Add(SearchExpression.Like(PropertyNameToSearch, mdc.SelectedDataValues[0])); } else { searchConditions.Add(SearchExpression.NotLike(PropertyNameToSearch, mdc.SelectedDataValues[0])); } } else { if (!IsNot) { searchConditions.Add(SearchExpression.InG(PropertyNameToSearch, mdc.SelectedDataValues)); } else { searchConditions.Add(SearchExpression.NotInG(PropertyNameToSearch, mdc.SelectedDataValues)); } } } else if (this.UseFuzzySearch.Value) { if (!IsNot) { searchConditions.Add(SearchExpression.GInG(PropertyNameToSearch, mdc.SelectedDataValues)); } else { searchConditions.Add(SearchExpression.NotGInG(PropertyNameToSearch, mdc.SelectedDataValues)); } } else { if (!IsNot) { searchConditions.Add(SearchExpression.InG(PropertyNameToSearch, mdc.SelectedDataValues)); } else { searchConditions.Add(SearchExpression.NotInG(PropertyNameToSearch, mdc.SelectedDataValues)); } } } else { if (this.SelectedDataValue == null) { return; } if (this.CanSelectFuzzySearch && (!this.UseFuzzySearch.HasValue || this.UseFuzzySearch.Value)) { string s = this.SelectedDataValue.ToString(); if (!IsNot) { searchConditions.Add(SearchExpression.Like(PropertyNameToSearch, s)); } else { searchConditions.Add(SearchExpression.NotLike(PropertyNameToSearch, s)); } } else { if (!IsNot) { searchConditions.Add(SearchExpression.Eq(PropertyNameToSearch, this.SelectedDataValue)); } else { searchConditions.Add(SearchExpression.NotEq(PropertyNameToSearch, this.SelectedDataValue)); } } } } if (!string.IsNullOrEmpty(this.AdditionalSearchExpression)) { searchConditions.Add(SearchExpression.Parse(this.AdditionalSearchExpression)); } }
public static void FyDoubleClick(object sender1, EventArgs e1) { Xceed.Grid.DataCell cell = sender1 as Xceed.Grid.DataCell; Xceed.Grid.DataRow row = cell.ParentRow as Xceed.Grid.DataRow; ArchiveSeeForm masterForm = cell.GridControl.FindForm() as ArchiveSeeForm; if (masterForm == null) { // 通过DetailForm来的 masterForm = (cell.GridControl.FindForm() as ArchiveDetailForm).ParentForm as ArchiveSeeForm; } ArchiveOperationForm fydjForm = masterForm.Tag as ArchiveOperationForm; //if (cell.FieldName == "拟付金额" || cell.FieldName == "拟收金额" || cell.FieldName == "费用项") { if (fydjForm == null) { fydjForm = ServiceProvider.GetService <IWindowFactory>().CreateWindow(ADInfoBll.Instance.GetWindowInfo("业务备案_车辆产值费用_双击")) as ArchiveOperationForm; masterForm.Tag = fydjForm; Dictionary <string, object> setDatanew = new Dictionary <string, object>(); fydjForm.Tag = setDatanew; (fydjForm.ControlManager.Dao as 业务费用Dao).TransactionBeginning += new EventHandler <OperateArgs <费用> >(delegate(object sender, OperateArgs <费用> e) { if (e.Entity.费用实体 == null) { 业务费用 fy = e.Entity as 业务费用; fy.费用实体 = e.Repository.Get <费用实体>(setDatanew["费用实体"]); fy.费用项编号 = (string)setDatanew["费用项"]; fy.车辆产值 = fy.费用实体 as 车辆产值; } }); fydjForm.DisplayManager.SearchManager.EnablePage = false; fydjForm.DisplayManager.SearchManager.DataLoaded += new EventHandler <DataLoadedEventArgs>(delegate(object sender, DataLoadedEventArgs e) { fydjForm.TopMost = true; fydjForm.Show(); }); fydjForm.FormClosing += new FormClosingEventHandler(delegate(object sender, FormClosingEventArgs e) { if (e.CloseReason == CloseReason.UserClosing) { if (!masterForm.IsDisposed) { if (masterForm is ArchiveOperationForm) { (masterForm as ArchiveOperationForm).ControlManager.DisplayManager.SearchManager.ReloadItem((masterForm as ArchiveOperationForm).ControlManager.DisplayManager.Position); (masterForm as ArchiveOperationForm).ControlManager.OnCurrentItemChanged(); } e.Cancel = true; fydjForm.Hide(); } else { } } }); } Dictionary <string, object> setData = fydjForm.Tag as Dictionary <string, object>; setData.Clear(); // 票费用登记窗体 if (row.Cells["费用实体"] != null) { setData["费用实体"] = (Guid)row.Cells["费用实体"].Value; setData["费用项"] = (string)row.Cells["费用项"].Value; if (/*cell.FieldName == "已收金额" || cell.FieldName == "应收金额" || */ cell.FieldName == "拟收金额") { setData["收付标志"] = 收付标志.收; } else if (/*cell.FieldName == "已付金额" || cell.FieldName == "应付金额" || */ cell.FieldName == "拟付金额") { setData["收付标志"] = 收付标志.付; } } else { throw new ArgumentException("There must be a column named 费用实体!"); } //NameValueMappingCollection.Instance["信息_箱号_动态"].Params["@票"] = (Guid)setData["费用实体"]; //NameValueMappingCollection.Instance.Reload("信息_箱号_动态"); //Feng.Windows.Forms.MyObjectPicker op = (fydjForm.MasterGrid.GetInsertionRow().Cells["任务"].CellEditorManager as Feng.Grid.Editors.MyObjectPickerEditor).TemplateControl; //string exp = "车辆产值.ID = " + ((Guid)setData["费用实体"]).ToString(); //op.SearchExpressionParam = exp; Feng.Windows.Forms.MyObjectPicker op = (fydjForm.MasterGrid.Columns["任务"].CellEditorManager as Feng.Grid.Editors.MyObjectPickerEditor).TemplateControl; string exp = "车辆产值.ID = " + ((Guid)setData["费用实体"]).ToString(); op.SearchExpressionParam = exp; ISearchExpression se = SearchExpression.And(SearchExpression.Eq("费用实体.ID", (Guid)setData["费用实体"]), SearchExpression.Eq("费用项编号", (string)setData["费用项"])); if (setData.ContainsKey("收付标志")) { se = SearchExpression.And(se, SearchExpression.Eq("收付标志", setData["收付标志"])); } fydjForm.ControlManager.DisplayManager.SearchManager.LoadData(se, new List <ISearchOrder>()); } }
private void 承运时间要求详情_Load(object sender, EventArgs e) { using (IRepository rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <车辆作业>()) { var clzy = rep.Get <车辆作业>(m_clzy.ID); m_dm.SetDataBinding(new List <车辆作业> { clzy }, string.Empty); var dm = m_dm; // dm.DataControls["箱型编号"].SelectedDataValue = clzy.专家任务.任务[0].箱型编号; var list = m_任务集合区.DisplayManager.SearchManager.GetData(SearchExpression.Eq("专家任务:车辆作业", clzy), new List <ISearchOrder> { SearchOrder.Asc("任务性质") }); int idx = 0; List <Xceed.Grid.DataRow> realTimeRows = new List <Xceed.Grid.DataRow>(); Xceed.Grid.DataRow row; foreach (var i in list) { if (idx != 0) { m_任务集合区.AddSpaceDataRow(); } row = m_任务集合区.DataRows.AddNew(); m_任务集合区.SetDataRowsIListData(i, row); row.EndEdit(); row.Cells["序号"].Value = idx + 1; foreach (Xceed.Grid.Cell cell in row.Cells) { 单个作业监控详情.SetCellValueNone(cell); } row = m_任务集合区.DataRows.AddNew(); row.EndEdit(); realTimeRows.Add(row); row.ForeColor = System.Drawing.Color.Red; 单个作业监控详情.SetCellValueNone(row.Cells["疏港期限"]); 单个作业监控详情.SetCellValueNone(row.Cells["还箱进港时间"]); idx++; } FillRowsRealTimes(clzy, realTimeRows); switch (clzy.专家任务.任务性质) { case 专家任务性质.静态优化套箱: case 专家任务性质.动态优化套箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["装货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["还箱进港时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["疏港期限"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["卸货时间"]); break; case 专家任务性质.静态优化进口箱带货: case 专家任务性质.动态优化进口箱带货: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["装货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["提箱时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["还箱进港时间"]); break; case 专家任务性质.静态优化出口箱带货: case 专家任务性质.动态优化出口箱带货: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["卸货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["疏港期限"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["还箱进港时间"]); break; case 专家任务性质.静态优化进口箱对箱: case 专家任务性质.动态优化进口箱对箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["装货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["装货时间"]); break; case 专家任务性质.静态优化出口箱对箱: case 专家任务性质.动态优化出口箱对箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["卸货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["卸货时间"]); break; case 专家任务性质.静态优化进出口对箱: case 专家任务性质.动态优化进出口对箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["装货时间"]); 单个作业监控详情.SetCellValueNone(realTimeRows[1].Cells["卸货时间"]); break; case 专家任务性质.无优化进口拆箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["装货时间"]); break; case 专家任务性质.无优化出口装箱: 单个作业监控详情.SetCellValueNone(realTimeRows[0].Cells["卸货时间"]); break; case 专家任务性质.无优化I带货: break; case 专家任务性质.无优化E带货: break; } } }
private ISearchExpression ParseSimpleExpression() { string s1 = ParseWordExpression(); string s2; ISearchExpression exp; switch (this.token) { case TokenType.Eq: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Eq(s1, s2)); case TokenType.NotEq: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.NotEq(s1, s2)); case TokenType.EqProperty: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.EqProperty(s1, s2)); case TokenType.Gt: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Gt(s1, s2)); case TokenType.Ge: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Ge(s1, s2)); case TokenType.Lt: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Lt(s1, s2)); case TokenType.Le: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Le(s1, s2)); case TokenType.InG: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.InG(s1, GetArrayList(s2))); case TokenType.GInG: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.GInG(s1, GetArrayList(s2))); case TokenType.Like: this.MoveNext(); s2 = ParseWordExpression(); return(SearchExpression.Like(s1, s2)); case TokenType.IsNull: exp = SearchExpression.IsNull(s1); this.MoveNext(); return(exp); case TokenType.IsNotNull: exp = SearchExpression.IsNotNull(s1); this.MoveNext(); return(exp); case TokenType.Sql: exp = SearchExpression.Sql(s1); this.MoveNext(); return(exp); default: throw new ArgumentException("Invalid token of " + token); } }
private void 单个作业监控详情_Load(object sender, EventArgs e) { using (IRepository rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <车辆作业>()) { var clzy = rep.Get <车辆作业>(m_clzy.ID); m_dm.SetDataBinding(new List <车辆作业> { clzy }, string.Empty); m_任务集合1.DisplayManager.SearchManager.LoadData(SearchExpression.Eq("专家任务:车辆作业", clzy), new List <ISearchOrder> { SearchOrder.Asc("任务性质") }); m_任务集合1.DisplayManager.SearchManager.WaitLoadData(); m_任务集合2.DisplayManager.SearchManager.LoadData(SearchExpression.Eq("专家任务:车辆作业", clzy), new List <ISearchOrder> { SearchOrder.Asc("任务性质") }); m_任务集合2.DisplayManager.SearchManager.WaitLoadData(); List <Xceed.Grid.DataRow> realTimeRows = new List <Xceed.Grid.DataRow>(); foreach (Xceed.Grid.DataRow i in m_任务集合2.DataRows) { realTimeRows.Add(i); } int currentRowIdx = 承运时间要求详情.FillRowsRealTimes(clzy, realTimeRows); if (clzy.最新作业状态 != null) { Xceed.Grid.DataRow row = m_任务集合2.DataRows[currentRowIdx]; row.Cells["车辆位置"].Value = clzy.最新作业状态.车辆位置; row.Cells["作业状态"].Value = clzy.最新作业状态.作业状态; row.Cells["预计到达时间"].Value = clzy.最新作业状态.预计到达时间; row.Cells["异常情况"].Value = clzy.最新作业状态.异常情况; } switch (clzy.专家任务.任务性质) { case 专家任务性质.静态优化套箱: case 专家任务性质.动态优化套箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["装货时间"]); SetCellValueNone(m_任务集合2.DataRows[0].Cells["还箱进港时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["提箱时间"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系电话"]); break; case 专家任务性质.静态优化进口箱带货: case 专家任务性质.动态优化进口箱带货: SetCellValueNone(m_任务集合2.DataRows[0].Cells["装货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["提箱时间"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["还箱进港时间"]); break; case 专家任务性质.静态优化出口箱带货: case 专家任务性质.动态优化出口箱带货: SetCellValueNone(m_任务集合2.DataRows[0].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["提箱时间"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["还箱进港时间"]); break; case 专家任务性质.静态优化进口箱对箱: case 专家任务性质.动态优化进口箱对箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["装货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["装货时间"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["装货联系电话"]); break; case 专家任务性质.静态优化出口箱对箱: case 专家任务性质.动态优化出口箱对箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系电话"]); break; case 专家任务性质.静态优化进出口对箱: case 专家任务性质.动态优化进出口对箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["装货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系电话"]); SetCellValueNone(m_任务集合2.DataRows[1].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[1].Cells["卸货联系电话"]); break; case 专家任务性质.无优化进口拆箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["装货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["装货联系电话"]); break; case 专家任务性质.无优化出口装箱: SetCellValueNone(m_任务集合2.DataRows[0].Cells["卸货时间"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货地详细地址"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货时间要求"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系人"]); SetCellValueNone(m_任务集合1.DataRows[0].Cells["卸货联系电话"]); break; case 专家任务性质.无优化I带货: break; case 专家任务性质.无优化E带货: break; } } }