/// <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);
}