/// <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_DateIntervalDays);
dateCurrentDateEnd.DateTime = nowDate.Date;
datePlanDateBegin.DateTime = nowDate.Date;
datePlanDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays);
checkPlanDate.Checked = false;
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
comboBoxReqState.SelectedIndex = 0;
ControlCommonInit ctlInit = new ControlCommonInit();
ctlInit.SearchLookUpEdit_UserInfo_ValueMember_EmpName(searchLookUpPrepared);
searchLookUpPrepared.EditValue = SystemInfo.user.EmpName;
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 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 FrmPrReqListDistributionQuery_Load(object sender, EventArgs e)
{
try
{
ControlCommonInit ctlInit = new ControlCommonInit();
ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpArrangement);
searchLookUpArrangement.EditValue = SystemInfo.user.AutoId;
repLookUpCodeName.DataSource = commonDAO.QueryPartsCode(false);
repLookUpOperator.DataSource = searchLookUpArrangement.Properties.DataSource;
//if (!SystemInfo.PrListDistributionAllHandle)
//{
// pnlTop.Visible = false;
//}
if (SystemInfo.DisableProjectNo)
{
colProjectNo.Visible = false;
colStnNo.Visible = false;
}
btnQuery_Click(null, null);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <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 FrmBomImport_Load(object sender, EventArgs e)
{
try
{
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmBomPositiveExpand_Load(object sender, EventArgs e)
{
try
{
searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjzsj.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmWarehouseNowInfo_Bom_Load(object sender, EventArgs e)
{
try
{
searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false);
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmBomManagement_Load(object sender, EventArgs e)
{
try
{
ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
btnListAdd
});
searchPartsCodeId.Properties.DataSource = commonDAO.QueryPartsCode(false);
lookUpMaterieState.Properties.DataSource = bomDAO.QueryBomMaterieState(false);
repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false);
//RefreshTreeList();
Set_ButtonEditGrid_State(true, null);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <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 FrmPBBomManagement_Load(object sender, EventArgs e)
{
try
{
searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false);
lookUpCatgName.Properties.DataSource = commonDAO.QueryPartNoCatg(true);
lookUpCatgName.ItemIndex = 0;
lookUpBrand.Properties.DataSource = commonDAO.QueryBrandCatg(true);
lookUpBrand.ItemIndex = 0;
btnEditAutoSalesOrderNo.Focus();
btnEditAutoSalesOrderNo.SelectAll();
}
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 FrmWarehouseWarrantList_NoSettlement_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateWWDateEnd.DateTime = nowDate.Date;
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;
lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
lookUpReqDep.ItemIndex = 0;
comboBoxWarehouseState.SelectedIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false);
repLookUpShelfId.DataSource = commonDAO.QueryShelfInfo(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 FrmWarehouseNowInfo_Load(object sender, EventArgs e)
{
try
{
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
searchLookUpShelf.Properties.DataSource = commonDAO.QueryShelfInfo(true);
searchLookUpShelf.EditValue = 0;
gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmQueryStockDurationTotal_Load(object sender, EventArgs e)
{
try
{
DateTime nowDate = BaseSQL.GetServerDateTime();
dateDurBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
dateDurEnd.DateTime = nowDate.Date;
lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
lookUpRepertoryNo.ItemIndex = 0;
searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
searchLookUpProjectNo.Text = "全部";
searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
searchLookUpCodeFileName.Text = "全部";
gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
private DataTable partsCodeTable_false = null; //不包含全部选项
/// <summary>
/// SearchLookUpEdit零件信息控件初始化
/// </summary>
public void SearchLookUpEdit_PartsCode(SearchLookUpEdit searchLookUp, bool addAllItem, string valueMemberStr = "AutoId", string displayMemberStr = "CodeName")
{
if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init")
{
return;
}
GridColumn grdColAutoId = new GridColumn();
grdColAutoId.Caption = "AutoId";
grdColAutoId.FieldName = "AutoId";
grdColAutoId.Name = "grdColAutoId";
GridColumn grdColCodeFileName = new GridColumn();
grdColCodeFileName.Caption = "零件编号";
grdColCodeFileName.FieldName = "CodeFileName";
grdColCodeFileName.Name = "grdColCodeFileName";
grdColCodeFileName.AppearanceHeader.Options.UseTextOptions = true;
grdColCodeFileName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColCodeFileName.Visible = true;
grdColCodeFileName.VisibleIndex = 0;
GridColumn grdColCodeName = new GridColumn();
grdColCodeName.Caption = "零件名称";
grdColCodeName.FieldName = "CodeName";
grdColCodeName.Name = "grdColCodeName";
grdColCodeName.AppearanceHeader.Options.UseTextOptions = true;
grdColCodeName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColCodeName.Visible = true;
grdColCodeName.VisibleIndex = 1;
searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColCodeFileName, grdColCodeName });
searchLookUp.Properties.NullText = "";
searchLookUp.EnterMoveNextControl = true;
searchLookUp.Properties.ValueMember = valueMemberStr;
searchLookUp.Properties.DisplayMember = displayMemberStr;
if (addAllItem)
{
if (partsCodeTable_True == null)
{
partsCodeTable_True = commonDAO.QueryPartsCode(true);
}
searchLookUp.Properties.DataSource = partsCodeTable_True;
}
else
{
if (partsCodeTable_false == null)
{
partsCodeTable_false = commonDAO.QueryPartsCode(false);
}
searchLookUp.Properties.DataSource = partsCodeTable_false;
}
searchLookUp.Properties.View.IndicatorWidth = 60;
searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator;
searchLookUp.Properties.View.Tag = "Init";
}
