/// <summary>
/// LookUp查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void LookUpSelfClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
string sql = "";
//检测SQL设置
if (SQL == null || SQL == "")
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置SQL属性！", true);
return;
}
if (IsSearchFormEdit)
{
if (EditFormName == null || EditFormName == "")
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置EditFormName属性！", true);
return;
}
if (EditFormID == 0)
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置EditFormID属性！", true);
return;
}
}
if (LookUpBeforePost != null)
{
if (!LookUpBeforePost(sender, e))
{
return;
}
}
if (SearchFormFilter != "" && SearchFormFilter != null)
{
sql = "SELECT A.* FROM (" + SQL + ") A WHERE " + SearchFormFilter;
}
else
{
sql = SQL;
}
frmLookUpSearch frm = new frmLookUpSearch(sql, GridColumnText, GridDisplayField, SearchFormText, IsMultiSelect, IsSearchFormEdit, EditFormName, EditFormFilter, EditFormID);
if (IsMultiSelect)
{
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.ReturnData != null)
{
if (frm.ReturnData.Rows.Count > 0)
{
//选择的结果
_dt = frm.ReturnData;
if (LookUpAfterPost != null)
{
if (!LookUpAfterPost(sender, e))
{
return;
}
}
}
}
}
}
else
{
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.ReturnData != null)
{
if (frm.ReturnData.Rows.Count == 1)
{
//选择的结果
_dt = frm.ReturnData;
txtDisplayText.Focus();
txtValueText.Text = _dt.Rows[0][DataField].ToString();
//for (int i = 0; i < LAutoSetControl.ToArray().Length; i++)
//{
// LAutoSetControl[i].Focus();
// LAutoSetControl[i].Text = _dt.Rows[0][LAutoSetValueFields[i]].ToString();
//}
//for (int i = 0; i < LAutoSetFields.ToArray().Length; i++)
//{
// gvTemp.Focus();
// if (this.DataBindings[0].DataSource is System.Windows.Forms.BindingSource)
// {
// //先要设置控件绑定的值,在设置自动赋值的字段
// ((System.Data.DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][this.DataBindings[0].BindingMemberInfo.BindingField] = EditValue;
// ((System.Data.DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][LAutoSetFields[i]] = _dt.Rows[0][LAutoSetValueFields[i]];
// //((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).EndEdit();
// }
// else
// {
// ((DataSet)(this.DataBindings[0].DataSource)).Tables[0].Rows[gvTemp.GetFocusedDataSourceRowIndex()][this.DataBindings[0].BindingMemberInfo.BindingField] = EditValue;
// ((DataSet)(this.DataBindings[0].DataSource)).Tables[0].Rows[gvTemp.GetFocusedDataSourceRowIndex()][LAutoSetFields[i]] = _dt.Rows[0][LAutoSetValueFields[i]];
// }
//}
if (LookUpAfterPost != null)
{
if (!LookUpAfterPost(sender, e))
{
return;
}
}
}
}
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// LookUp查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void LookUpSelfClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
string sql = "";
//检测SQL设置
if (SQL == null || SQL == "")
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置SQL属性！", true);
return;
}
if (IsSearchFormEdit)
{
if (EditFormName == null || EditFormName == "")
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置EditFormName属性！", true);
return;
}
if (EditFormID == 0)
{
BWS.ERP.BaseControl.Public.SystemInfo("LookUp尚未设置EditFormID属性！", true);
return;
}
}
if (LookUpBeforePost != null)
{
if (!LookUpBeforePost(sender, e))
{
return;
}
}
if (SearchFormFilter != "" && SearchFormFilter != null)
{
sql = "SELECT A.* FROM (" + SQL + ") A WHERE " + SearchFormFilter;
}
else
{
sql = SQL;
}
frmLookUpSearch frm = new frmLookUpSearch(sql, GridColumnText, GridDisplayField, SearchFormText, IsMultiSelect, IsSearchFormEdit, EditFormName, EditFormFilter, EditFormID);
if (IsMultiSelect)
{
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.ReturnData != null)
{
if (frm.ReturnData.Rows.Count > 0)
{
//选择的结果
_dt = frm.ReturnData;
if (LookUpAfterPost != null)
{
if (!LookUpAfterPost(sender, e))
{
return;
}
}
}
}
}
}
else
{
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.ReturnData != null)
{
if (frm.ReturnData.Rows.Count == 1)
{
//选择的结果
_dt = frm.ReturnData;
txtDisplayText.Focus();
txtValueText.Text = _dt.Rows[0][DataField].ToString();
//for (int i = 0; i < LAutoSetControl.ToArray().Length; i++)
//{
// LAutoSetControl[i].Focus();
// LAutoSetControl[i].Text = _dt.Rows[0][LAutoSetValueFields[i]].ToString();
//}
//for (int i = 0; i < LAutoSetFields.ToArray().Length; i++)
//{
// gvTemp.Focus();
// if (this.DataBindings[0].DataSource is System.Windows.Forms.BindingSource)
// {
// //先要设置控件绑定的值,在设置自动赋值的字段
// ((System.Data.DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][this.DataBindings[0].BindingMemberInfo.BindingField] = EditValue;
// ((System.Data.DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][LAutoSetFields[i]] = _dt.Rows[0][LAutoSetValueFields[i]];
// //((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).EndEdit();
// }
// else
// {
// ((DataSet)(this.DataBindings[0].DataSource)).Tables[0].Rows[gvTemp.GetFocusedDataSourceRowIndex()][this.DataBindings[0].BindingMemberInfo.BindingField] = EditValue;
// ((DataSet)(this.DataBindings[0].DataSource)).Tables[0].Rows[gvTemp.GetFocusedDataSourceRowIndex()][LAutoSetFields[i]] = _dt.Rows[0][LAutoSetValueFields[i]];
// }
//}
if (LookUpAfterPost != null)
{
if (!LookUpAfterPost(sender, e))
{
return;
}
}
}
}
}
}
}
catch (Exception)
{
}
}
