事务处理中的两条insert 语句解决思路

    public static bool AddOrder(string order_ID, string customer_ID, string delivery_date, string remark, string door_type, string door_color, string door_H, string door_W, string shutter_type, string shutter_H, string top_front_glass_type, string bottom_behind_glass_type, string top_front_glass_style, string door_collapse, string door_glass_mode, string amount)    {        bool flag = true;        SqlConnection con = DataBase.CreateCon();        con.Open();        SqlCommand cmd = new SqlCommand();        cmd.Connection = con;        SqlTransaction Sqltrans = con.BeginTransaction();        cmd.Transaction = Sqltrans;        try        {            cmd.CommandText = "insert into [order](order_ID,customer_ID,delivery_date,remark) values(@order_ID,@customer_ID,@delivery_date,@remark)";            SqlParameter para = new SqlParameter("@order_ID", SqlDbType.VarChar, 20);            para.Value = order_ID;            cmd.Parameters.Add(para);            para = new SqlParameter("@customer_ID", SqlDbType.VarChar, 50);            para.Value = customer_ID;            cmd.Parameters.Add(para);            para = new SqlParameter("@delivery_date", SqlDbType.DateTime);            para.Value = Convert.ToDateTime(delivery_date);            cmd.Parameters.Add(para);            para = new SqlParameter("@remark", SqlDbType.VarChar, 200);            para.Value = remark;            cmd.Parameters.Add(para);            cmd.ExecuteNonQuery();            cmd.CommandText = "insert into product(order_ID,door_type,door_color,door_H,door_W,shutter_type,shutter_H,top_front_glass_type,bottom_behind_glass_type,top_front_glass_style,door_collapse,door_glass_mode,amount) values(@order_ID,@door_type,@door_color,@door_H,@door_W,@shutter_type,@shutter_H,@top_front_glass_type,@bottom_behind_glass_type,@top_front_glass_style,@door_collapse,@door_glass_mode,@amount)";            para = new SqlParameter("@order_ID", SqlDbType.VarChar, 20);            para.Value = order_ID;            cmd.Parameters.Add(para);            para = new SqlParameter("@door_type", SqlDbType.VarChar, 50);            para.Value = door_type;            cmd.Parameters.Add(para);            para = new SqlParameter("@door_color", SqlDbType.VarChar, 50);            para.Value = door_color;            cmd.Parameters.Add(para);            para = new SqlParameter("@door_H", SqlDbType.Float);            para.Value = Convert.ToDouble(door_H);            cmd.Parameters.Add(para);            para = new SqlParameter("@door_W", SqlDbType.Float);            para.Value = Convert.ToDouble(door_W);            cmd.Parameters.Add(para);            para = new SqlParameter("@shutter_type", SqlDbType.VarChar, 50);            para.Value = shutter_type;            cmd.Parameters.Add(para);            para = new SqlParameter("@shutter_H", SqlDbType.Float);            para.Value = Convert.ToDouble(shutter_H);            cmd.Parameters.Add(para);            para = new SqlParameter("@top_front_glass_type", SqlDbType.VarChar, 50);            para.Value = top_front_glass_type;            cmd.Parameters.Add(para);            para = new SqlParameter("@bottom_behind_glass_type", SqlDbType.VarChar, 50);            para.Value = bottom_behind_glass_type;            cmd.Parameters.Add(para);            para = new SqlParameter("@top_front_glass_style", SqlDbType.VarChar, 50);            para.Value = top_front_glass_style;            cmd.Parameters.Add(para);            para = new SqlParameter("@door_collapse", SqlDbType.VarChar, 50);            para.Value = door_collapse;            cmd.Parameters.Add(para);            para = new SqlParameter("@door_glass_mode", SqlDbType.VarChar, 50);            para.Value = door_glass_mode;            cmd.Parameters.Add(para);            para = new SqlParameter("@amount", SqlDbType.Int);            para.Value = amount;            cmd.Parameters.Add(para);            cmd.ExecuteNonQuery();            Sqltrans.Commit();        }        catch        {            Sqltrans.Rollback();            flag = false;        }        finally        {            con.Close();                    }        return flag;    }