/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPrReqList_Overplus_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateReqDateEnd.DateTime = nowDate.Date;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
lookUpPurCategory.ItemIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
comboBoxReqState.SelectedIndex = 0;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repLookUpProjectNo.DataSource = commonDAO.QueryProjectList(false);
gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPrReqQuery_Load(object sender, EventArgs e)
{
try
{
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
lookUpPurCategory.ItemIndex = 0;
comboBoxReqState.SelectedIndex = 0;
lookUpApplicant.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpApplicant.EditValue = SystemInfo.user.EmpName;
repositoryItemLookUpEdit1.DataSource = commonDAO.QueryDepartment(false);
repositoryItemLookUpEdit2.DataSource = commonDAO.QueryPurCategory(false);
DateTime nowDate = BaseSQL.GetServerDateTime();
dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateReqDateEnd.DateTime = nowDate.Date;
gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmOrderApply_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateOrderDateEnd.DateTime = nowDate.Date;
checkOrderDate.Checked = false;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
lookUpPurCategory.ItemIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.ItemIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件错误
/// </summary>
private void FrmOrderArrivalQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateOrderDateEnd.DateTime = nowDate.Date;
datePlanDateBegin.DateTime = nowDate.Date;
datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays);
checkPlanDate.Checked = false;
DataTable departmentTable_t = commonDAO.QueryDepartment(true);
DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true);
DataTable purCateTable_t = commonDAO.QueryPurCategory(true);
lookUpReqDep.Properties.DataSource = departmentTable_t;
lookUpReqDep.ItemIndex = 0;
searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
searchLookUpBussinessBaseNo.Text = "全部";
lookUpPurCategory.Properties.DataSource = purCateTable_t;
lookUpPurCategory.ItemIndex = 0;
//searchLookUpProjectNo.Properties.DataSource = projectTable_t;
//searchLookUpProjectNo.Text = "全部";
//searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
//searchLookUpCodeFileName.EditValue = 0;
ControlCommonInit ctlInit = new ControlCommonInit();
ctlInit.SearchLookUpEdit_PartsCode(searchLookUpCodeFileName, true);
searchLookUpCodeFileName.EditValue = 0;
ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true);
searchLookUpProjectNo.Text = "全部";
ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState);
comboBoxReqState.SelectedIndex = 0;
//repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
//repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
//repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
//repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false);
repLookUpReqDep.DataSource = departmentTable_t;
repSearchBussinessBaseNo.DataSource = bussInfoTable_t;
repLookUpPurCategory.DataSource = purCateTable_t;
repSearchProjectNo.DataSource = searchLookUpProjectNo.Properties.DataSource;
if (SystemInfo.DisableProjectNo)
{
labProjectNo.Visible = false;
searchLookUpProjectNo.Visible = false;
colProjectNo.Visible = false;
colStnNo.Visible = false;
}
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmOrderList_NoWarehousing_Days_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateOrderDateEnd.DateTime = nowDate.Date;
datePlanDateBegin.DateTime = nowDate.Date;
datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
checkPlanDate.Checked = false;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
lookUpPurCategory.ItemIndex = 0;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
comboBoxReqState.SelectedIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false);
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
SetGridViewAppearance();
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPrReq_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd, checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateReqDateEnd.DateTime = nowDate.Date;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
lookUpPurCategory.ItemIndex = 0;
comboBoxReqState.SelectedIndex = 0;
lookUpApplicant.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpApplicant.EditValue = SystemInfo.user.EmpName;
lookUpApprover.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpApprover.ItemIndex = -1;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false);
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
if (textCommon.Text == "")
{
prReqDAO.QueryPrReqHead(dataSet_PrReq.Tables[0], "", "", "", "", 0, "", -1, "", true);
}
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjz.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmOrderApply_Load(object sender, EventArgs e)
{
try
{
//ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List<Control> { checkAll });
DateTime nowDate = BaseSQL.GetServerDateTime();
dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateOrderDateEnd.DateTime = nowDate.Date;
checkOrderDate.Checked = false;
DataTable departmentTable_t = commonDAO.QueryDepartment(true);
DataTable purCateTable_t = commonDAO.QueryPurCategory(true);
DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true);
lookUpReqDep.Properties.DataSource = departmentTable_t;
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = purCateTable_t;
lookUpPurCategory.ItemIndex = 0;
searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
searchLookUpBussinessBaseNo.Text = "全部";
//searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
//searchLookUpProjectNo.Text = "全部";
ControlCommonInit ctlInit = new ControlCommonInit();
ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator);
searchLookUpCreator.EditValue = 0;
ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true);
searchLookUpProjectNo.Text = "全部";
//repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
//repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
//repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpReqDep.DataSource = departmentTable_t;
repLookUpPurCategory.DataSource = purCateTable_t;
repSearchBussinessBaseNo.DataSource = bussInfoTable_t;
repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource;
if (SystemInfo.DisableProjectNo)
{
labProjectNo.Visible = false;
searchLookUpProjectNo.Visible = false;
colProjectName.Visible = false;
colStnNo.Visible = false;
}
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPrReqQuery_Load(object sender, EventArgs e)
{
try
{
DataTable departmentTable_t = commonDAO.QueryDepartment(true);
DataTable purCateTable_t = commonDAO.QueryPurCategory(true);
lookUpReqDep.Properties.DataSource = departmentTable_t;
lookUpReqDep.ItemIndex = 0;
lookUpPurCategory.Properties.DataSource = purCateTable_t;
lookUpPurCategory.ItemIndex = 0;
ControlCommonInit ctlInit = new ControlCommonInit();
ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator);
searchLookUpCreator.EditValue = SystemInfo.user.AutoId;
ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState);
comboBoxReqState.SelectedIndex = 0;
//repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
//repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repLookUpReqDep.DataSource = departmentTable_t;
repLookUpPurCategory.DataSource = purCateTable_t;
repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource;
DateTime nowDate = BaseSQL.GetServerDateTime();
dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateReqDateEnd.DateTime = nowDate.Date;
if (SystemInfo.DisableProjectNo)
{
colProjectNo.Visible = false;
colStnNo.Visible = false;
}
gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPSBomToPrReq_Load(object sender, EventArgs e)
{
try
{
textPbBomNo.Text = pbBomNoStr;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(false);
lookUpReqDep.EditValue = SystemInfo.user.DepartmentNo;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(false);
searchLookUpProjectNo.Text = projectNoStr;
DataTable tempTable = commonDAO.QueryStnList(projectNoStr);
searchLookUpStnNo.Properties.DataSource = tempTable;
if (tempTable.Rows.Count > 0)
{
searchLookUpStnNo.EditValue = tempTable.Rows[0]["StnNo"];
}
lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(false);
lookUpPurCategory.ItemIndex = 0;
lookUpEditApprovalType.Properties.DataSource = commonDAO.QueryApprovalType(false);
lookUpEditApprovalType.ItemIndex = 0;
DataTable psBomTable = PStoPRDAO.Query_NoPr_PSBom(pbBomNoStr, bomListAutoIdInt);
gridControlPSBom.DataSource = psBomTable;
if (psBomTable.Rows.Count == 0)
{
MessageHandler.ShowMessageBox("当前选中的制作Bom信息没有生产计划，不能生成请购单。");
this.Close();
return;
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}