protected void SupplierBtnClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
string strSQL = "select F_ID,F_Name from t_Supplier";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
myControl.frmDataList myDataList = new myControl.frmDataList();
myDataList.gcQuery.DataSource = ds.Tables[0].DefaultView;
myDataList.keyField = "F_ID";
myDataList.DisplayField = "F_Name";
myDataList.gvQuery.Columns.ColumnByFieldName("F_ID").Caption = "编码";
myDataList.gvQuery.Columns.ColumnByFieldName("F_ID").Width = 100;
myDataList.gvQuery.Columns.ColumnByFieldName("F_Name").Caption = "名称";
myDataList.gvQuery.Columns.ColumnByFieldName("F_Name").Width = 150;
if (myDataList.ShowDialog() == DialogResult.OK)
{
DataRow dr = myDataList.gvQuery.GetDataRow(myDataList.gvQuery.FocusedRowHandle);
DataRow drDes = gvBase.GetDataRow(gvBase.FocusedRowHandle);
drDes["F_SupplierID"] = dr["F_ID"];
drDes["F_Supplier"] = dr["F_Name"];
gvBase.UpdateCurrentRow();
}
myDataList.Dispose();
}
private void sbSel_Click(object sender, EventArgs e)
{
myControl.frmDataList F = new myControl.frmDataList();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select F_ID,F_Name,(case isnull(F_Login,0) when 0 then '离线' else '在线' end) as F_Flag from t_User");
F.gcQuery.DataSource = ds.Tables[0].DefaultView;
F.keyField = "F_ID";
F.DisplayField = "F_Name";
F.gvQuery.Columns["F_ID"].Caption = "用户编码";
F.gvQuery.Columns["F_Name"].Caption = "用户名称";
F.gvQuery.Columns["F_Flag"].Caption = "状态";
F.gvQuery.OptionsSelection.MultiSelect = true;
if (F.ShowDialog() == DialogResult.OK)
{
int[] iRows = F.gvQuery.GetSelectedRows();
foreach (int i in iRows)
{
DataRow dr = F.gvQuery.GetDataRow(i);
DataRow drEmp = ((DataRowView)binEmp.AddNew()).Row;
drEmp["Aid"] = ((DataRowView)binData.Current).Row["Aid"];
drEmp["F_EmpID"] = dr["F_ID"];
drEmp["F_EmpName"] = dr["F_Name"];
}
binEmp.EndEdit();
}
F.Dispose();
}
private void btnAdd_Click(object sender, EventArgs e)
{
myControl.frmDataList myDataList = new myControl.frmDataList();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select a.F_ID,a.F_Name,b.F_Name as F_Dept,dbo.fn_GetPy(a.F_Name) as F_Spell from t_Emp a left join t_Class b on a.F_Type = b.F_ID");
myDataList.gcQuery.DataSource = ds.Tables[0].DefaultView;
myDataList.strDisplayCaption = "员工编号,员工名称,部门,拼音码";
myDataList.keyField = "F_ID";
myDataList.DisplayField = "F_Name";
myDataList.sbNew.Visible = false;
myDataList.gvQuery.OptionsSelection.MultiSelect = true;
if (myDataList.ShowDialog() == DialogResult.OK)
{
int[] Rows = myDataList.gvQuery.GetSelectedRows();
DataTable dt = (DataTable)gridEmp.DataSource;
foreach (int i in Rows)
{
DataRow dr = myDataList.gvQuery.GetDataRow(i);
if (dt.Select("F_ID = '" + dr["F_ID"].ToString() + "'").Length > 0)
{
continue;
}
DataRow drNew = dt.NewRow();
drNew["F_ID"] = dr["F_ID"];
drNew["F_Name"] = dr["F_Name"];
drNew["F_Dept"] = dr["F_Dept"];
dt.Rows.Add(drNew);
}
}
myDataList.Dispose();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string strSQL = "select F_ID,F_Name from t_Emp";
DataTable dt = ((DataView)gcEmp.DataSource).Table;
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
myControl.frmDataList F = new myControl.frmDataList();
F.sbNew.Visible = false;
F.gcQuery.DataSource = ds.Tables[0].DefaultView;
if (F.ShowDialog() == DialogResult.OK)
{
DataRow dr = F.gvQuery.GetDataRow(F.gvQuery.FocusedRowHandle);
DataRow drNew = dt.NewRow();
drNew["F_EmpID"] = dr["F_ID"];
drNew["F_Name"] = dr["F_Name"];
dt.Rows.Add(drNew);
}
F.Dispose();
}