/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { this.lvwPresetTare.DataSource = null; lvwPresetTare.DataSource = page.BindBoundControl <View_PresetTare_Dictionary>("", txtCurrentPage2, lblPageCount2, expr, "PresetTare_ID desc"); } catch (Exception ex) { Common.WriteTextLog("日记管理 LoadData()" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { this.lvwUserList.DataSource = null; lvwUserList.DataSource = page.BindBoundControl <View_UserInfo2_D_R_d>("", txtCurrentPage2, lblPageCount2, expr); } catch (Exception ex) { Common.WriteTextLog("用户管理 LoadData()" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { this.lvwUserList.DataSource = null; lvwUserList.DataSource = page.BindBoundControl <View_LogInfo_Dictionary>("", txtCurrentPage2, lblPageCount2, expr, "Log_ID Log_Time desc"); } catch (Exception ex) { Common.WriteTextLog("日记管理 LoadData()" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData(string strName) { try { page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); dgvImageRecord.DataSource = page.BindBoundControl <View_UnusualImage>(strName, txtCurrentPage2, lblPageCount2, expr, orderbywhere); } catch (Exception ex) { Common.WriteTextLog("图片记录加载加载显示" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { this.lvwUserList.DataSource = null; lvwUserList.DataSource = page.BindBoundControl <View_Beonduty_D_Q>("", txtCurrentPage2, lblPageCount2, expr, "Beonduty_ID desc"); ShowAddButton(); } catch (Exception ex) { Common.WriteTextLog("用户管理 LoadData()" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { this.dgvCarStatisticsQC.DataSource = null; page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); dgvCarStatisticsQC.DataSource = page.BindBoundControl <View_QCInfo>("", txtCurrentPage2, lblPageCount2, expr, orderbywhere); } catch (Exception ex) { Common.WriteTextLog("日记管理 修改质检数据统计(CarStatisticsForm)加载显示" + ex.Message.ToString()); } }
/// <summary> /// 菜单栏加载数据 /// </summary> private void LoadData() { try { GetDgvDictionarySeacher(); dgvDictionary.DataSource = page.BindBoundControl <Dictionary>("", txtCurrentPage1, lblPageCount1, expr); } catch (Exception ex) { Common.WriteTextLog("FormWeight.BindDgvWaitQC异常:" + ex.Message.ToString()); } }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(object strClickedItemName) { Control.CheckForIllegalCrossThreadCalls = false; ///View_CarState1创建临时查询表查询“carstatek” page.BindBoundControl(gridevewCarState, strClickedItemName.ToString(), tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_CarState1", "*", "CarInOutRecord_ID", "CarInOutRecord_ID", 1, sqlwhere, true); CommonalityEntity.isLoad = 0; }
/// <summary> /// 加载数据 /// </summary> private void LoadData(string strName) { try { if (expr == null) { if (expr == null) { expr = PredicateExtensionses.True <View_ClientInfo>(); } } if (txtSName.Text.Trim() != "") { expr = expr.And(n => SqlMethods.Like(n.Client_NAME, "%" + txtSName.Text.Trim() + "%")); } if (cmbSState.Text != "全部" && cmbSState.Text != "") { int did = Convert.ToInt32(cmbSState.SelectedValue.ToString()); expr = expr.And(n => (n.Dictionary_ID == did)); } this.dgvClient.DataSource = null; page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); this.dgvClient.AutoGenerateColumns = false; dgvClient.DataSource = page.BindBoundControl <View_ClientInfo>(strName, txtCurrentPage2, lblPageCount2, expr); } catch (Exception ex) { Common.WriteTextLog("客户端管理 LoadData()" + ex.Message.ToString()); } }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { if (sqlwhere == null) { UserClick(); } page.BindBoundControl(lvwUserList, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "UserInfo_RoleInfo", "*", "UserId", "UserId", 0, sqlwhere, true); }
/// <summary> /// 绑定数据 /// </summary> private void LoadData() { try { if (isnames) { this.dataGridView1.AutoGenerateColumns = false;//设置只显示列表控件绑定的列 //判断车牌号不为空 if (cntr_no != "" || cntr_no != null) { dvgCarList.DataSource = null; //清空数据源 dataGridView1.DataSource = null; //清空数据源 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); dataGridView1.DataSource = page.BindBoundControl <OCC_MOIST_INTERFACE>("", txtCurrentPage2, lblPageCount2, expr, "OCC_MOIST_INTERFACE_ID desc"); } else { MessageBox.Show("没有可查询的详情信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { this.dvgCarList.AutoGenerateColumns = false;//设置只显示列表控件绑定的列 //判断车牌号不为空 if (cntr_no != "" || cntr_no != null) { dataGridView1.DataSource = null; //清空数据源 dvgCarList.DataSource = null; //清空数据源 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); dvgCarList.DataSource = page.BindBoundControl <MATERIAL_QC_INTERFACE>("", txtCurrentPage2, lblPageCount2, mexpr); } else { MessageBox.Show("没有可查询的详情信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { Common.WriteTextLog("InsetfaceFrom_LoadData异常:" + ex.Message.ToString()); } }
/// <summary> /// 显示列表绑定数据 /// </summary> private void BingMethod() { try { pc.BindBoundControl(dgv_Information, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_DrivewayStrategyRecord_Driveway_Position_CarInfo", "*", "DrivewayStrategyRecord_ID", "DrivewayStrategyRecord_ID", 1, sqlwhere, true); } catch { CommonalityEntity.WriteTextLog("DrivewayStrategyRecordForm.BingMethod()" + "".ToString()); } }
/// <summary> /// 显示列表绑定数据 /// </summary> private void BingMethod() { try { pc.BindBoundControl(lvwUserList, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_carInOutSatistics", "*", "CarInOutInfoRecord_ID", "CarInOutInfoRecord_ID", 0, sqlwhere, true); } catch { CommonalityEntity.WriteTextLog("carInOutSatistics.BingMethod()"); } }
/// <summary> /// 显示列表绑定数据 /// </summary> private void BingMethod() { try { pc.BindBoundControl(dgv_Information, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_CarType_User", "*", "CarType_ID", "CarType_ID", 0, sqlwhere, true); CarTypeValueBind(); } catch { CommonalityEntity.WriteTextLog("CarTypeForm.BingMethod()"); } }
/// <summary> /// 绑定要显示的数据加载时显示 /// </summary> private void LoadData() { try { this.dvgCarList.AutoGenerateColumns = false;//设置只显示列表控件绑定的列 //判断磅单号不为空 if (weight_ticket_no != "" || weight_ticket_no != null) { dvgCarList.DataSource = null;//清空数据源 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); dvgCarList.DataSource = page.BindBoundControl <View_QCInfo>("", txtCurrentPage2, lblPageCount2, expr); } else { MessageBox.Show("没有可查询的详情信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { Common.WriteTextLog("frmQcRecordInfo.LoadData异常:" + ex.Message.ToString()); } }
/// <summary> /// 绑定要显示的数据加载时显示 /// </summary> private void LoadData() { try { this.dgv_SFJC.AutoGenerateColumns = false;//设置只显示列表控件绑定的列 //一检管理选中ID值大于0 if (iqcinfoid > 0) { dgv_SFJC.DataSource = null;//清空数据源 //dgv_SFJC.DataSource = page.BindBoundControl<View_QCRecordInfo>("", txtCurrentPage2, lblPageCount2, expr, p); dgv_SFJC.DataSource = page.BindBoundControl <View_QCRecordInfo>("", txtCurrentPage2, lblPageCount2, expr, "QCRecord_TIME desc"); } else { MessageBox.Show("没有可查询的详情信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { Common.WriteTextLog("frmQcRecordInfo.LoadData异常:" + ex.Message.ToString()); } }
/// <summary> /// 加载数据 /// </summary> private void LoadData(string ClickedItemName) { try { SearchUp(); //按条件搜索质检记录信息 dgv_SFJC.DataSource = null; //清空数据源 this.dgv_SFJC.AutoGenerateColumns = false; dgv_SFJC.DataSource = page.BindBoundControl <View_QCRecordInfo>(ClickedItemName, txtCurrentPage2, lblPageCount2, expr, "QCRecord_UPDATE_TIME desc"); } catch (Exception ex) { Common.WriteTextLog("FormWeight.LoadData异常:" + ex.Message.ToString()); } }
private void LoadData(string strName) { if (expr == null) { expr = (Expression <Func <idebarJoinU9, bool> >)PredicateExtensionses.True <idebarJoinU9>(); } if (txtPRODID2.Text != "") { expr = expr.And(n => SqlMethods.Like(n.idebarJoinU9_PROD_ID, "%" + txtPRODID2.Text.Trim() + "%")); } dgvView_WaterSet.AutoGenerateColumns = false; dgvView_WaterSet.DataSource = page.BindBoundControl <idebarJoinU9>(strName, txtCurrentPage1, lblPageCount1, expr, "idebarJoinU9_id"); }
private void LoadData() { if (expr == null) { expr = (Expression <Func <View_WeightSet, bool> >)PredicateExtensionses.True <View_WeightSet>(); } if (cbxTestItem2.Text != "") { expr = expr.And(n => n.TestItems_ID == Convert.ToInt32(cbxTestItem2.SelectedValue) + 1); } if (cbxWeightNum2.Text != "") { expr = expr.And(n => n.WeightSet_weightNum == (cbxWeightNum2.SelectedIndex)); } dgvView_WaterSet.AutoGenerateColumns = false; dgvView_WaterSet.DataSource = page.BindBoundControl <View_WeightSet>("", txtCurrentPage1, lblPageCount1, expr, "WeightSet_id"); }
private void LoadData(string clickName) { expr = (Expression <Func <View_PacketsRecord, bool> >)PredicateExtensionses.True <View_PacketsRecord>(); if (txtCNTR_NO.Text.Trim() != "") { expr = expr.And(c => SqlMethods.Like(c.CNTR_NO, "%" + txtCNTR_NO.Text.Trim() + "%")); } if (txtSHIPMENT_NO.Text.Trim() != "") { expr = expr.And(c => SqlMethods.Like(c.SHIPMENT_NO, "%" + txtSHIPMENT_NO.Text.Trim() + "%")); } if (txtPO_NO.Text.Trim() != "") { expr = expr.And(c => SqlMethods.Like(c.PO_NO, "%" + txtPO_NO.Text.Trim() + "%")); } if (cbxPROD_ID.Text.Trim() != "") { expr = expr.And(c => SqlMethods.Like(c.PROD_ID, "%" + cbxPROD_ID.Text.Trim() + "%")); } if (comboBox2.Text.Trim() == "是") { expr = expr.And(c => c.Packets_this_Update != "" || c.Packets_this_Update != null); } if (comboBox1.Text.Trim() == "是") { expr = expr = expr.And(n => n.Packets_this.ToString().Replace("+", "").Replace("-", "") == n.Packets_this_Update); } if (txtbeginTime.Value != null && txtendTime.Value != null) { expr = expr.And(c => c.Packets_Time >= Convert.ToDateTime(txtbeginTime.Value.ToString("yyyy-MM-dd")) && c.Packets_Time <= Convert.ToDateTime(txtendTime.Value.ToString("yyyy-MM-dd"))); } page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); lvwUserList.DataSource = page.BindBoundControl <View_PacketsRecord>(clickName, txtCurrentPage2, lblPageCount2, expr, orderbywhere); }
/// <summary> /// 数据加载 /// </summary> /// <param name="strClickedItemName"></param> private void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvSAPInfo, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "eh_SAPRecord", "*", "Sap_ID", "Sap_ID", 0, sqlwhere, true); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvCamera, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_Camera_Driveway_Position", "*", "Camera_ID", "Camera_ID", 0, sqlwhere, true); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvDictioanry, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "Dictionary", "case Dictionary_State when 'true' then '启动' else '暂停' end as Dictstate,case Dictionary_ISLower when 'true' then '是' else '否' end as DictISLower,case Dictionary_IsSystem when 'true' then '是' else '否' end as DictIsSystem,*", "Dictionary_ID", "Dictionary_ID", 0, sqlwhere, true); DataBindingComplete(); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(gdvUnLoadCarMange, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_CarState,BusinessRecord ", "case BusinessRecord_UnloadEmpower when '1' then '是' else '否' end as UnloadEmpower,*", "BusinessRecord_ID", "BusinessRecord_ID", 1, sqlwhere, true); }
/// <summary> /// 加载发生 /// </summary> private void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvWeighInfo, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "WeighInfo", "*", "WeighInfo_ID", "WeighInfo_ID", 0, sqlwhere, true); }
private void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvCarPic, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_CarPic", "*", "CarPic_ID", "CarPic_ID", 0, sqlwhere, true); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvPositionList, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "View_Position_UserInfo", "*", "Position_ID", "Position_ID", 0, sqlwhere, true); }
/// <summary> /// 加载数据 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(gridevewSortReset, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, " CarInfo_Name,CarInfo_ID,SortNumberInfo_SmallTicket_ID,SortNumberInfo_TongXing,CarType_Name,SmallTicket_SortNumber,SmallTicket_Serialnumber,ICCard_ID,ICCard_Value,StaffInfo_Name,StaffInfo_Identity,CustomerInfo_Name ", sqlwhere, "CarInOutRecord_ID desc"); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvCarAttribute, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "CarAttribute", "*", "CarAttribute_ID", "CarAttribute_ID", 0, sqlwhere, true); DataBindingComplete(); }
/// <summary> /// 加载信息 /// </summary> public void LogInfoLoad(string strClickedItemName) { page.BindBoundControl(dgvICCardType, strClickedItemName, tstbPageCurrent, tslPageCount, tslNMax, tscbxPageSize, "ICCardType", "*", "ICCardType_ID", "ICCardType_ID", 0, sqlwhere, true); }