/// <summary>
/// 获取商品清单
/// </summary>
/// <returns></returns>
public DataTable GetGoods()
{
string strSql = "select * from " + Goods.TableName;
strSql = @"SELECT A.*,B.name as 规格 FROM goods A
left join goods_type B on A.spec_id=B.id;";
return(DBConvertHelper.LoadDataTable(strSql));
}
/// <summary>
/// 获取商品库存
/// </summary>
/// <returns></returns>
public DataTable GetGoodsStock()
{
string strSql = "select * from stock";
strSql = @"SELECT A.id,A.name as 品名,B.name as 类型,B.spec,A.quantity
FROM goods A
left join goods_type B on A.spec_id=B.id;";
return(DBConvertHelper.LoadDataTable(strSql));
}
public DataTable GetInitCheckDetail()
{
string strSql = @"
select A.id,a.id as goods_id,A.code,A.name,A.unit,B.name as 类型名称,B.spec,A.quantity as raw_quantity,0 as quantity
from goods A
left join goods_type B on A.spec_id=B.id;
";
return(DBConvertHelper.LoadDataTable(strSql));
}
public DataTable GetCheckBillDetail(int billId)
{
string strSql = @"
select A.id,C.code,C.name,C.unit,D.name as 类型名称,D.spec,A.raw_quantity,A.quantity
from ((check_list_detail A left join check_list_bill as B on A.bill_id=B.id)
left join goods as C on A.goods_id=C.id)
left join goods_type as D on C.spec_id=D.id
where A.bill_id = " + billId;
return(DBConvertHelper.LoadDataTable(strSql));
}
/// <summary>
/// 获取规格型号
/// </summary>
/// <returns></returns>
public DataTable GetGoodsType()
{
string strSql = "select * from goods_type";
return(DBConvertHelper.LoadDataTable(strSql));
}
public DataTable GetCheckListBill()
{
string strSql = "select * from " + CheckListBill.TableName + " order by id desc";
return(DBConvertHelper.LoadDataTable(strSql));
}