private void _gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
// if (SelectRowChanged != null)
// SelectRowChanged(sender, e);
DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
if (SelectRow != null)
{
SelectRow(view.GetFocusedDataSourceRowIndex());
}
}
private void txtValueText_TextChanged(object sender, EventArgs e)
{
try
{
txtDisplayText.Text = "";
string sSql = "";
//if (EditValue != "" && EditValue!="0")
if (EditValue != "")
{
//sSql = "SELECT A." + DisplayField + " FROM (" + SQL + ") A WHERE " + DataField + "='" + EditValue + "'";
//sSql = "SELECT A.*" + " FROM (" + SQL + ") A WHERE " + DataField + "='" + EditValue + "'";
if (SearchFormFilter != "" && SearchFormFilter != null)
{
sSql = "SELECT A.* FROM (" + SQL + ") A WHERE " + SearchFormFilter;
}
else
{
sSql = SQL;
}
//DataTable dt = BWS.ERP.DataAccess.DbHelperSQL.Query(sSql).Tables[0];
DataRow[] dr = BWS.ERP.DataAccess.DbHelperSQL.Query(sSql).Tables[0].Select(DataField + "='" + EditValue + "'");
//if (dt.Rows.Count > 0)
if (dr.Length > 0)
{
//txtDisplayText.Text = dt.Rows[0][DisplayField].ToString();
txtDisplayText.Text = dr[0][DisplayField].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)
{
//先要设置控件绑定的值,在设置自动赋值的字段
((DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][this.DataBindings[0].BindingMemberInfo.BindingField] = EditValue;
((DataTable)(((System.Windows.Forms.BindingSource)(this.DataBindings[0].DataSource)).DataSource)).Rows[gvTemp.GetFocusedDataSourceRowIndex()][LAutoSetFields[i]] = dr[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]] = dr[0][LAutoSetValueFields[i]];
((DataSet)(this.DataBindings[0].DataSource)).Tables[0].AcceptChanges();
}
}
}
}
}
catch (Exception)
{
}
}
