private void SearchBtn_Click(object sender, EventArgs e)
{
try
{
List <int> weights = ListConvert.GetList(ListInput.Text);
if (weights.Count > 10)
{
throw new Exception();
}
int sumWeight = int.Parse(IntInput.Text);
ToolsList toolsList = new ToolsList();
List <List <int> > result = toolsList.SelectionCount(weights, sumWeight);
if (result.Count > 0)
{
Output.Text = ListConvert.GetString(result);
}
else
{
Output.Text = "комбинаций не найдено";
}
}
catch (Exception)
{
MessageBox.Show("ошибка ввода", "ошибка");
}
}
/// <summary>
/// 获取所有产品编号
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="ITEM_CD">产品编码</param>
/// <returns></returns>
public List <ProductDto> GetAllProductNum()
{
string sql = "SELECT t1.id,t1.ITEM_CD from product t1 ";
var dt = _db.ExecuteDataSet(CommandType.Text, sql).Tables[0];
var list = ListConvert.DtToList <ProductDto>(dt);
var distinctList = list.Distinct(new ProductComparer <ProductDto>()).ToList();
return(distinctList);
}
private void CalcBtn_Click(object sender, EventArgs e)
{
try
{
List <int> list = ListConvert.StringToList(ListInput.Text);
ListTls listTls = new ListTls(list);
List <int> listNew = listTls.GetNewList();
ListOut.Text = ListConvert.ListToString(listNew);
}
catch (Exception)
{
MessageBox.Show("ошибка ввода", "ошибка");
}
}
/// <summary>
/// 获取产品信息
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="ITEM_CD">产品编码</param>
/// <returns></returns>
public PagedList.PagedList <ProductDto> GetProductInfo(int pageNumber, int pageSize, string ITEM_CD)
{
string sql = "SELECT * from product";
if (!string.IsNullOrWhiteSpace(ITEM_CD))
{
sql += " WHERE item_cd =" + ITEM_CD;
}
var dt = _db.ExecuteDataSet(CommandType.Text, sql).Tables[0];
var list = ListConvert.DtToList <ProductDto>(dt);
for (int i = 0; i < list.Count; i++)
{
list[i].RowID = i + 1;
}
var pagelist = new PagedList.PagedList <ProductDto>(list, pageNumber, pageSize);
return(pagelist);
}
//以下为产品槽位明细信息-------------------------------
/// <summary>
/// 获取产品槽位明细
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="ITEM_CD">产品编码</param>
/// <returns></returns>
public PagedList.PagedList <ProductDetailDto> GetProductdetailInfo(int pageNumber, int pageSize, string ITEM_CD)
{
string sql = @"SELECT prodetail.* , pro.ITEM_CD , pro.ITEM_NM ,pro.MODEL_CD , pro.ITEM_COLOR
FROM productdetail prodetail
LEFT JOIN product pro ON pro.id = prodetail.productid";
if (!string.IsNullOrWhiteSpace(ITEM_CD))
{
sql += " WHERE pro.ITEM_CD = " + ITEM_CD;
}
var dt = _db.ExecuteDataSet(CommandType.Text, sql).Tables[0];
var list = ListConvert.DtToList <ProductDetailDto>(dt);
for (int i = 0; i < list.Count; i++)
{
list[i].RowID = i + 1;
}
var pagelist = new PagedList.PagedList <ProductDetailDto>(list, pageNumber, pageSize);
return(pagelist);
}
public IList <T> FindBySpecification(IMultiCriteriaSpecification <T> specification)
{
var results = specification.Criteria(Session).List();
return(ListConvert.ToGenericList <T>((IList)results[0]));
}
