public static void InitDropDown(GDropDown control, string type, ISearch searchLogic, string vfield, string tfield)
{
control.ValueField = vfield;
control.TextField = tfield;
control.Logic = searchLogic;
foreach (ColumnInfo c in GetListColumns(type))
{
control.AddGridColumn(c.ColumnName, c.ColumnCaption, c.ColumnType, c.ColumnWidth);
}
control.GridEndInit();
}
public static void InitDropDown(GDropDown control, string type, ISearch searchLogic, bool isdefault)
{
control.Logic = searchLogic;
if (isdefault)
{
DefaultField(control, type);
}
foreach (ColumnInfo c in GetListColumns(type))
{
control.AddGridColumn(c.ColumnName, c.ColumnCaption, c.ColumnType, c.ColumnWidth);
}
control.GridEndInit();
}
public void InitFilter()
{
int left = 20;
int top = 15;
foreach (FilterInfo f in FilterInfos)
{
switch (f.controltype)
{
case "dropdown":
GDropDown controldrop = new GDropDown();
controldrop.Caption = f.caption;
controldrop.Location = new Point(left, top);
controldrop.Name = "dropdown_" + f.fieldname;
controldrop.Width = 200;
if (f.SearchForm != null)
{
controldrop.CustomerDropDownForm = f.SearchForm;
}
G.Controls.Base.Initialize.InitDropDown(controldrop, f.controldata, f.searchLogic, true);
if (!f.defaultvalue.IsNullOrEmpty())
{
controldrop.SetValue(f.defaultvalue);
}
this.tabPage1.Controls.Add(controldrop);
top += controldrop.Height + 10;
f.control = controldrop.Name;
break;
case "combox":
GCombo2 controlcombox = new GCombo2();
controlcombox.Caption = f.caption;
controlcombox.Data = f.controldata;
controlcombox.Name = "combox_" + f.fieldname;
controlcombox.Location = new Point(left, top);
controlcombox.Width = 200;
if (!f.defaultvalue.IsNullOrEmpty())
{
controlcombox.SetValue(f.defaultvalue);
}
this.tabPage1.Controls.Add(controlcombox);
top += controlcombox.Height + 10;
f.control = controlcombox.Name;
break;
case "checkbox":
GCheckBox controlcheckbox = new GCheckBox();
controlcheckbox.Caption = f.caption;
controlcheckbox.Name = "checkbox_" + f.fieldname;
controlcheckbox.Location = new Point(left, top);
controlcheckbox.Width = 200;
if (!f.defaultvalue.IsNullOrEmpty())
{
controlcheckbox.SetValue(f.defaultvalue);
}
this.tabPage1.Controls.Add(controlcheckbox);
top += controlcheckbox.Height + 10;
f.control = controlcheckbox.Name;
break;
case "date":
case "datetime":
GDate controldate = new GDate();
controldate.Caption = f.caption;
controldate.Name = "date_" + f.fieldname;
DefaultDate(f);
controldate.Width = 200;
controldate.Location = new Point(left, top);
if (!f.defaultvalue.IsNullOrEmpty())
{
controldate.SetValue(f.defaultvalue);
}
this.tabPage1.Controls.Add(controldate);
f.control = controldate.Name;
if (f.isdouble)
{
GDate controldate2 = new GDate();
controldate2.Caption = "一一";
controldate2.Name = "date2_" + f.fieldname;
controldate2.Location = new Point(left + controldate.Width + 20, top);
if (!f.defaultvalue2.IsNullOrEmpty())
{
controldate2.SetValue(f.defaultvalue2);
}
this.tabPage1.Controls.Add(controldate2);
f.control2 = controldate2.Name;
}
top += controldate.Height + 10;
break;
default:
GText controltext = new GText();
controltext.Caption = f.caption;
controltext.Name = "text_" + f.fieldname;
controltext.Location = new Point(left, top);
controltext.Width = 200;
if (!f.defaultvalue.IsNullOrEmpty())
{
controltext.SetValue(f.defaultvalue);
}
this.tabPage1.Controls.Add(controltext);
top += controltext.Height + 10;
f.control = controltext.Name;
break;
}
}
}
public Condition GetCondition()
{
Condition c = DefaultCondition;
foreach (FilterInfo f in FilterInfos)
{
string v = "", v2 = "";
switch (f.controltype)
{
case "dropdown":
GDropDown cd = this.tabPage1.Controls[f.control] as GDropDown;
v = G.Core.GConvert.ToString(cd.GetValue());
if (!v.IsNullOrEmpty())
{
if (f.islike)
{
c &= CK.K[f.fieldname].Like(v);
}
else
{
c &= CK.K[f.fieldname].Eq(v);
}
}
break;
case "combox":
GCombo2 cc = this.tabPage1.Controls[f.control] as GCombo2;
v = G.Core.GConvert.ToString(cc.GetValue());
if (!v.IsNullOrEmpty())
{
if (f.islike)
{
c &= CK.K[f.fieldname].Like(v);
}
else
{
c &= CK.K[f.fieldname].Eq(v);
}
}
break;
case "datetime":
GDate gdt = this.tabPage1.Controls[f.control] as GDate;
GDate gdt2 = this.tabPage1.Controls[f.control2] as GDate;
v = gdt.GetValue().ToShortDateTime();
if (!v.IsNullOrEmpty())
{
if (f.islike)
{
c &= CK.K[f.fieldname].Like(v);
}
else if (f.isdouble)
{
v2 = "";
object obj2 = gdt2.GetValue();
if (!obj2.Equals(DBNull.Value))
{
v2 = obj2.ToDateTime().AddDays(1).ToShortDateString();
}
c &= CK.K[f.fieldname].Ge(v);
c &= CK.K[f.fieldname].Le(v2);
}
else
{
string v3 = gdt.GetValue().ToDateTime().AddDays(1).ToShortDateString();
c &= CK.K[f.fieldname].Ge(v);
c &= CK.K[f.fieldname].Le(v3);
}
}
break;
case "date":
GDate gd = this.tabPage1.Controls[f.control] as GDate;
v = gd.GetValue().ToShortDateTime();
GDate gd2 = this.tabPage1.Controls[f.control2] as GDate;
v2 = gd2.GetValue().ToShortDateTime();
if (!v.IsNullOrEmpty())
{
if (f.islike)
{
c &= CK.K[f.fieldname].Like(v);
}
else if (f.isdouble)
{
c &= CK.K[f.fieldname].Ge(v);
c &= CK.K[f.fieldname].Le(v2);
}
else
{
c &= CK.K[f.fieldname].Eq(v);
}
}
break;
case "checkbox":
GCheckBox ccb = this.tabPage1.Controls[f.control] as GCheckBox;
v = G.Core.GConvert.ToString(ccb.GetValue());
if (!v.IsNullOrEmpty())
{
c &= CK.K[f.fieldname].Eq(v);
}
break;
default:
GText gt = this.tabPage1.Controls[f.control] as GText;
v = G.Core.GConvert.ToString(gt.GetValue());
if (!v.IsNullOrEmpty())
{
if (f.islike)
{
c &= CK.K[f.fieldname].Like(v);
}
else
{
c &= CK.K[f.fieldname].Eq(v);
}
}
break;
}
}
if (c == null)
{
c = Condition.Empty;
}
return(c);
}
private static void DefaultField(GDropDown control, string type)
{
string vfield = "", tfield = "";
bool istext = false;
switch (type.ToUpper())
{
case "CUSTOMER":
vfield = "ID";
tfield = "CUSTNAME";
break;
case "AREA":
vfield = "DQDM";
tfield = "DQNAME";
break;
case "ITEM":
vfield = "ITEMCODE";
tfield = "ITEMNAME";
break;
case "WAREHOUSE":
vfield = "WRHSCODE";
tfield = "WRHSNAME";
break;
case "LOCATION":
vfield = "LOCCODE";
tfield = "LOCNAME";
break;
case "USER":
vfield = "USERDM";
tfield = "USERNAME";
break;
case "COLOR":
vfield = "CCODE";
tfield = "CNAME";
break;
case "COLORNAME":
istext = true;
vfield = "COLORNAME";
tfield = "COLORNAME";
break;
case "MOULD":
vfield = "MDCODE";
tfield = "MDNAME";
break;
case "SUPPLIER":
vfield = "SUPPCODE";
tfield = "SUPPNAME";
break;
case "ORG":
vfield = "ORGDM";
tfield = "ORGNAME";
break;
case "PORDER":
vfield = "POID";
tfield = "POID";
break;
case "SALEORDER":
vfield = "ORDERID";
tfield = "ORDERID";
break;
case "ASSISTMS":
vfield = "ASSISTMSCODE";
tfield = "ASSISTMSCODE";
break;
case "ITEMTYPE":
vfield = "ID";
tfield = "ITEMTYPENAME";
break;
case "GX":
vfield = "ID";
tfield = "GXNAME";
break;
}
control.IsText = istext;
control.ValueField = vfield;
control.TextField = tfield;
}
