110,561
社区成员
发帖
与我相关
我的任务
分享
private void A()
{
SqlConnection conn = new SqlConnection(
"server=.;" +
"database=TLTL;" +
"uid=sa;" +
"pwd=");
conn.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = conn;
sqlCmd.Transaction = conn.BeginTransaction();
if (!B(conn, sqlCmd))
{
sqlCmd.Transaction.Rollback();
return;
}
sqlCmd.Transaction.Commit();
MessageBox.Show("操作完毕!");
}
private bool B(SqlConnection conn, SqlCommand sqlCmd)
{
if ( ... )
{
if (!C(conn, sqlCmd))
{
MessageBox.Show("B中发生错误");
return false;
}
else
{
return true;
}
}
else
{
// ...
}
}
private bool C(SqlConnection conn, SqlCommand sqlCmd)
{
if ( ... )
{
MessageBox.Show("C中发生错误!");
return false;
}
else
{
sqlCmd.CommandText = "....";
sqlCmd.ExecuteNonQuery();
}
}
private void A()
{
SqlConnection conn = new SqlConnection(
"server=.;" +
"database=TLTL;" +
"uid=sa;" +
"pwd=");
conn.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = conn;
sqlCmd.Transaction = conn.BeginTransaction();
if (!B(conn, sqlCmd))
{
sqlCmd.Transaction.Rollback();
return;
}
sqlCmd.Transaction.Commit();
MessageBox.Show("操作完毕!");
}
private bool B(SqlConnection conn, SqlCommand sqlCmd)
{
if (!条件1)
{
if (!C(conn, sqlCmd))
{
MessageBox.Show("条件1不满足,不能保存");
return false;
}
else
{
return true;
}
}
else
{
// ...
}
}
private bool C(SqlConnection conn, SqlCommand sqlCmd)
{
if (!条件2)
{
MessageBox.Show("条件2不满足,不能保存!");
return false;
}
else
{
sqlCmd.CommandText = "....";
sqlCmd.ExecuteNonQuery();
}
}