public void Load(Param aPrm) { this.Items.Clear(); try { string[] ssSQL = aPrm.SelectValue.Split(";".ToCharArray()); int wasCount = 0; for (int ii = 0; ii < ssSQL.Length; ii++) { if (ssSQL[ii].Trim().Length == 0) continue; OleDbCommand cmd = mPerf.pWDB.NewOleDbCommand(ssSQL[ii].Trim()); if (BeforeFill != null) BeforeFill(this, new EventArgs()); /// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! /// BeforeExecute(); !!!!!!!!!!!!!!!!!!!!!!!!!!!! /// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! mPerf.QueryParam(cmd); wasCount = this.Items.Count; mFillListFromDB(cmd); if (this.Items.Count > wasCount) { mSetCurrent(aPrm); } else #region если список пуст, то попытаемся разобрать его по строчно !!! { try { mFillListFromText(ssSQL[ii]); wasCount = this.Items.Count; if (this.Items.Count > wasCount) { mSetCurrent(aPrm); } } catch { this.Items.Clear(); } } #endregion } } #if DEBUG catch (Exception ex) { MessageBox.Show(ex.Message); } #else catch { } #endif }
public override void SetParam(PCTVItemData aTID, Param aPrm) { //if (aTID != null) // aPrm.CurrentValue = aTID.pPC.code.ToString(); //else // aPrm.CurrentValue = "0"; /// Modified by M.Tor 25.06.2008: if (aTID != null) aPrm.CurrentValue = aTID.pPC.code.ToString() + PlaceCode.DELIM.ToString() + aTID.pText; else aPrm.CurrentValue = "0:"; }
protected ArrayList mGetQueryParamCol(Query aQr, ArrayList aParamOptions) { ArrayList locParamCol = new ArrayList(16); Param pp; if (aQr != null) foreach (Param prm in aQr.Params) { pp = new Param(); pp.CurrentValue = prm.CurrentValue; pp.Name = prm.Name; pp.Type = prm.Type; pp.Inset = prm.Inset; //pp.SelectValue = prm.SelectValue; //pp.Title = prm.Title; locParamCol.Add(pp); } if (pCommonParamCollection != null) foreach (Param prm in pCommonParamCollection) { pp = new Param(); pp.CurrentValue = prm.CurrentValue; pp.Name = prm.Name; pp.Type = prm.Type; pp.Inset = prm.Inset; locParamCol.Add(pp); } if (aParamOptions != null) foreach (Param prm in aParamOptions) { pp = new Param(); pp.CurrentValue = prm.CurrentValue; pp.Name = prm.Name; pp.Type = prm.Type; pp.Inset = prm.Inset; locParamCol.Add(pp); } return locParamCol; }
/// <summary> /// Устанавливает значение/тип параметра, если нет, создает и добавляет в коллекцию. /// </summary> /// <param name="aName">Имя параметра.</param> /// <param name="aType">Тип параметра.</param> /// <param name="aVal">Значение параметра.</param> public void SetCommonParamVal(string aName, eQueryParamType aType, string aVal) { if (mSes == null) return; Param curParam = null; foreach (Param prm in mSes.Params) if (prm.Name.Equals(aName)) curParam = prm; if (curParam == null) { curParam = new Param(); curParam.Name = aName; mSes.Params.Add(curParam); } curParam.Type = aType; curParam.CurrentValue = aVal; }
public void SaveToCollection() { if (_params == null) return; _dt.AcceptChanges(); _params.Clear(); Param prm; DataView dv = _dt.DefaultView; DataRowView dr; for (int ii = 0; ii < dv.Count; ii++) { dr = dv[ii]; prm = new Param(); prm.Number = CASTools.ConvertToInt32Or0(dr["Number"]); prm.Title = dr["Title"].ToString(); prm.Name = dr["Name"].ToString(); try { prm.Type = (eQueryParamType)dr["Type"]; } catch { } prm.Inset = Convert.ToBoolean(dr["Inset"]); prm.DefaultValue = dr["DefaultValue"].ToString(); prm.CurrentValue = dr["CurrentValue"].ToString(); prm.SelectValue = dr["SelectValue"].ToString(); _params.Add(prm); } }
public abstract void SetParam(Param aPrm);
protected override void mSetCurrent(Param aPrm) { if (aPrm.CurrentValue.Length > 0) this.SelectedItem = aPrm.CurrentValue; }
public override void SetParam(Param aPrm) { _ListBoxTextItem si = this.SelectedItem as _ListBoxTextItem; if (si != null) aPrm.CurrentValue = si.pTextText; else aPrm.CurrentValue = string.Empty; }
protected override void mSetCurrent(Param aPrm) { PlaceCode pc = aPrm.ValPC; if (pc.IsDefined) CommonListComboBox.SelectPC(this, pc); }
public override void SetParam(Param aPrm) { _ListBoxPCItem si = this.SelectedItem as _ListBoxPCItem; if (si != null) aPrm.CurrentValue = si.pPCText; else aPrm.CurrentValue = PlaceCode.PlaceCode2PDC(PlaceCode.Empty); }
protected override void mSetCurrent(Param aPrm) { int code = aPrm.ValInt; if (code > 0) CommonListComboBox.SelectCode(this, code); }
public override void SetParam(Param aPrm) { _ListBoxItem si = this.SelectedItem as _ListBoxItem; if (si != null) aPrm.CurrentValue = si.pCodeText; else aPrm.CurrentValue = "0"; }
protected abstract void mSetCurrent(Param aPrm);
public abstract void SetParam(PCTVItemData aTID, Param aPrm);
public Param GetParamValue(TreeNode aTn, string aName) { if (aTn == null) return null; PCTVItemData tid = aTn.Tag as PCTVItemData; if (tid == null) return null; int ii = 0; foreach (Param prm in mLocParams) { if (prm.Name.Equals(aName) && ii < tid.pLPA.Count) { Param retPrm = new Param(); retPrm.Type = prm.Type; if (prm.Type == eQueryParamType.Integer) retPrm.ValInt = (int)tid.pLPA[ii]; else if (prm.Type == eQueryParamType.Date) retPrm.ValDate = (DateTime)tid.pLPA[ii]; else retPrm.ValStr = (string)tid.pLPA[ii]; return retPrm; } ii++; } return null; }