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;
}
