/// <summary>
/// 绑定查询数据。
/// </summary>
public void BindData()
{
OnlineMaterialQueryModel model = new OnlineMaterialQueryModel(this.Model);
if (string.IsNullOrEmpty(model.StoreName))
{
model.StoreName = PropertyService.Get(PROPERTY_FIELDS.STORES);
}
if (string.IsNullOrEmpty(model.OperationName))
{
model.OperationName = PropertyService.Get(PROPERTY_FIELDS.OPERATIONS);
}
PagingQueryConfig config = new PagingQueryConfig()
{
PageNo = pgnQueryResult.PageNo,
PageSize = pgnQueryResult.PageSize
};
DataSet dsReturn = this._entity.Query(model, ref config);
pgnQueryResult.Pages = config.Pages;
pgnQueryResult.Records = config.Records;
if (!string.IsNullOrEmpty(this._entity.ErrorMsg))
{
MessageService.ShowMessage(this._entity.ErrorMsg);
return;
}
if (dsReturn.Tables.Count > 0)
{
gcResult.DataSource = dsReturn.Tables[0];
gcResult.MainView = gvResult;
gvResult.BestFitColumns();
}
}
/// <summary>
/// 构造函数。
/// </summary>
public OnlineMaterialQueryCtrl()
{
InitializeComponent();
this.Model = new OnlineMaterialQueryModel();
InitializeLanguage();
GridViewHelper.SetGridView(gvResult);
GridViewHelper.SetGridView(gvResultDetail);
}
/// <summary>
/// 查询在线物料明细信息。
/// </summary>
/// <param name="model">
/// 包含查询条件对象。
/// </param>
/// <param name="storeMaterialKey">
/// 在线物料主键
/// </param>
/// <returns>包含在线物料信息的数据集。</returns>
public DataSet QueryDetail(OnlineMaterialQueryModel model, string storeMaterialKey)
{
DataSet dsReturn = new DataSet();
StringBuilder sbSql = new StringBuilder();
try
{
sbSql.Append(@"SELECT A.STORE_MATERIAL_KEY,
A.MATERIAL_LOT,
A.CURRENT_QTY,
A.MATERIAL_SUPPLIER,
D.UNIT
FROM WST_STORE_MATERIAL_DETAIL A
LEFT JOIN WST_STORE_MATERIAL B ON A.STORE_MATERIAL_KEY=B.STORE_MATERIAL_KEY
LEFT JOIN WST_STORE C ON B.STORE_KEY=C.STORE_KEY
LEFT JOIN POR_MATERIAL D ON B.MATERIAL_KEY=D.MATERIAL_KEY
LEFT JOIN FMM_LOCATION E ON C.LOCATION_KEY=E.LOCATION_KEY
WHERE CURRENT_QTY>0 ");
if (!string.IsNullOrEmpty(model.OperationName))
{
sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.OPERATION_NAME", model.OperationName.Split(',')));
}
if (!string.IsNullOrEmpty(model.StoreName))
{
sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.STORE_NAME", model.StoreName.Split(',')));
}
if (!string.IsNullOrEmpty(model.MaterialCode))
{
sbSql.AppendFormat(" AND D.MATERIAL_CODE LIKE '{0}%'", model.MaterialCode.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.MaterialLot))
{
sbSql.AppendFormat(" AND A.MATERIAL_LOT LIKE '{0}%'", model.MaterialLot.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.RoomName))
{
sbSql.AppendFormat(" AND E.LOCATION_NAME LIKE '{0}%'", model.RoomName.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.SupplierName))
{
sbSql.AppendFormat(" AND A.MATERIAL_SUPPLIER LIKE '{0}%'", model.SupplierName.PreventSQLInjection());
}
sbSql.AppendFormat(" AND A.STORE_MATERIAL_KEY = '{0}'", storeMaterialKey.PreventSQLInjection());
dsReturn = this.db.ExecuteDataSet(CommandType.Text, sbSql.ToString());
ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty);
}
catch (Exception ex)
{
ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("SearchLotList Error: " + ex.Message);
}
return(dsReturn);
}
/// <summary>
/// 查询在线物料明细信息。
/// </summary>
/// <param name="model">
/// 包含查询条件对象。
/// </param>
/// <param name="storeMaterialKey">
/// 在线物料主键
/// </param>
/// <returns>包含在线物料信息的数据集。</returns>
public DataSet QueryDetail(OnlineMaterialQueryModel model, string storeMaterialKey)
{
DataSet dsReturn = null;
try
{
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
dsReturn = serverFactory.CreateIOnlineMaterialQueryEngine().QueryDetail(model, storeMaterialKey);
_errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
}
catch (Exception ex)
{
_errorMsg = ex.Message;
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(dsReturn);
}
private void gvResult_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e)
{
OnlineMaterialQueryModel model = new OnlineMaterialQueryModel(this.Model);
if (string.IsNullOrEmpty(model.StoreName))
{
model.StoreName = PropertyService.Get(PROPERTY_FIELDS.STORES);
}
if (string.IsNullOrEmpty(model.OperationName))
{
model.OperationName = PropertyService.Get(PROPERTY_FIELDS.OPERATIONS);
}
DataRow dr = this.gvResult.GetDataRow(e.RowHandle);
string storeMaterialKey = Convert.ToString(dr["STORE_MATERIAL_KEY"]);
DataSet dsReturn = this._entity.QueryDetail(model, storeMaterialKey);
if (!string.IsNullOrEmpty(this._entity.ErrorMsg))
{
MessageService.ShowMessage(this._entity.ErrorMsg);
return;
}
e.ChildList = dsReturn.Tables[0].DefaultView;
}
/// <summary>
/// 构造函数。
/// </summary>
public OnlineMaterialQueryDialog()
{
InitializeComponent();
this.Model = new OnlineMaterialQueryModel();
InitializeLanguage();
}
/// <summary>
/// 查询在线物料。
/// </summary>
/// <param name="model">查询条件。</param>
/// <param name="pconfig">分页对象。</param>
/// <returns>包含在线物料信息的数据集对象。</returns>
public DataSet Query(OnlineMaterialQueryModel model, ref PagingQueryConfig pconfig)
{
DataSet dsReturn = new DataSet();
StringBuilder sbSql = new StringBuilder();
try
{
sbSql.Append(@"SELECT A.STORE_MATERIAL_KEY ,
SUM(A.CURRENT_QTY)AS QTY,
C.STORE_NAME AS STORE_NAME,
D.MATERIAL_CODE AS MATERIAL_CODE,
D.MATERIAL_NAME AS MATERIAL_NAME,
D.UNIT AS UNIT,
E.LOCATION_NAME AS ROOM_NAME,
C.OPERATION_NAME AS OPERATION_NAME
FROM WST_STORE_MATERIAL_DETAIL A
LEFT JOIN WST_STORE_MATERIAL B ON A.STORE_MATERIAL_KEY=B.STORE_MATERIAL_KEY
LEFT JOIN WST_STORE C ON B.STORE_KEY=C.STORE_KEY
LEFT JOIN POR_MATERIAL D ON B.MATERIAL_KEY=D.MATERIAL_KEY
LEFT JOIN FMM_LOCATION E ON C.LOCATION_KEY=E.LOCATION_KEY
WHERE CURRENT_QTY>0 ");
if (!string.IsNullOrEmpty(model.OperationName))
{
sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.OPERATION_NAME", model.OperationName.Split(',')));
}
if (!string.IsNullOrEmpty(model.StoreName))
{
sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.STORE_NAME", model.StoreName.Split(',')));
}
if (!string.IsNullOrEmpty(model.MaterialCode))
{
sbSql.AppendFormat(" AND D.MATERIAL_CODE LIKE '{0}%'", model.MaterialCode.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.MaterialLot))
{
sbSql.AppendFormat(" AND A.MATERIAL_LOT LIKE '{0}%'", model.MaterialLot.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.RoomName))
{
sbSql.AppendFormat(" AND E.LOCATION_NAME LIKE '{0}%'", model.RoomName.PreventSQLInjection());
}
if (!string.IsNullOrEmpty(model.SupplierName))
{
sbSql.AppendFormat(" AND A.MATERIAL_SUPPLIER LIKE '{0}%'", model.SupplierName.PreventSQLInjection());
}
sbSql.Append(@" GROUP BY A.STORE_MATERIAL_KEY,C.STORE_NAME,D.MATERIAL_CODE,E.LOCATION_NAME,
D.MATERIAL_NAME,D.UNIT, E.LOCATION_NAME,C.OPERATION_NAME ");
int pages = 0;
int records = 0;
AllCommonFunctions.CommonPagingData(sbSql.ToString(),
pconfig.PageNo,
pconfig.PageSize,
out pages,
out records,
db,
dsReturn,
"WST_STORE_MATERIAL",
"MATERIAL_CODE ASC");
pconfig.Pages = pages;
pconfig.Records = records;
ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty);
}
catch (Exception ex)
{
ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("SearchLotList Error: " + ex.Message);
}
return(dsReturn);
}
