/// <summary> /// 获取供应商信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetProviderInfoDialog(string strType) { IProviderServer m_providerServer = ServerModuleFactory.GetServerModule <IProviderServer>(); IQueryable <View_Provider> queryResult; if (!m_providerServer.GetAllProvider(out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } queryResult = from r in queryResult where r.是否在用 == true select r; switch (strType) { case "零件合格供应商": queryResult = from r in queryResult where r.零星采购供应商 == false select r; break; default: break; } System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_Provider>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); return(form); }
/// <summary> /// 窗体载入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UserControlProviderInfo_Load(object sender, EventArgs e) { if (!m_providerServer.GetAllProvider(out m_findProvider, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return; } cmbYear.SelectedIndex = -1; cmbMonth.SelectedIndex = -1; RefreshDataGridView(m_findProvider); txtCode.Focus(); FaceAuthoritySetting.SetVisibly(toolStrip1, BasicInfo.GetFunctionTreeNodeInfo(labelTitle.Text).Authority); RefreshControl(); }
/// <summary> /// 窗体载入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FormProvider_Load(object sender, EventArgs e) { if (!m_providerServer.GetAllProvider(out m_findProvider, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return; } RefreshDataGridView(m_findProvider); dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[2].Visible = false; }
/// <summary> /// 获取供应商信息对话框 /// </summary> /// <returns>成功则返回获取到的对话框,失败返回null</returns> static public FormQueryInfo GetProviderInfoDialog() { IProviderServer m_providerServer = ServerModuleFactory.GetServerModule <IProviderServer>(); IQueryable <View_Provider> queryResult; DepotManagementDataContext ctx = CommentParameter.DepotDataContext; if (!m_providerServer.GetAllProvider(out queryResult, out m_err)) { MessageDialog.ShowErrorMessage(m_err); return(null); } queryResult = from r in queryResult where r.是否在用 == true select r; if (!BasicInfo.ListRoles.Contains(CE_RoleEnum.采购账务管理员.ToString()) && BasicInfo.ListRoles.Contains(CE_RoleEnum.采购员.ToString())) { var varData = (from r in ctx.View_Provider join f in ctx.ProviderPrincipal on r.供应商编码 equals f.Provider where f.PrincipalWorkId == BasicInfo.LoginID && r.是否在用 == true select r).Distinct(); List <View_Provider> lstProvider = new List <View_Provider>(); foreach (var item in varData) { View_Provider lnqProvider = new View_Provider(); lnqProvider.供应商编码 = item.供应商编码; lnqProvider.供应商名称 = item.供应商名称; lnqProvider.简称 = item.简称; lnqProvider.拼音码 = item.拼音码; lnqProvider.零星采购供应商 = item.零星采购供应商; lnqProvider.是否在用 = item.是否在用; lnqProvider.五笔码 = item.五笔码; lstProvider.Add(lnqProvider); } queryResult = lstProvider.AsQueryable(); } System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_Provider>(queryResult); FormQueryInfo form = new FormQueryInfo(dataTable); return(form); }