/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmWarehouseReceipt_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd, checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateWRDateEnd.DateTime = nowDate.Date;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
lookUpWarehouseReceiptTypeNo.Properties.DataSource = wrDAO.QueryWarehouseReceiptType(true);
lookUpWarehouseReceiptTypeNo.ItemIndex = 0;
comboBoxWarehouseState.SelectedIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
lookUpApprover.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpApprover.ItemIndex = -1;
lookUpManufactureNo.Properties.DataSource = wrDAO.QueryManufactureInfo(true);
lookUpManufactureNo.ItemIndex = 0;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
repLookUpWRTypeNo.DataSource = wrDAO.QueryWarehouseReceiptType(false);
repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
repLookUpManufactureNo.DataSource = wrDAO.QueryManufactureInfo(false);
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
repSearchShelfId.DataSource = commonDAO.QueryShelfInfo(false);
repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false);
if (textCommon.Text == "")
{
wrDAO.QueryWarehouseReceiptHead(dataSet_WR.Tables[0], "", "", "", "", "", "", 0, "", -1, "", true);
wrDAO.QueryWarehouseReceiptList(dataSet_WR.Tables[1], "", true);
}
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmProductionSchedule_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateCurrentDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateCurrentDateEnd.DateTime = nowDate.Date;
datePlanDateBegin.DateTime = nowDate.Date;
datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
checkPlanDate.Checked = false;
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
comboBoxReqState.SelectedIndex = 0;
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
if (textCommon.Text == "")
{
psDAO.QueryProductionSchedule(dataSet_PSchedule.Tables[0], "", "", "", "", "", 0, "", -1, "", true);
psDAO.QueryProductionScheduleBom(dataSet_PSchedule.Tables[1], "", true);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmSalesOrder_History_Load(object sender, EventArgs e)
{
try
{
DataTable bussBaseTable = commonDAO.QueryBussinessBaseInfo(false);
searchProjectName.Properties.DataSource = commonDAO.QueryProjectList(false);
searchBussinessBaseNo.Properties.DataSource = bussBaseTable;
lookUpCollectionTypeNo.Properties.DataSource = commonDAO.QueryCollectionType(false);
lookUpCurrencyCate.Properties.DataSource = commonDAO.QueryCurrencyCate(false);
lookUpProjectLeader.Properties.DataSource = commonDAO.QueryUserInfo(false);
DateTime nowDate = BaseSQL.GetServerDateTime();
repSearchBussinessBaseNo.DataSource = bussBaseTable;
dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateSalesOrderDateEnd.DateTime = nowDate.Date;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;
Set_ButtonEditGrid_State(true);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmSpecialWarehouseReceiptQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateSWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateSWRDateEnd.DateTime = nowDate.Date;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
comboBoxWarehouseState.SelectedIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.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 FrmStnModule_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateGetTimeBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateGetTimeEnd.DateTime = nowDate.Date;
LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);
repItemLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;
repLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;
if (querySMNoStr == "")
{
smDAO.QueryStnModule(dataSet_StnModule.Tables[0], "", "", 0, "", "", true);
Set_ButtonEditGrid_State(true);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.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 FrmSalesOrderQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateSalesOrderDateEnd.DateTime = nowDate.Date;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
searchProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchProjectNo.Text = "全部";
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpCollectionTypeNo.DataSource = commonDAO.QueryCollectionType(false);
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
gridBottomOrderHead.pageRowCount = 5;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmProductionScheduleQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateCurrentDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateCurrentDateEnd.DateTime = nowDate.Date;
dateReqDateBegin.DateTime = nowDate.Date;
dateReqDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
checkReqDate.Checked = false;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
if (textCommon.Text == "")
{
btnQuery_Click(null, null);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmInventoryAdjustmentsQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateIADateEnd.DateTime = nowDate.Date;
lookUpAdjustmentsRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpAdjustmentsRepertoryNo.ItemIndex = 0;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
searchAdjustmentsProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchAdjustmentsProjectNo.Text = "全部";
repLookUpInRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
repSearchAdjustmentsProjectNo.DataSource = commonDAO.QueryProjectList(false);
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
gridBottomIA.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 选择操作员或者权限角色
/// </summary>
private void radioHandleCate_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (radioHandleCate.SelectedIndex == 0)//操作员
{
labHandleOwner.Text = "操作员";
searchLookUpHandleOwner.Properties.DataSource = commonDAO.QueryUserInfo(false);
searchLookUpHandleOwner.Properties.DisplayMember = "EmpName";
searchLookUpHandleOwner.Properties.ValueMember = "LoginId";
gridColRoleNo.Visible = false;
gridColRoleName.Visible = false;
gridColLoginId.Visible = true;
gridColEmpName.Visible = true;
}
else//权限角色
{
labHandleOwner.Text = "权限角色";
searchLookUpHandleOwner.Properties.DataSource = commonDAO.QueryRole(false);
searchLookUpHandleOwner.Properties.DisplayMember = "RoleName";
searchLookUpHandleOwner.Properties.ValueMember = "RoleNo";
gridColLoginId.Visible = false;
gridColEmpName.Visible = false;
gridColRoleNo.Visible = true;
gridColRoleName.Visible = true;
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--选择操作员或者权限角色错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPrReqListQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateRequirementDateBegin.DateTime = nowDate.Date;
dateRequirementDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays);
dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateReqDateEnd.DateTime = nowDate.Date;
checkReqDate.Checked = false;
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;
//searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
//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;
//repItemLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
//repItemLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repItemLookUpReqDep.DataSource = departmentTable_t;
repItemLookUpPurCategory.DataSource = purCateTable_t;
repLookUpCreator.DataSource = commonDAO.QueryUserInfo(false);
if (SystemInfo.DisableProjectNo)
{
labProjectNo.Visible = false;
searchLookUpProjectNo.Visible = false;
colProjectNo.Visible = false;
colStnNo.Visible = false;
}
gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.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 FrmInventoryAdjustments_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd, checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateIADateEnd.DateTime = nowDate.Date;
DataTable repertoryTable = commonDAO.QueryRepertoryInfo(false);
DataTable repertoryAddAllTable = commonDAO.QueryRepertoryInfo(true);
DataTable projectListAddAllTable = commonDAO.QueryProjectList(true);
lookUpAdjustmentsRepertoryNo.Properties.DataSource = repertoryAddAllTable;
lookUpAdjustmentsRepertoryNo.ItemIndex = 0;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
searchAdjustmentsProjectNo.Properties.DataSource = projectListAddAllTable;
searchAdjustmentsProjectNo.Text = "全部";
repLookUpInRepertoryNo.DataSource = repertoryTable;
repSearchAdjustmentsProjectNo.DataSource = commonDAO.QueryProjectList(false);
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
repSearchOutShelfNo.DataSource = commonDAO.QueryShelfInfo(false);
lookUpRepertoryNo.Properties.DataSource = repertoryAddAllTable;
lookUpRepertoryNo.ItemIndex = 0;
searchLookUpProjectNo.Properties.DataSource = projectListAddAllTable;
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
repLookUpRepertoryNo.DataSource = repertoryTable;
if (textCommon.Text == "")
{
iaDAO.QueryInventoryAdjustmentsHead(dataSet_IA.Tables[0], "", "", "", "", "", "", "", true);
iaDAO.QueryInventoryAdjustmentsList(dataSet_IA.Tables[1], "", true);
}
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmPriceInfo_Load(object sender, EventArgs e)
{
try
{
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(false);
lookUpCurrencyCate.Properties.DataSource = commonDAO.QueryCurrencyCate(false);
repLookUpBussinessBaseNo.DataSource = searchLookUpBussinessBaseNo.Properties.DataSource;
repLookUpCurrencyCate.DataSource = lookUpCurrencyCate.Properties.DataSource;
repLookUpCreator.DataSource = commonDAO.QueryUserInfo(false);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmDeliveryDetail_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd
});
LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);
btnRefresh_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmSettleAccounts_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
checkAll
});
DateTime nowDate = BaseSQL.GetServerDateTime();
dateSADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateSADateEnd.DateTime = nowDate.Date;
DataTable bussBaseTable = commonDAO.QueryBussinessBaseInfo(false);
DataTable bussBaseAddAllTable = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Properties.DataSource = bussBaseAddAllTable;
searchLookUpBussinessBaseNo.Text = "全部";
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
repSearchBussinessBaseNo.DataSource = bussBaseTable;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false);
dateSODateBegin.DateTime = dateSADateBegin.DateTime;
dateSODateEnd.DateTime = dateSADateEnd.DateTime;
searchBussinessBaseNo.Properties.DataSource = bussBaseAddAllTable;
searchBussinessBaseNo.Text = "全部";
repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;
if (textCommon.Text == "")
{
saDAO.QuerySettleAccountsHead(dataSet_SettleAccounts.Tables[0], "", "", "", "", "", "", true);
saDAO.QuerySettlementList(dataSet_SettleAccounts.Tables[1], "", true);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmQuotationInfo_History_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd
});
DataTable bussBaseTable = commonDAO.QueryBussinessBaseInfo(false);
DataTable currencyCateTable = commonDAO.QueryCurrencyCate(false);
searchBussinessBaseNo.Properties.DataSource = bussBaseTable;
LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);
LookUpModifierId.Properties.DataSource = LookUpCreator.Properties.DataSource;
repLookUpCurrencyCate.DataSource = currencyCateTable;
repItemCORBussinessBaseNo.DataSource = bussBaseTable;
repItemCORCurrencyCate.DataSource = currencyCateTable;
DateTime nowDate = BaseSQL.GetServerDateTime();
dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateRecordDateEnd.DateTime = nowDate.Date;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;
repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false);
if (queryAutoQuotationNoStr == "")
{
dataSet_Quotation.Tables[0].Clear();
quoDAO.QueryQuotationBaseInfo(dataSet_Quotation.Tables[0], "", "", "", 0, "", true);
Set_ButtonEditGrid_State(true);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmStnSummary_Load(object sender, EventArgs e)
{
try
{
LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);
repLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;
if (queryAutoQuotationNoStr == "")
{
ssDAO.QueryStnSummary(TableStnSummary, "", "", true);
ssDAO.QueryStnSummaryList(TableStnList, "", true);
Set_ButtonEditGrid_State(true);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmSelectQuotationInfo_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateSalesOrderDateEnd.DateTime = nowDate.Date;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
repSearchLookUpBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmApprovalList_Load(object sender, EventArgs e)
{
try
{
FrmCommonDAO commonDAO = new FrmCommonDAO();
repItemLookUpTypeNo.DataSource = commonDAO.QueryApprovalType(false);
repItemLookUpApprover.DataSource = commonDAO.QueryUserInfo(false);
if (editForm == null)
{
editForm = new FrmBaseEdit();
editForm.FormBorderStyle = FormBorderStyle.None;
editForm.TopLevel = false;
editForm.TableName = "PUR_ApprovalList";
editForm.TableCaption = "审批信息设置";
editForm.Sql = string.Format("select * from PUR_ApprovalList where typeNo='{0}' Order by AppSequence", TypeNoStr);
editForm.PrimaryKeyColumn = "AutoId";
editForm.MasterDataSet = dSApprovalList;
editForm.MasterBindingSource = bSApprovalList;
//editForm.MasterEditPanel = pnlEdit;
editForm.BrowseXtraGridView = gridViewApprovalList;
editForm.CheckControl += CheckControl;
editForm.SaveRowBefore += SaveRowBefore;
editForm.DeleteRowBefore += DeleteRowBefore;
editForm.ButtonList.Add(btnUp);
editForm.ButtonList.Add(btnDown);
editForm.DeleteAfterRefresh = true;
//editForm.btnSaveExcel.Visible = false;
editForm.VisibleSearchContrl = false;
this.pnlToolBar.Controls.Add(editForm);
editForm.Dock = DockStyle.Fill;
editForm.Show();
}
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmStnSummary_Query_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateGetTimeBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateGetTimeEnd.DateTime = nowDate.Date;
searchLookUpStnModule.Properties.DataSource = ssDAO.QueryStnModule(true);
searchLookUpStnModule.Text = "全部";
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件错误
/// </summary>
private void FrmOrderQuery_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;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false);
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
repLookUpPayTypeNo.DataSource = commonDAO.QueryPayType(false);
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;
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmWarehouseWarrantQuery_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateWWDateEnd.DateTime = nowDate.Date;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwDAO.QueryWarehouseWarrantType(true);
lookUpWarehouseWarrantTypeNo.ItemIndex = 0;
comboBoxWarehouseState.SelectedIndex = 0;
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = SystemInfo.user.EmpName;
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false);
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
btnQuery_Click(null, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmQuotationApply_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateRecordDateEnd.DateTime = nowDate.Date;
searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
searchLookUpBussinessBaseNo.Text = "全部";
lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
lookUpPrepared.EditValue = "全部";
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false);
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
public void SearchLookUpEdit_UserInfo(SearchLookUpEdit searchLookUp, string valueMemberStr, bool addAllItem)
{
if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init")
{
return;
}
GridColumn grdColAutoId = new GridColumn();
grdColAutoId.Caption = "AutoId";
grdColAutoId.FieldName = "AutoId";
grdColAutoId.Name = "grdColAutoId";
GridColumn grdColLoginId = new GridColumn();
grdColLoginId.Caption = "用户名";
grdColLoginId.FieldName = "LoginId";
grdColLoginId.Name = "grdColLoginId";
grdColLoginId.AppearanceHeader.Options.UseTextOptions = true;
grdColLoginId.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColLoginId.Visible = true;
grdColLoginId.VisibleIndex = 0;
GridColumn grdColEmpName = new GridColumn();
grdColEmpName.Caption = "员工名";
grdColEmpName.FieldName = "EmpName";
grdColEmpName.Name = "grdColEmpName";
grdColEmpName.AppearanceHeader.Options.UseTextOptions = true;
grdColEmpName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColEmpName.Visible = true;
grdColEmpName.VisibleIndex = 1;
GridColumn grdColDepartmentName = new GridColumn();
grdColDepartmentName.Caption = "部门";
grdColDepartmentName.FieldName = "DepartmentName";
grdColDepartmentName.Name = "grdColDepartmentName";
grdColDepartmentName.AppearanceHeader.Options.UseTextOptions = true;
grdColDepartmentName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColDepartmentName.Visible = true;
grdColDepartmentName.VisibleIndex = 2;
searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColLoginId, grdColEmpName, grdColDepartmentName });
searchLookUp.Properties.NullText = "";
searchLookUp.EnterMoveNextControl = true;
searchLookUp.Properties.DisplayMember = "EmpName";
searchLookUp.Properties.ValueMember = valueMemberStr;
if (userInfoTable_True == null)
{
userInfoTable_True = commonDAO.QueryUserInfo(addAllItem);
}
searchLookUp.Properties.DataSource = userInfoTable_True;
searchLookUp.Properties.View.IndicatorWidth = 60;
searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator;
searchLookUp.Properties.View.Tag = "Init";
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmWorkFlowsLineSet_Load(object sender, EventArgs e)
{
try
{
if (!isEditWorkFlows)
{
lookUpLineType.Properties.ReadOnly = true;
}
if (lineIdInt == 0)
{
labEnabled.Visible = false;
checkEnabled.Visible = false;
PageCondition.PageVisible = false;
lookUpLineType.Properties.DataSource = DataTypeConvert.EnumToDataTable_NoInclude(typeof(WorkFlowsHandleDAO.LineType), "LineType", "TypeId", new List <int>()
{
-1, 0
});
}
else if (lineIdInt > 0)
{
repLookUpCreator.DataSource = commonDAO.QueryUserInfo(false);
repLookUpCreator1.DataSource = repLookUpCreator.DataSource;
repLookUpCreator2.DataSource = repLookUpCreator.DataSource;
lookUpLineType.Properties.DataSource = DataTypeConvert.EnumToDataTable_NoInclude(typeof(WorkFlowsHandleDAO.LineType), "LineType", "TypeId", new List <int>()
{
-1, 0
});
RefreshLineControlInfo();
setDAO.QueryWorkFlowsLineConditionList(TableCondition, lineIdInt);
}
else
{
PageBaseInfo.PageVisible = false;
BtnCopy.Visible = false;
PageLineHandle.PageVisible = false;
colMultiLevelApprover.Visible = false;
colMultiLevelApprover1.Visible = false;
pnlLineHandleTop.Height = 97;
btnHandleNew.Location = new Point(298, 54);
btnHandleDelete.Location = new Point(354, 54);
repLookUpCreator.DataSource = commonDAO.QueryUserInfo(false);
repLookUpCreator2.DataSource = repLookUpCreator.DataSource;
radioHandleCate_SelectedIndexChanged(null, null);
RefreshConditionInfo();
setDAO.QueryWorkFlowsLineConditionList(TableCondition, lineIdInt);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}