//EXEC [dbo].[ASK_SN] @LINE = N'JUNIOR', @OP = 750, @PN = N'26111047', @SN = N'26111047062173033700'
public SqlDataReader Ask_SN(string line, string op, string pn, string sn)
{
var paramList = new List <SqlParameter>
{
new SqlParameter("@LINE", VarChar, 50)
{
Value = line, IsNullable = false
},
new SqlParameter("@OP", Int)
{
Value = op, IsNullable = false
},
new SqlParameter("@PN", VarChar, 50)
{
Value = pn, IsNullable = true
},
new SqlParameter("@SN", VarChar, 50)
{
Value = sn, IsNullable = false
}
};
return(_msSql.ExecuteReader("[dbo].[ASK_SN]", CommandType.StoredProcedure, paramList.ToArray()));
}
