private void BindCountryBrandData()
{
//cmbBand.DataSource = null;
if (cmbProvince.SelectedValue == null)
{
return;
}
string pcode = cmbProvince.SelectedValue.ToString();
FishEntity.DictEntity pModel = InitDataUtil.DictList.Find((i) => { return(i.code == pcode && i.pcode.Equals(FishEntity.Constant.Province)); });
int pid = 0;
if (pModel != null)
{
pid = pModel.id;
}
List <FishEntity.DictEntity> list = InitDataUtil.DictList.FindAll((i) => { return(i.pid == pid && i.pcode.Equals(FishEntity.Constant.Area)); });
if (list == null)
{
list = new List <FishEntity.DictEntity>();
}
FishEntity.DictEntity empty = new FishEntity.DictEntity();
empty.code = "";
empty.name = "";
list.Insert(0, empty);
cmbArea.ValueMember = "code";
cmbArea.DisplayMember = "name";
cmbArea.DataSource = list;
}
public string GetQueryCondition()
{
string where = "1=1";
if (string.IsNullOrEmpty(txtcode.Text) == false)
{
where += string.Format(" and code like '%{0}%'", txtcode.Text.Trim());
}
if (string.IsNullOrEmpty(txtfullname.Text) == false)
{
where += string.Format(" and fullname like '%{0}%'", txtfullname.Text.Trim());
}
if (string.IsNullOrEmpty(txtShortName.Text) == false)
{
where += string.Format(" and shortname like'%{0}%'", txtShortName.Text.Trim());
}
string orwhere = string.Empty;
foreach (UILibrary.CheckBoxComboBox.CheckBoxComboBoxItem item in cmbType.CheckBoxItems)
{
if (item.Checked)
{
FishEntity.DictEntity kv = ((UILibrary.CheckBoxComboBox.ObjectSelectionWrapper <FishEntity.DictEntity>)item.ComboBoxItem).Item;
if (String.IsNullOrEmpty(orwhere) == false)
{
orwhere += " or ";
}
orwhere += kv.code.Equals("供应商") ? " type_suppliers = 1" : "";
orwhere += kv.code.Equals("代理商") ? " type_agents = 1" : "";
orwhere += kv.code.Equals("客户") ? " type_customer=1" : "";
orwhere += kv.code.Equals("贸易商") ? " type_merchants=1" : "";
orwhere += kv.code.Equals("货代商") ? " type_goods=1" : "";
orwhere += kv.code.Equals("报盘商") ? " type_quote=1" : "";
}
}
if (string.IsNullOrEmpty(orwhere) == false)
{
where += " and ( " + orwhere + " ) ";
}
if (null != cmbGenerallevel.SelectedValue && false == string.IsNullOrEmpty(cmbGenerallevel.SelectedValue.ToString()))
{
where += string.Format(" and generallevel ='{0}'", cmbGenerallevel.SelectedValue.ToString());
}
if (null != cmbProvince.SelectedValue && false == string.IsNullOrEmpty(cmbProvince.SelectedValue.ToString()))
{
where += string.Format(" and province ='{0}'", cmbProvince.SelectedValue.ToString());
}
if (null != cmbArea.SelectedValue && false == string.IsNullOrEmpty(cmbArea.SelectedValue.ToString()))
{
where += string.Format(" and zone ='{0}'", cmbArea.SelectedValue.ToString());
}
if (null != cmbCreditlevel.SelectedValue && false == string.IsNullOrEmpty(cmbCreditlevel.SelectedValue.ToString()))
{
where += string.Format(" and creditlevel ='{0}'", cmbCreditlevel.SelectedValue.ToString());
}
if (null != cmbrequiredlevel.SelectedValue && false == string.IsNullOrEmpty(cmbrequiredlevel.SelectedValue.ToString()))
{
where += string.Format(" and requiredlevel ='{0}'", cmbrequiredlevel.SelectedValue.ToString());
}
if (null != cmbManageSpecificate.SelectedValue && false == string.IsNullOrEmpty(cmbManageSpecificate.SelectedValue.ToString()))
{
where += string.Format(" and managestandard ='{0}'", cmbManageSpecificate.SelectedValue.ToString());
}
if (null != cmbactivelevel.SelectedValue && false == string.IsNullOrEmpty(cmbactivelevel.SelectedValue.ToString()))
{
where += string.Format(" and activelevel ='{0}'", cmbactivelevel.SelectedValue.ToString());
}
if (null != cmbloyalty.SelectedValue && false == string.IsNullOrEmpty(cmbloyalty.SelectedValue.ToString()))
{
where += string.Format(" and loyalty ='{0}'", cmbloyalty.SelectedValue.ToString());
}
if (null != cmbproducts.SelectedValue && false == string.IsNullOrEmpty(cmbproducts.SelectedValue.ToString()))
{
where += string.Format(" and products ='{0}'", cmbproducts.SelectedValue.ToString());
}
if (false == string.IsNullOrEmpty(txtsalesman.Text))
{
where += string.Format(" and salesman like'%{0}%'", txtsalesman.Text.Trim());
}
if (false == string.IsNullOrEmpty(txtarea.Text))
{
where += string.Format(" and area like'%{0}%'", txtarea.Text.Trim());
}
if (false == string.IsNullOrEmpty(txtaddress.Text))
{
where += string.Format(" and address like'%{0}%'", txtaddress.Text.Trim());
}
if (null != cmbNature.SelectedValue && false == string.IsNullOrEmpty(cmbNature.SelectedValue.ToString()))
{
where += string.Format(" and nature ='{0}'", cmbNature.SelectedValue.ToString());
}
if (null != cmbmanageprojects.SelectedValue && false == string.IsNullOrEmpty(cmbmanageprojects.SelectedValue.ToString()))
{
where += string.Format(" and manageprojects ='{0}'", cmbmanageprojects.SelectedValue.ToString());
}
if (false == string.IsNullOrEmpty(txtregistermoney.Text))
{
where += string.Format(" and registermoney like '%{0}%'", txtregistermoney.Text.Trim());
}
if (false == string.IsNullOrEmpty(txtzip.Text))
{
where += string.Format(" and zip like '%{0}%'", txtzip.Text.Trim());
}
if (false == string.IsNullOrEmpty(txtfox.Text))
{
where += string.Format(" and fox like '%{0}%'", txtfox.Text.Trim());
}
if (null != cmbCustomerProperty.SelectedValue && false == string.IsNullOrEmpty(cmbCustomerProperty.SelectedValue.ToString()))
{
where += string.Format(" and customerproperty ='{0}'", cmbCustomerProperty.SelectedValue.ToString());
}
if (false == string.IsNullOrEmpty(txtCustomerGroup.Text))
{
where += string.Format(" and customergroup like '%{0}%'", txtCustomerGroup.Text.Trim());
}
if (false == string.IsNullOrEmpty(txtlinkman.Text))
{
where += string.Format(" and linkman like '%{0}%'", txtlinkman.Text.Trim());
}
return(where);
}
protected string GetQueryCondition()
{
string where = "1=1";
//if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan))
//{//控制权限
// where += string.Format(" and salesmancode ='{0}'", FishEntity.Variable.User.id);
//}
//if (string.IsNullOrEmpty(cmbType.SelectedText)==false)
//{
//}
if (string.IsNullOrEmpty(txtcode.Text) == false)
{
where += string.Format(" and code like '%{0}%'", txtcode.Text.Trim());
}
if (string.IsNullOrEmpty(txtfullname.Text) == false)
{
where += string.Format(" and fullname like '%{0}%'", txtfullname.Text.Trim());
}
if (string.IsNullOrEmpty(txtShortName.Text) == false)
{
where += string.Format(" and shortname like'%{0}%'", txtShortName.Text.Trim());
}
if (null != cmbProvince.SelectedValue && false == string.IsNullOrEmpty(cmbProvince.SelectedValue.ToString()))
{
where += string.Format(" and province ='{0}'", cmbProvince.SelectedValue.ToString());
}
if (null != cmbArea.SelectedValue && false == string.IsNullOrEmpty(cmbArea.SelectedValue.ToString()))
{
where += string.Format(" and zone ='{0}'", cmbArea.SelectedValue.ToString());
}
foreach (UILibrary.CheckBoxComboBox.CheckBoxComboBoxItem item in cmbType.CheckBoxItems)
{
if (item.Checked)
{
FishEntity.DictEntity kv = ((UILibrary.CheckBoxComboBox.ObjectSelectionWrapper <FishEntity.DictEntity>)item.ComboBoxItem).Item;
where += kv.code.Equals("国内供应商") ? " and type_suppliers = 1" : "";
where += kv.code.Equals("代理商") ? " and type_agents = 1" : "";
where += kv.code.Equals("客户") ? " and type_customer=1" : "";
where += kv.code.Equals("贸易商") ? " and type_merchants=1" : "";
where += kv.code.Equals("货代商") ? " and type_goods=1" : "";
where += kv.code.Equals("报盘商") ? " and type_quote=1" : "";
where += kv.code.Equals("物流运输") ? " and Logistics=1" : "";
}
}
if (cmbGenerallevel.SelectedValue != null && cmbGenerallevel.SelectedValue.ToString() != string.Empty)
{
where += string.Format(" and generallevel='" + cmbGenerallevel.SelectedValue.ToString() + "'");
}
if (cmbCreditlevel.SelectedValue != null && string.IsNullOrEmpty(cmbCreditlevel.SelectedValue.ToString()) == false)
{
where += string.Format(" and creditlevel='" + cmbCreditlevel.SelectedValue.ToString() + "'");
}
if (string.IsNullOrEmpty(txtarea.Text) == false)
{
where += string.Format(" and area like'%" + txtarea.Text.Trim() + "%'");
}
if (string.IsNullOrEmpty(txtaddress.Text) == false)
{
where += string.Format(" and address like'%" + txtaddress.Text.Trim() + "%'");
}
if (cmbmanageprojects.SelectedValue != null && string.IsNullOrEmpty(cmbmanageprojects.SelectedValue.ToString()) == false)
{
where += string.Format(" and manageprojects ='" + cmbmanageprojects.SelectedValue.ToString() + "'");
}
if (cmbTheperson.SelectedValue.ToString() != "")
{
where += string.Format(" and createman='{0}' ", cmbTheperson.SelectedValue.ToString());
}
if (string.IsNullOrEmpty(txtzip.Text) == false)
{
where += string.Format(" and zip like '%" + txtzip.Text.Trim() + "%'");
}
if (string.IsNullOrEmpty(txtfox.Text) == false)
{
where += string.Format(" and fox like '%" + txtfox.Text.Trim() + "%'");
}
if (cmbCustomerProperty.SelectedValue != null && string.IsNullOrEmpty(cmbCustomerProperty.SelectedValue.ToString()) == false)
{
where += string.Format(" and customerproperty ='" + cmbCustomerProperty.SelectedValue.ToString() + "'");
}
if (string.IsNullOrEmpty(txtCustomerGroup.Text) == false)
{
where += string.Format(" and customergroup like '%" + txtCustomerGroup.Text.Trim() + "%'");
}
return(where);
}
