/// <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 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 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 FrmWarehouseWarrantList_NoSettlement_Load(object sender, EventArgs e)
{
try
{
ControlCommonInit ctlInit = new ControlCommonInit();
DateTime nowDate = BaseSQL.GetServerDateTime();
dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
dateWWDateEnd.DateTime = nowDate.Date;
DataTable departmentTable_t = commonDAO.QueryDepartment(true);
DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true);
DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true);
DataTable wwTypeTable_t = wwDAO.QueryWarehouseWarrantType(true);
lookUpReqDep.Properties.DataSource = departmentTable_t;
lookUpReqDep.ItemIndex = 0;
searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
searchLookUpBussinessBaseNo.Text = "全部";
lookUpRepertoryId.Properties.DataSource = repertoryTable_t;
lookUpRepertoryId.ItemIndex = 0;
//SearchLocationId.Properties.DataSource = locationTable_t;
//SearchLocationId.EditValue = 0;
ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
SearchLocationId.EditValue = 0;
lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwTypeTable_t;
lookUpWarehouseWarrantTypeNo.ItemIndex = 0;
ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState, true);
comboBoxWarehouseState.SelectedIndex = 0;
//searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
//searchLookUpProjectNo.Text = "全部";
ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true);
searchLookUpProjectNo.Text = "全部";
//searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
//searchLookUpCodeFileName.EditValue = 0;
ctlInit.SearchLookUpEdit_PartsCode(searchLookUpCodeFileName, true);
searchLookUpCodeFileName.EditValue = 0;
//repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
//repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
//repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
//repLookUpRepertoryLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
//repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false);
repLookUpReqDep.DataSource = departmentTable_t;
repSearchBussinessBaseNo.DataSource = bussInfoTable_t;
repLookUpRepertoryId.DataSource = repertoryTable_t;
repLookUpRepertoryLocationId.DataSource = SearchLocationId.Properties.DataSource;
repLookUpWWTypeNo.DataSource = wwTypeTable_t;
repLookUpShelfId.DataSource = commonDAO.QueryShelfInfo(false);
if (SystemInfo.DisableProjectNo)
{
labProjectNo.Visible = false;
searchLookUpProjectNo.Visible = false;
colProjectName.Visible = false;
colStnNo.Visible = false;
}
if (SystemInfo.DisableShelfInfo)
{
colShelfId.Visible = 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);
}
}
private DataTable shelfInfoTable_false = null; //不包含全部选项
/// <summary>
/// SearchLookUpEdit货架信息控件初始化
/// </summary>
public void SearchLookUpEdit_ShelfInfo(SearchLookUpEdit searchLookUp, bool addAllItem, string valueMemberStr = "AutoId", string displayMemberStr = "ShelfNo")
{
if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init")
{
return;
}
GridColumn grdColAutoId = new GridColumn();
grdColAutoId.Caption = "AutoId";
grdColAutoId.FieldName = "AutoId";
grdColAutoId.Name = "grdColAutoId";
GridColumn grdColShelfNo = new GridColumn();
grdColShelfNo.Caption = "货架号";
grdColShelfNo.FieldName = "ShelfNo";
grdColShelfNo.Name = "grdColShelfNo";
grdColShelfNo.AppearanceHeader.Options.UseTextOptions = true;
grdColShelfNo.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColShelfNo.Visible = true;
grdColShelfNo.VisibleIndex = 0;
GridColumn grdColShelfLocation = new GridColumn();
grdColShelfLocation.Caption = "货架位置";
grdColShelfLocation.FieldName = "ShelfLocation";
grdColShelfLocation.Name = "grdColShelfLocation";
grdColShelfLocation.AppearanceHeader.Options.UseTextOptions = true;
grdColShelfLocation.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColShelfLocation.Visible = true;
grdColShelfLocation.VisibleIndex = 1;
GridColumn grdColLocationName = new GridColumn();
grdColLocationName.Caption = "仓位名称";
grdColLocationName.FieldName = "LocationName";
grdColLocationName.Name = "grdColLocationName";
grdColLocationName.AppearanceHeader.Options.UseTextOptions = true;
grdColLocationName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdColLocationName.Visible = true;
grdColLocationName.VisibleIndex = 2;
searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColShelfNo, grdColShelfLocation, grdColLocationName });
searchLookUp.Properties.NullText = "";
searchLookUp.EnterMoveNextControl = true;
searchLookUp.Properties.ValueMember = valueMemberStr;
searchLookUp.Properties.DisplayMember = displayMemberStr;
if (addAllItem)
{
if (shelfInfoTable_True == null)
{
shelfInfoTable_True = commonDAO.QueryShelfInfo(true);
}
searchLookUp.Properties.DataSource = shelfInfoTable_True;
}
else
{
if (shelfInfoTable_false == null)
{
shelfInfoTable_false = commonDAO.QueryShelfInfo(false);
}
searchLookUp.Properties.DataSource = shelfInfoTable_false;
}
searchLookUp.Properties.View.IndicatorWidth = 60;
searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator;
searchLookUp.Properties.View.Tag = "Init";
}