//检测routing
private void button2_Click(object sender, EventArgs e)
{
lock (objLock)//COMPSN_P80
{
string strConn = "Data Source=172.26.40.6;Initial Catalog=PAL_COMPSN_P80;User ID=TestUser;Password=Test*#PWD";
string sql = "MonitorPortal";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@BU", SqlDbType.VarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Station", SqlDbType.VarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Step", SqlDbType.VarChar, 20));
cmd.Parameters.Add(new SqlParameter("@InPutStr", SqlDbType.VarChar, 1000));
cmd.Parameters.Add(new SqlParameter("@OutPutStr", SqlDbType.VarChar, 300));
//Init Parameter
cmd.Parameters["@BU"].Value = "PU6_SZ";//
cmd.Parameters["@Station"].Value = "AJUV";//
cmd.Parameters["@Step"].Value = "Request";//
cmd.Parameters["@InPutStr"].Value = "Top Case=" + textBox_SN.Text + ";$;Line=A16";//
cmd.Parameters["@OutPutStr"].Direction = ParameterDirection.Output;
try
{
conn.Open();
cmd.ExecuteNonQuery();
textBox_Routing.Text = cmd.Parameters["@OutPutStr"].Value.ToString();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
}