Executing the stored procedure has no effect, but no error is reported, but the stored procedure executes normally in th

rcloud

Are you sure that the stored procedure is executed? In addition, have all your variables got values?
You can use SqlCommand ("exec P_JISUAN_ZHCJ '1', '2', '3', '4'", m_conn);
Test with constants first ...

摩羯可乐

cmd.CommandType = CommandType.StoredProcedure;
This execution shows that the stored procedure cannot be found

摩羯可乐

Wait, i try

hangcool

public static bool DealData (params string [] QueryStrings) {
ConnectionString.Open ();
SqlTransaction SqlTrans = ConnectionString.BeginTransaction ();
SqlCommand Command = new SqlCommand ();
Command.Connection = ConnectionString;
Command.Transaction = SqlTrans;
try
{
for (int i = 0; i <QueryStrings.Length; i ++)
{
    Command.CommandText = QueryStrings [i];
    if (Command.ExecuteNonQuery () == 0)
    return false;
}
    SqlTrans.Commit ();
    return true;
}
catch
{
    SqlTrans.Rollback ();
    return false;
}
finally
{
    ConnectionString.Close ();
    Command.Dispose ();
}
}

摩羯可乐

to:rcloud
Not working alone

rcloud

SqlConnection conn = new SqlConnection (ConfigurationSettings.AppSettings ["CrmSqlConnect"];);
SqlCommand cmd = new SqlCommand ();
cmd.Connection = conn;
conn.Open ();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_corp_list_editresultcx";
cmd.Parameters.Add ("@ faid", SqlDbType.NVarChar (100)). Value = faid;
cmd.Parameters.Add ("@ bjid", SqlDbType.NVarChar (100))). Value = bjid;
.....
cmd.ExecuteNonQuery ();
SqlDataReader dr = cmd.ExecuteReader ();

rcloud

The above is wrong here ...
cmd.CommandText = "P_JISUAN_ZHCJ";

rcloud

SqlConnection conn = new SqlConnection (ConfigurationSettings.AppSettings ["CrmSqlConnect"]);
SqlCommand cmd = new SqlCommand ();
cmd.Connection = conn;
conn.Open ();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_corp_list_editresultcx";
cmd.Parameters.Add ("@ faid", SqlDbType.NVarChar) .Value = faid;
cmd.Parameters.Add ("@ bjid", SqlDbType.NVarChar) .Value = bjid;
cmd.Parameters.Add ("@ xsid", SqlDbType.NVarChar) .Value = xsid;
cmd.Parameters.Add ("@ error", SqlDbType.NVarChar) .Value = error;
cmd.ExecuteNonQuery ();

阿基米德碎片

@ _ @

摩羯可乐

Or not