public DataSet GetDefaultApprovalLineMody(string stridx)
{
DataSet ds = new DataSet();
SqlConnection objCon = null;
SqlCommand objCmd = null;
SqlDataAdapter objAdpt = null;
try
{
objCon = new SqlConnection(strConnection);
objCon.Open();
objCmd = objCon.CreateCommand();
objCmd.CommandText = "sp_get_approval_line";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(new SqlParameter("@idn", stridx));
objCmd.Parameters.Add(new SqlParameter("@LoginID", txtLoginUser.Text));
objCmd.Parameters.Add(new SqlParameter("@circuit_seq", txtCircuitSeq.Text));
objAdpt = new SqlDataAdapter();
objAdpt.SelectCommand = objCmd;
objAdpt.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objCmd != null)
{
objCmd.Dispose();
}
if (objCon != null)
{
if (objCon.State != ConnectionState.Closed) objCon.Close();
objCon.Dispose();
}
}
return ds;
}
댓글 없음:
댓글 쓰기