public DataTable GetMultiServiceNo(PL_StickerPrint objpl)
{
DataTable dt = new DataTable();
dt = objdl.GetMultiServiceNo(objpl);
return(dt);
}
internal DataTable GetMultiServiceNo(PL_StickerPrint objpl)
{
try
{
con = new SqlConnection();
da = new SqlDataAdapter();
// Ds = new DataSet();
dt = new DataTable();
con = DBConnection.SQLConn();
cmd = new SqlCommand("SpStickerPrint", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objpl.Ind);
cmd.Parameters.AddWithValue("@ServiceNoFrom", objpl.ServiceNoFrom);
cmd.Parameters.AddWithValue("@ServiceNoTo", objpl.ServiceNoTo);
da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count > 0)
{
}
else
{
dt = null;
}
}
else
{
dt = null;
}
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Dispose();
con.Close();
}
}
return(dt);
}
