/// <summary>
/// 查询原材料类别
/// </summary>
/// <returns></returns>
public static DataTable SelectMareriaType()
{
sql = " select mt.Id as Id,mt.Type as Type from MareriaType mt inner join MarerialKind mk on mt.Pid=mk.Id";
return(SqlHelper.GetTableToSqlserver(sql, ref error));
}
/// <summary>
/// 查询基础工序
/// </summary>
/// <returns></returns>
public static DataTable SelectWorkSn()
{
sql = " select * from WorkSn ";
return(SqlHelper.GetTableToSqlserver(sql, ref error));
}
/// <summary>
/// 查询付款方式
/// </summary>
/// <returns></returns>
public static DataTable SelectPaymentMode()
{
sql = " select * from PaymentMode ";
return(SqlHelper.GetTableToSqlserver(sql, ref error));
}
/// <summary>
/// 查询原材料种类
/// </summary>
/// <returns></returns>
public static DataTable SelectMarerialKind()
{
sql = " select * from MarerialKind ";
return(SqlHelper.GetTableToSqlserver(sql, ref error));
}
/// <summary>
/// 查询收款方式
/// </summary>
/// <returns></returns>
public static DataTable CheckHave()
{
sql = " select * from MakeCollectionsMode ";
return(SqlHelper.GetTableToSqlserver(sql, ref error));
}
