/// <summary>
/// 刷新数据
/// </summary>
private void RefreshControl()
{
if (!m_providerServer.GetAllBill(out m_queryResult, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
return;
}
m_queryResult.DataGridView = dataGridView1;
DataTable dt = m_queryResult.DataCollection.Tables[0];
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Refresh();
dataGridView1.Columns[0].Frozen = true;
dataGridView1.Columns[1].Frozen = true;
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="goods">物品信息</param>
void RefreshDataGridView(IEnumerable <View_S_MaterialListRejectBill> goods)
{
if (goods == null)
{
return;
}
this.dataGridView1.Visible = false;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter -= new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.DataSource = goods;
dataGridView1.Columns["单价"].Visible = false;
dataGridView1.Columns["金额"].Visible = false;
dataGridView1.Columns["总金额"].Visible = false;
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter += new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.Refresh();
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["退货单号"].Visible = false;
dataGridView1.Columns["物品ID"].Visible = false;
this.dataGridView1.Visible = true;
lblAmount.Text = goods.Count().ToString();
}
/// <summary>
/// 刷新订单信息DataGridView
/// </summary>
/// <param name="findStore"></param>
void RefreshOrderFormDataGridView()
{
string strSql = "select * from View_B_OrderFormInfo order by 订货日期 desc, 订单号 desc ";
DataTable dataSource = GlobalObject.DatabaseServer.QueryInfo(strSql);
dataGridView1.DataSource = dataSource;
// 添加数据定位控件
if (m_orderFormLocalizer == null)
{
m_orderFormLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
groupBoxOrderFormInfo.Controls.Add(m_orderFormLocalizer);
m_orderFormLocalizer.Dock = DockStyle.Bottom;
m_orderFormLocalizer.Visible = true;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Columns["权限控制用登录名"].Visible = false;
dataGridView1.Refresh();
}
/// <summary>
/// 刷新
/// </summary>
void RefreshDataGridView()
{
if (!m_attendanceServer.GetAllSummary(out m_queryResult, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
DataTable dt = m_queryResult.DataCollection.Tables[0];
DataTable dtTemp = dt.Clone();
DataRow[] dr = dt.Select("年份='" + numYear.Value + "'");
for (int i = 0; i < dr.Length; i++)
{
dtTemp.ImportRow(dr[i]);
}
dataGridView1.DataSource = dtTemp;
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Columns["部门编码"].Visible = false;
dataGridView1.Columns["序号"].Visible = false;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Refresh();
dataGridView1.Columns[0].Frozen = true;
dataGridView1.Columns[1].Frozen = true;
dataGridView1.Columns[2].Frozen = true;
}
/// <summary>
/// 窗体载入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FormChoseConfectAccessorySpecCode_Load(object sender, EventArgs e)
{
if (!m_choseConfectServer.GetAllChoseConfectTableHead(out m_findTable, out m_err))
{
MessageDialog.ShowErrorMessage(m_err);
return;
}
RefreshDataGridView(m_findTable);
for (int i = 2; i < dataGridView1.Columns.Count; i++)
{
dataGridView1.Columns[i].Visible = false;
}
ColumnWidthControl.SetDataGridView(this.Text, dataGridView1);
// 添加数据定位控件
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(
dataGridView1, this.Name, UniversalFunction.SelectHideFields(
this.Name, dataGridView1.Name, BasicInfo.LoginID));
panelTop.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
m_dataLocalizer.Visible = true;
}
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="goods">物品信息</param>
void RefreshDataGridView(DataTable goods)
{
if (goods == null)
{
return;
}
this.dataGridView1.Visible = false;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter -= new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.DataSource = goods; //GlobalObject.GeneralFunction.ConvertToDataTable<S_MaterialDetainList>(goods);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter += new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.Refresh();
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["扣货单号"].Visible = false;
dataGridView1.Columns["物品ID"].Visible = false;
this.dataGridView1.Visible = true;
lblAmount.Text = goods.Rows.Count.ToString();
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findPlanCostBill">计划金额信息</param>
void RefreshDataGridView(IQueryable <View_BASE_GoodsPlanCost> findPlanCostBill)
{
lblAmount.Text = findPlanCostBill.Count().ToString();
DataTable tempTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_BASE_GoodsPlanCost>(findPlanCostBill);
if (tempTable.Columns.Contains("单价"))
{
tempTable.Columns.Remove("单价");
}
if (tempTable.Columns.Contains("单位ID"))
{
tempTable.Columns.Remove("单位ID");
}
dataGridView1.DataSource = tempTable;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Refresh();
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
}
/// <summary>
/// 刷新
/// </summary>
/// <param name="source">数据集</param>
void RefreshDataGirdView(DataTable source)
{
m_dtDS = source;
m_lstFindField.Clear();
DataColumnCollection columns = source.Columns;
if (columns.Count > 0)
{
for (int i = 0; i < columns.Count; i++)
{
m_lstFindField.Add(columns[i].ColumnName);
}
}
dataGridView1.DataSource = source;
lbCount.Text = dataGridView1.Rows.Count.ToString();
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["物品ID"].Visible = false;
userControlDataLocalizer.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findAccessoryInfo">数据集合</param>
void RefreshDataGridView(IQueryable findAccessoryInfo)
{
dataGridView1.DataSource = findAccessoryInfo;
// 添加数据定位控件
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
m_dataLocalizer.OnlyLocalize = true;
panelPara.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
m_dataLocalizer.Visible = true;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Refresh();
}
/// <summary>
/// 刷新数据显示控件
/// </summary>
/// <param name="dt">数据源</param>
private void RefreshDataGridView(DataTable dt)
{
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Columns[6].Visible = false;
}
// 添加数据定位控件
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
panelTop.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
m_dataLocalizer.Visible = true;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
}
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="goods">物品信息</param>
void RefreshDataGridView(DataTable goods)
{
if (goods == null)
{
return;
}
this.dataGridView1.Visible = false;
this.dataGridView1.CellEnter -= new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.DataSource = goods;
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.CellEnter += new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.Refresh();
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["退货单号"].Visible = false;
dataGridView1.Columns["物品ID"].Visible = false;
this.dataGridView1.Visible = true;
if (goods.Rows.Count > 0)
{
lblAmount.Text = Convert.ToString(goods.Rows.Count);
}
else
{
lblAmount.Text = "0";
}
}
/// <summary>
/// 刷新
/// </summary>
void RefreshDataGridView()
{
m_list = m_offlineFailServer.GetBillByProductType(cmbQuery.Text);
dataGridView1.DataSource = GlobalObject.GeneralFunction.ConvertToDataTable(m_list);
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Refresh();
}
/// <summary>
/// 刷新
/// </summary>
private void RefreshDataGridView()
{
DataTable dt = m_LowestPriceServer.GetAllInfo();
if (dt != null)
{
dataGridView1.DataSource = dt;
dataGridView1.Columns["GoodsID"].Visible = false;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Columns["ClientID"].Visible = false;
dataGridView1.Columns["CommunicateID"].Visible = false;
}
static void Main()
{
try
{
//Application.ThreadException += new ThreadExceptionEventHandler(UIThreadException);
//Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException);
//AppDomain.CurrentDomain.UnhandledException +=
// new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);
// 虚拟打印机初始化
VirtualPrint.Init();
// 列宽控制类初始化
ColumnWidthControl.Init();
// 查询过滤器初始化
QueryFilterControl.Init();
GlobalObject.GlobalParameter.Init();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FormMain());
// 保存设置
ColumnWidthControl.Save();
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
}
/// <summary>
/// 窗体载入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FormGoods_Load(object sender, EventArgs e)
{
if (!m_storeServer.GetAllStore(null, true, out m_findStore, out m_err))
{
MessageDialog.ShowErrorMessage(m_err);
return;
}
RefreshDataGridView(m_findStore);
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
dataGridView1.Columns[i].Visible = false;
}
dataGridView1.Columns[1].Visible = true;
dataGridView1.Columns[2].Visible = true;
dataGridView1.Columns[3].Visible = true;
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
ColumnWidthControl.SetDataGridView(this.Text, dataGridView1);
// 添加数据定位控件
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(
dataGridView1, this.Name, UniversalFunction.SelectHideFields(
this.Name, dataGridView1.Name, BasicInfo.LoginID));
panelTop.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
m_dataLocalizer.Visible = true;
}
}
/// <summary>
/// 刷新
/// </summary>
private void RefreshDataGridView()
{
DataTable dt = m_dayBookServer.GetDayBookView(dtpSelectStar.Value.ToString(), dtpSelectEnd.Value.ToString());
dataGridView1.DataSource = dt;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Refresh();
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="goods">物品信息</param>
void RefreshDataGridView(IEnumerable <View_S_FrockInDepotGoodsBill> goods)
{
ClearControl();
if (goods == null)
{
return;
}
this.dataGridView1.Visible = false;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter -= new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.DataSource = goods; //GlobalObject.GeneralFunction.ConvertToDataTable<View_S_OrdinaryInDepotGoodsBill>(goods);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
this.dataGridView1.CellEnter += new DataGridViewCellEventHandler(this.dataGridView1_CellEnter);
dataGridView1.Refresh();
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["单据号"].Visible = false;
dataGridView1.Columns["库房代码"].Visible = false;
dataGridView1.Columns["物品类别"].Visible = false;
this.dataGridView1.Visible = true;
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findDepartmentBill">数据集</param>
void RefreshDataGridView(IQueryable findDepartmentBill)
{
dataGridView1.DataSource = findDepartmentBill;
//// 添加数据定位控件
//if (m_dataLocalizer == null)
//{
// m_dataLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name,
// UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
// panelPara.Controls.Add(m_dataLocalizer);
// m_dataLocalizer.OnlyLocalize = true;
// m_dataLocalizer.Dock = DockStyle.Bottom;
// m_dataLocalizer.Visible = true;
//}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Columns["五笔码"].Visible = false;
dataGridView1.Columns["拼音码"].Visible = false;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Refresh();
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findBill">数据集</param>
void RefreshDataGridView(IQueryResult findBill)
{
ClearForm();
dataGridView1.DataSource = GetDataSource(findBill);
if (dataGridView1.DataSource == null)
{
return;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
#region 隐藏不允许查看的列
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (findBill.HideFields.Contains(dataGridView1.Columns[i].Name))
{
dataGridView1.Columns[i].Visible = false;
}
}
#endregion
dataGridView1.Columns["申请人编码"].Visible = false;
dataGridView1.Columns["申请部门编码"].Visible = false;
dataGridView1.Columns["知会检验名编码"].Visible = false;
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
panelPara.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
}
dataGridView1.Refresh();
}
/// <summary>
/// 刷新
/// </summary>
void RefreshDataGridView()
{
m_overTimeServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text)
+ checkBillDateAndStatus1.GetSqlString("申请时间", "单据状态");
IQueryResult result;
if (!m_overTimeServer.GetAllOverTimeBill(out result, out error))
{
MessageDialog.ShowErrorMessage(error);
return;
}
//if (result.DataCollection.Tables[0].Rows.Count == 0)
//{
// if (!m_overTimeServer.GetAllOverTimeBillByWorkID(out result, out error))
// {
// MessageDialog.ShowErrorMessage(error);
// return;
// }
//}
dataGridView1.DataSource = result.DataCollection.Tables[0];
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Columns["员工编号"].Visible = false;
dataGridView1.Columns["部门编码"].Visible = false;
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
//dataGridView1.Refresh();
}
/// <summary>
/// 刷新DataGridView2
/// </summary>
void RefreshDataGridView2()
{
dataGridView2.DataSource = m_returnTable2;
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView2);
dataGridView2.Refresh();
}
/// <summary>
/// 刷新
/// </summary>
void RefreshControl()
{
ClearControl();
DataTable statusDt = m_laborServer.GetContractStatus();
if (statusDt.Rows.Count > 0)
{
for (int i = 0; i < statusDt.Rows.Count; i++)
{
cmbStatus.Items.Add(statusDt.Rows[i]["状态"].ToString());
}
}
if (!m_laborServer.GetAllPersonnelContarct(out m_queryResult, out error))
{
MessageDialog.ShowErrorMessage(error);
return;
}
DataTable dt = m_queryResult.DataCollection.Tables[0];
dataGridView1.DataSource = dt;
dataGridView1.Columns["员工编号"].Visible = false;
dataGridView1.Refresh();
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findStore">数据集</param>
void RefreshDataGridView(DataTable findStore)
{
if (findStore != null)
{
DataTable table = findStore.Copy();
dataGridView1.DataSource = table;
ColumnWidthControl.SetDataGridView(this.Text, dataGridView1);
dataGridView1.Refresh();
}
}
private void RefreshDataGridView(DataTable dt)
{
dataGridView1.DataSource = dt;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.dataGridView1_ColumnWidthChanged);
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, GlobalObject.BasicInfo.LoginID));
}
/// <summary>
/// 刷新数据控件
/// </summary>
/// <param name="dt"></param>
private void RefreshDataGridView(DataTable dt)
{
dataGridView1.DataSource = dt;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
}
/// <summary>
/// 刷新数据控件
/// </summary>
/// <param name="data">数据集</param>
private void RefreshDataGridView(IEnumerable <View_ZPX_CVTOffLineTestResult> data)
{
dataGridView1.DataSource = data.ToList();
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findStore">数据集</param>
void RefreshDataGridView(IQueryable findStore)
{
DataTable dt = GlobalObject.GeneralFunction.ConvertToDataTable(findStore);
DataTable dataSource = dt.Clone();
for (int i = 0; i < m_depotForPersonnel.Count; i++)
{
DataRow[] dr = dt.Select("仓库 = '" + m_depotForPersonnel[i].类型ID + "'");
if (dr.Length > 0)
{
for (int a = 0; a <= dr.Length - 1; a++)
{
dataSource.ImportRow(dr[a]);
}
}
}
dataGridView1.DataSource = dataSource;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.Columns["物品ID"].Visible = false;
dataGridView1.Columns["单位ID"].Visible = false;
if (dataGridView1.Rows.Count > 0)
{
panelTop.Visible = true;
if (m_dataLocalizer == null)
{
m_dataLocalizer = new UserControlDataLocalizer(
dataGridView1, this.Name, UniversalFunction.SelectHideFields(
this.Name, dataGridView1.Name, BasicInfo.LoginID));
panelTop.Controls.Add(m_dataLocalizer);
m_dataLocalizer.Dock = DockStyle.Bottom;
}
}
else
{
panelTop.Visible = false;
}
dataGridView1.Refresh();
}
/// <summary>
/// 刷新
/// </summary>
void RefreshControl()
{
ClearControl();
DataTable dt = m_leaveServer.GetAllLeaveType();
if (dt != null && dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
}
DataTable dtLeaveType = m_leaveServer.GetLeaveTypeByCode(null);
if (dtLeaveType != null && dtLeaveType.Rows.Count > 0)
{
for (int i = 0; i < dtLeaveType.Rows.Count; i++)
{
cmbParentTypeCode.Items.Add(dtLeaveType.Rows[i]["请假类别"].ToString());
}
}
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
// 添加查询用的列
if (m_findField == null)
{
List <string> lstColumnName = new List <string>();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible)
{
lstColumnName.Add(dataGridView1.Columns[i].Name);
}
}
m_findField = lstColumnName.ToArray();
}
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
dataGridView1.Refresh();
}
/// <summary>
/// 刷新DataGridView
/// </summary>
void RefreshDataGridView()
{
dataGridView1.DataSource = m_returnProductType;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Refresh();
}
/// <summary>
/// 刷新DataGridView
/// </summary>
/// <param name="findStore">数据集</param>
void RefreshDataGridView(IQueryable findClient)
{
dataGridView1.DataSource = findClient;
this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1);
this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(
this.dataGridView1_ColumnWidthChanged);
dataGridView1.Refresh();
}
