/// <summary>
/// 得到某条件下的所有选项值
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public DataTable GetConditionValueByQuery(ProductAccessoriesConditionValueQueryFilter query)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetConditionValueByQuery");
cmd.SetParameterValue("@ConditionSysNo", query.ConditionSysNo);
cmd.SetParameterValue("@MasterSysNo", query.MasterSysNo);
return(cmd.ExecuteDataTable());
}
/// <summary>
/// 得到导出EXECL的数据
/// </summary>
/// <param name="MasterSysNo"></param>
/// <param name="IsTreeQuery"></param>
/// <param name="callback"></param>
public void GetAccessoriesQueryExcelOutput(int MasterSysNo, string IsTreeQuery, ColumnSet[] columns)
{
ProductAccessoriesConditionValueQueryFilter query = new ProductAccessoriesConditionValueQueryFilter()
{
MasterSysNo = MasterSysNo,
IsTreeQuery = IsTreeQuery
};
restClient.ExportFile(GetAccessoriesQueryExcelOutputUrl, query, columns);
}
/// <summary>
/// 得到某个条件下的所有选项值
/// </summary>
/// <param name="ConditionSysNo"></param>
/// <param name="MasterSysNo"></param>
/// <param name="callback"></param>
public void GetConditionValueByQuery(int ConditionSysNo, int MasterSysNo, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductAccessoriesConditionValueQueryFilter query = new ProductAccessoriesConditionValueQueryFilter()
{
ConditionSysNo = ConditionSysNo,
MasterSysNo = MasterSysNo,
};
restClient.QueryDynamicData(GetConditionValueByQueryUrl, query, callback);
}
public QueryResult GetAccessoriesQueryExcelOutput(ProductAccessoriesConditionValueQueryFilter query)
{
var dataTable = ObjectFactory <IProductAccessoriesDA> .Instance.GetAccessoriesQueryExcelOutput(query);
return(new QueryResult
{
Data = dataTable,
TotalCount = 1
});
}
public QueryResult GetProductAccessoriesConditionValueByCondition(ProductAccessoriesConditionValueQueryFilter query)
{
var dataTable = ObjectFactory <IProductAccessoriesDA> .Instance.GetProductAccessoriesConditionValueByConditionSysNo(query);
return(new QueryResult
{
Data = dataTable,
TotalCount = 0
});
}
public QueryResult GetProductAccessoriesConditionValueByQuery(ProductAccessoriesConditionValueQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductAccessoriesDA> .Instance.GetProductAccessoriesConditionValueByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 根据query获取选项值
/// </summary>
/// <param name="Query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetProductAccessoriesConditionValueByQuery(ProductAccessoriesConditionValueQueryFilter Query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductAccessoriesConditionValueByQuery");
cmd.SetParameterValue("@ConditionSysNo", Query.ConditionSysNo);
cmd.SetParameterValue("@ConditionValue", Query.ConditionValue);
cmd.SetParameterValue("@MasterSysNo", Query.MasterSysNo);
cmd.SetParameterValue("@SortField", Query.PagingInfo.SortBy);
cmd.SetParameterValue("@PageSize", Query.PagingInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", Query.PagingInfo.PageIndex);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable();
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
/// <summary>
/// 根据query获取选项值
/// </summary>
/// <param name="mode"></param>
/// <param name="callback"></param>
public void GetProductAccessoriesConditionValueByQuery(ProductAccessoriesConditionValueQueryVM mode, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductAccessoriesConditionValueQueryFilter query = new ProductAccessoriesConditionValueQueryFilter()
{
ConditionSysNo = mode.Condition.SysNo,
ConditionValue = mode.ConditionValue.ConditionValue,
MasterSysNo = mode.MasterSysNo,
PagingInfo = new PagingInfo()
{
PageIndex = PageIndex,
PageSize = PageSize,
SortBy = SortField
}
};
restClient.QueryDynamicData(GetProductAccessoriesConditionValueByQueryUrl, query, callback);
}
public DataTable GetAccessoriesQueryExcelOutput(ProductAccessoriesConditionValueQueryFilter query)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetAccessoriesQueryExcelOutput");
cmd.SetParameterValue("@MasterSysNo", query.MasterSysNo);
cmd.SetParameterValue("@IsTreeQuery", query.IsTreeQuery);
DataTable dt = cmd.ExecuteDataTable();
if (dt.Rows.Count == 0)
{
var row = dt.NewRow();
dt.Rows.Add(row);
dt.Rows[0][0] = 0;
dt.Rows[0][1] = "No data records.";
}
return(dt);
}
